linking excel spreadsheets between one computer and a remote server

M

mf

Does anyone know how I can have a system whereby my entries on my
desktop (MAC) can be automatically linked and therefore updated in
another Excel file on a website?

I'd appreciate any help with this.

Regards.
 
J

Jim Gordon MVP

Hi,

I'm certain, but I think you are seeking information about this feature
(copied from Excel's help)

Automatically save Excel data to a Web page
1. Open the workbook or select the worksheet data you want to save on a Web
page.
2. On the File menu, click Save as Web Page.
3. Use the column browser to find the folder you want, and then double-click
the folder.
4. In the Save As box, type a name for the document.
5. Do one of the following:
€ If you want to save an entire workbook, click Workbook.
€ If you want to save a worksheet as a Web page, click Sheet.
€ If you want to save data you selected, click Selectio6. Click Automate.
7. In the Automate dialog box, click Every time this workbook is saved, and
then click OK.
8. Click Save.

Is this it?

-Jim Gordon
Mac MVP

Does anyone know how I can have a system whereby my entries on my
desktop (MAC) can be automatically linked and therefore updated in
another Excel file on a website?

I'd appreciate any help with this.

Regards.

--
Jim Gordon
Mac MVP

MVPs are not Microsoft Employees
MVP info
 
M

mf

Hi Jim,

Thanks for responding. Actually no, this isn't it. I want to make
changes to my spreadsheet at home and have the changes automatically
update a spreadsheet on the webserver.

Ps. what are the steps to becoming an MVP?

Regards

Farzad
 
J

JE McGimpsey

mf said:
Thanks for responding. Actually no, this isn't it. I want to make
changes to my spreadsheet at home and have the changes automatically
update a spreadsheet on the webserver.

Can you work directly with the file on the server from home? That would
be the easiest way by far.

Otherwise you probably need to specify a bit more what you mean by
"update". Are you working with an exact copy of the server file at home
(and if so, why will Jim's suggestion not work)? Or is it a different
workbook that needs to pull info from your home copy?
Ps. what are the steps to becoming an MVP?

There are no specific steps. Most of the MVPs were given the award for
their extensive participation in these newsgroups or the Entourage
mailing list. See
 
J

Jim Gordon MVP

Hi Farzad,

The way I mentioned is but one of several different approaches you could
take. If you want to keep a local copy and synchronize with the web server,
that is possible, too.

Would you like the web server to deliver an xls or a web page? How do you
connect to the server now?

-Jim Gordon
Mac MVP


Hi Jim,

Thanks for responding. Actually no, this isn't it. I want to make
changes to my spreadsheet at home and have the changes automatically
update a spreadsheet on the webserver.

Ps. what are the steps to becoming an MVP?

Regards

Farzad

--
Jim Gordon
Mac MVP

MVPs are not Microsoft Employees
MVP info
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top