Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Updating Links | Excel Discussion (Misc queries) | |||
Updating external links | Links and Linking in Excel | |||
Updating Links on Excel | Excel Discussion (Misc queries) | |||
Updating links | Excel Discussion (Misc queries) | |||
Links updating? | Excel Discussion (Misc queries) |