linking excel spreadsheets between one computer and a remote server

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

mf - 01 Feb 2007 22:35 GMT

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.

Reply to this Message

Jim Gordon MVP - 02 Feb 2007 01:50 GMT

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

Quoting from "mf" <farzaadeafxami@gmail.com>, in article
1170369326.206693.156140@k78g2000cwa.googlegroups.com, on [DATE:

> Does anyone know how I can have a system whereby my entries on my
> desktop (MAC) can be automatically linked and therefore updated in
[quoted text clipped - 3 lines]
>
> Regards.

Signature

Jim Gordon
Mac MVP

MVPs are not Microsoft Employees
MVP info http://mvp.support.microsoft.com/

Reply to this Message

mf - 24 Feb 2007 02:23 GMT

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

On Feb 1, 5:50 pm, Jim Gordon MVP <goldke...@WarmerThanWarmMail.com>
wrote:

> Hi,
>
[quoted text clipped - 38 lines]
> MVPs are not Microsoft Employees
> MVP infohttp://mvp.support.microsoft.com/

Reply to this Message

JE McGimpsey - 24 Feb 2007 09:37 GMT

> 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

http://mvp.support.microsoft.com/

Reply to this Message

Jim Gordon MVP - 25 Feb 2007 00:08 GMT

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

Quoting from "mf" <farzaadeafxami@gmail.com>, in article
1172283821.544188.106810@k78g2000cwa.googlegroups.com, on [DATE:

> Hi Jim,
>
[quoted text clipped - 52 lines]
>> MVPs are not Microsoft Employees
>> MVP infohttp://mvp.support.microsoft.com/

Signature

Jim Gordon
Mac MVP

MVPs are not Microsoft Employees
MVP info http://mvp.support.microsoft.com/

Reply to this Message

Mac Forum / Applications / Excel / February 2007

linking excel spreadsheets between one computer and a remote server