Excel 2003: Temporarily "turning off" links to external files...

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

....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
 
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/[email protected]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Problems with Bloomberg External Links 1
External reference for Offset formula 2
#Value w external links 2
Highlight External Links 1
Excel File with Numerous links takes a long time to open 2
Opening Excel 2003 file in Excel 2007: Links do not work 5
turn off subroutines 3
fixing links to external files if status shows OK 4

Back
Top