How can I synchronize changes in multiple workbook?

  • Thread starter Thread starter StevenT
  • Start date Start date
S

StevenT

I want to keep copies of a given file in different locations, one in My
Documents and one in a shared drive (with a password). Is there a set up so
that changes I make to my copy are also made to the shared drive copy at the
same time?

Thanks
 
The short answer is no... Modifications made to one book are exclusive and
can not be shared with other books. You could copy the books back and forth
as necessary. Depending what you are doing a mcaro might work for you but it
would probably be very long and ugly to code...
 
You must log in or register to reply here.

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

Similar Threads

Syncthing --- a continuous file synchronization program. 4
Merge Multiple workbook sheets into one workbook 0
Sharing workbooks limitations - Merged Cells 12
Excel Protection 2
workbook qustion 1
corrupted shared excel workbook 1
Email Excel Workbook Automatically Daily 3
VB Code to Share Workbook 2

Back
Top