Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Updating links
i have three spreadsheets that report into one as a summary. when i open the
summary sheet a message appears that says some or more of the links cannot be updated. Yet when i go to the edit links page all the links have a status of "ok". what is the problem here? can i be sure that all the data is being updated? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Updating links
Maybe Bill Manville's FindLink program can help you find the problem link:
http://www.oaltd.co.uk/MVP/Default.htm BMA wrote: i have three spreadsheets that report into one as a summary. when i open the summary sheet a message appears that says some or more of the links cannot be updated. Yet when i go to the edit links page all the links have a status of "ok". what is the problem here? can i be sure that all the data is being updated? -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Updating links
Thanks Dave, that worked perfectly. Bloody easy too.
Cheers "Dave Peterson" wrote: Maybe Bill Manville's FindLink program can help you find the problem link: http://www.oaltd.co.uk/MVP/Default.htm BMA wrote: i have three spreadsheets that report into one as a summary. when i open the summary sheet a message appears that says some or more of the links cannot be updated. Yet when i go to the edit links page all the links have a status of "ok". what is the problem here? can i be sure that all the data is being updated? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
updating links | Excel Worksheet Functions | |||
Updating Links | Excel Discussion (Misc queries) | |||
updating links | Excel Discussion (Misc queries) | |||
Links updating? | Excel Discussion (Misc queries) | |||
Updating links | Links and Linking in Excel |