remote links

  • Thread starter Thread starter mcarrington
  • Start date Start date
M

mcarrington

I am trying to open a worksheet with links to another program that I do
not have. As such, I do not want the links to automatically update when
I open the workbook. Even though I select "do not update", the links
still update and I get a bunch of error messages in all of the cells.
Any ideas? It is driving me nuts!!
 
One possibility is to check for a VBA event handler in the workbook (such as
Workbook_Open) that is trying to automatically update the links. I believe
this event code would run after Excel asks whether or not you want to update
links (which would explain why it is trying to update links even after you
say no).

With the workbook open, hit Alt+F11 and find the ThisWorkbook module in the
project explorer. Check for Workbook_Open macro.
 
You must log in or register to reply here.

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

Link To File That No Longer Exists 1
Links not working in Excel 2007 2
remote links 3
Non-actual external links remain 4
Link changes in destination workbook 4
Excel 2007 Linking Cells 0
update workbook links over network 1
File Download - Security Warning 5

Back
Top