Hi,

I'm puzzled as to excel 2007 automatically updating external links eventhough I get the Security Alert window that asks me if i want to ENABLE or Protect it.

I created a workbook in excel 2003 and sent it to a friend with excel 2007 and we;re having updating links issue.

In the EXCEL OPtIONS tab there are 2 sections that relates to updating links.

  1. When Calculating this workbook:
    1. This is only good for the actual open workbook. Even after you open the workbook EXCEL automatically updated the links. (not good)
  2. General
    1. Here I have checked off the ask me to UPDATE LINKS
How can I avoid having Excel 2007 automatically update external links?

I've attached a file with screen shots of the file, having the external link disabled but still getting the workbook updating automatically and showing a bunch of errors becuase the external links are not available.

Thanks for your help.

Klutz-