Kenneth,
Sounds like the "post" command that you have is overwriting data on the
master. How are you posting data from the 7 others onto the master? Macro?
Without knowing it's hard to tell what's really going on.
"Kenneth CN" wrote:
I have a master document that is linked to 7 other excel
sheets. Now the other excel sheets are modified by
different users and the master document is for generating
reports.
But I found out that whenever new records are added in the
attached excel sheets, I lose some data from the Master
sheet.
Please any help would be highly appreciated.
|