Thread: updating links
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
PeterAtherton PeterAtherton is offline
external usenet poster
 
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