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 |
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 08:32 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com