Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Excel 2003: Temporarily "turning off" links to external files...
....I have a spreadsheet with links to several external files. When I open it,
I am prompted to open/update the links to the external files. Is it possible to temporarily disable or swtich this prompt off, as sometimes I just need to reference my destination file quickly with updating. Thanks in advance Amanda |
#2
|
|||
|
|||
Just answer No to the prompt???
But if you see Ref errors (and don't want to see them)... xl2002+ likes to recalculate any workbooks that were created in previous versions. In earlier versions of excel, if you answer No to the update links prompt, the existing values are kept. In xl2002+, you get those errors. Jim Rech posted a registry tweak: http://groups.google.com/groups?thre...GP11.phx .gbl Birmangirl wrote: ...I have a spreadsheet with links to several external files. When I open it, I am prompted to open/update the links to the external files. Is it possible to temporarily disable or swtich this prompt off, as sometimes I just need to reference my destination file quickly with updating. Thanks in advance Amanda -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
External Links on open and Excel 2003 | Excel Discussion (Misc queries) | |||
Help in Excel 2003 | Excel Discussion (Misc queries) | |||
Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) | |||
Excel 2003 V's Excel 2000? | Excel Worksheet Functions | |||
sharing/using/saving Excel 2002 files in Excel 2003 | Excel Discussion (Misc queries) |