Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / December 2004

Tip: Looking for answers? Try searching our database.

Master List Losing Record Due to Update from Links

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Kenneth CN - 06 Dec 2004 19:34 GMT
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.
crazybass2 - 07 Dec 2004 00:01 GMT
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.

> I have a master document that is linked to 7 other excel
> sheets. Now the other excel sheets are modified by
[quoted text clipped - 6 lines]
>
> Please any help would be highly appreciated.
Kenneth - 07 Dec 2004 16:11 GMT
Hi,

Thanks for your response. I honestly do not know how the
sheets are linked. Could you please tell me how to find
out this?

I have not worked with excel extensively, but I am a quick
learner.

Also, of all thew linking styles, which one do you advise
that I use for new projects that are similar to this?

They are asking me to design a new one based on my
understanding of the existing one...so any help would be
highly appreciated.

Thanks!

Ken
>-----Original Message-----
>Kenneth,
[quoted text clipped - 15 lines]
>>
>.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.