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

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

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

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 02:50 PM.

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