Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I synchronize changes in multiple workbook?
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I synchronize changes in multiple workbook?
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... -- HTH... Jim Thomlinson "StevenT" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to synchronize data value across two worksheets in one workbook? | Excel Worksheet Functions | |||
synchronize between sheets | Excel Worksheet Functions | |||
how do I synchronize shared workbook feature in WSS? | Excel Discussion (Misc queries) | |||
synchronize multiple worksheets | Excel Worksheet Functions | |||
HOW DO i SYNCHRONIZE MULTIPLE WORKSHEETS IN EXCEL? | New Users to Excel |