#1   Report Post  
Old July 6th 07, 08:08 AM posted to microsoft.public.excel.misc
BMA BMA is offline
external usenet poster
 
First recorded activity by ExcelBanter: Nov 2006
Posts: 7
Default 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   Report Post  
Old July 6th 07, 12:20 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 35,218
Default 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   Report Post  
Old July 6th 07, 12:46 PM posted to microsoft.public.excel.misc
BMA BMA is offline
external usenet poster
 
First recorded activity by ExcelBanter: Nov 2006
Posts: 7
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
updating links Laura Jean Excel Worksheet Functions 1 August 19th 06 11:07 AM
Updating Links WhytheQ Excel Discussion (Misc queries) 7 June 1st 06 11:25 AM
updating links dave glynn Excel Discussion (Misc queries) 1 March 2nd 06 08:28 PM
Links updating? Kimmerz321 Excel Discussion (Misc queries) 3 September 1st 05 01:31 PM
Updating links Mike Links and Linking in Excel 1 August 17th 05 01:04 PM


All times are GMT +1. The time now is 12:33 PM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017