#1   Report Post  
Old August 18th 06, 10:27 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Aug 2006
Posts: 1
Default updating links

Upon opening a file, I am asked to update links. I click on update links and
receive the warning "This workbook contains one or more links that cannot be
updated. To change the source of links or attempt to update values again,
click on edit links. To open as is....click continue." If I click on edit
links, the box shows the status of links as OK. The spreadsheet contains a
lot of data and my manager wants to be able to trust that the data is updated
correctly without checking over everything.

Any idea why the message occurs? What can be done to stop the message from
coming up? Any help would be appreciated.
Using Excel 2002 SP3

  #2   Report Post  
Old August 19th 06, 11:07 AM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Aug 2006
Posts: 42
Default updating links

Laura Jean
If your file has formulas linked to another file, you will want the up to
date version of that file. Your file will display the old values when you
last opened your file.

Hope this helps.
Peter

"Laura Jean" wrote:

Upon opening a file, I am asked to update links. I click on update links and
receive the warning "This workbook contains one or more links that cannot be
updated. To change the source of links or attempt to update values again,
click on edit links. To open as is....click continue." If I click on edit
links, the box shows the status of links as OK. The spreadsheet contains a
lot of data and my manager wants to be able to trust that the data is updated
correctly without checking over everything.

Any idea why the message occurs? What can be done to stop the message from
coming up? Any help would be appreciated.
Using Excel 2002 SP3



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 WhytheQ Excel Discussion (Misc queries) 7 June 1st 06 11:25 AM
Updating external links Al Links and Linking in Excel 1 May 30th 06 07:41 AM
Updating Links on Excel Update Link Question Excel Discussion (Misc queries) 4 May 22nd 06 08:21 PM
Updating links Brisbane Rob Excel Discussion (Misc queries) 2 April 1st 06 09:54 PM
Links updating? Kimmerz321 Excel Discussion (Misc queries) 3 September 1st 05 01:31 PM


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

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017