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

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