ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Updating links (https://www.excelbanter.com/excel-discussion-misc-queries/149171-updating-links.html)

BMA July 6th 07 08:08 AM

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?

Dave Peterson July 6th 07 12:20 PM

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

BMA July 6th 07 12:46 PM

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



All times are GMT +1. The time now is 06:26 AM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
ExcelBanter.com