Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How to merge changes on a non-shared workbook
Hi,
I sent out the same file to a large number of users, each had specific lines on the file that needed to be updated so no changes would be duplicates. I did NOT send the file as a shared workbook so now I have a large number of files that do not automatically update the original. Is there anyway I can update my master file with all of the changes automatically? -- Thank You, Steve |
#2
|
|||
|
|||
Hi Steve,
It's likely that you _can_ do that, but it might be difficult and labor intensive.. Without more information on how the original workbook and the returned files are structured, it's tough to offer specific advice. My guess is that you'll want to use information in the original workbook that enables you to identify the user who returned updates, and thus something such as ='[Income Statement Per Accounting.xls]Sheet1'!$B$148. Even though you now might have a problem, you were right not to use a shared workbook. From the cheap seats: I might have converted the workbook to an Access database and sent my users a shortcut to that file. So doing would avoid the problems inherent in a shared workbook, but would also enable the multiple simultaneous users to make their changes to one-and-only-one file. C^2 Conrad Carlberg -- Excel Sales Forecasting for Dummies, Wiley, 2005 "Steve D" wrote in message ... Hi, I sent out the same file to a large number of users, each had specific lines on the file that needed to be updated so no changes would be duplicates. I did NOT send the file as a shared workbook so now I have a large number of files that do not automatically update the original. Is there anyway I can update my master file with all of the changes automatically? -- Thank You, Steve |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
using forms in a shared workbook | Excel Worksheet Functions | |||
My Shared workbook is driving me crazy!!! | Excel Discussion (Misc queries) | |||
Shared workbook - one at a time? | Excel Discussion (Misc queries) | |||
Shared workbook protection | Excel Discussion (Misc queries) | |||
Problem with shared workbook (history sheet) | Excel Worksheet Functions |