| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Message: Links not updated because file not recalculated before sa
I keep getting a message when attempting to open a linked worbook that the
links were not updated because the file was not recalculated prior to saving. I really don't want to update the file before saving because it opens read-only and I refresh the data anyway once it is opened. This message is interupting a macro I am running to perform the tasks. What is the code I need to enter in the macro to say "OK" to the question it asks as to whether I want to update links with the current data? I have "UpdateLinks:=0" in the macro when the file is opened but that does not help. Thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Unnecessary error message on opening file with links | Links and Linking in Excel | |||
| HELP - the file links cannot be updated! | Excel Discussion (Misc queries) | |||
| How do I update links from a file that hasn't yet been updated? | Excel Worksheet Functions | |||
| Links cannot be updated | Excel Programming | |||
| Avoid "...contains one or more links that cannot be updated" message. | Excel Programming | |||
Linear Mode
