ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   updating links (https://www.excelbanter.com/excel-worksheet-functions/105924-updating-links.html)

Laura Jean August 18th 06 10:27 PM

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

PeterAtherton August 19th 06 11:07 AM

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



All times are GMT +1. The time now is 07:52 AM.

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