Linking sheets

[nikb_mt]

I am working on a spreadsheet. I have one copy saved to my desktop, and the other copy saved on a private server. How can I get this set set up if I change anything to the copy that's saved on my desktop to automatically update the copy that's set up on my server?

thanks

 

[Smitty]

Take a look at something like Microsoft's Skydrive service, or Dropbox.com. Both allow you to sync files.

HTH,

 

[nikb_mt]

That's the only way? There's got to be some other options.

 

[Smitty]

It's not the only way, but probably the easiest.

You could always use VBA to Save your current wb, then SaveAs to replace the remote copy. You can record a macro doing that. From there you just need to figure out how you want to trigger it.

 

[nikb_mt]

I see. I was just curious, because I used to build spreadsheets all the time, and I had to build charts from data on another workbook. And when I would update the statistics the charts would automatically reflect those changes.

 

[Smitty]

That's direct referencing. It's a little bit different than syncing a copy of a workbook, in that you only need to link the data cells for the chart, not the entire workbook.