klutz
07-16-2010, 07:43 AM
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.
When Calculating this workbook:
This is only good for the actual open workbook. Even after you open the workbook EXCEL automatically updated the links. (not good)
General
Here I have checked off the ask me to UPDATE LINKSHow 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-
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.
When Calculating this workbook:
This is only good for the actual open workbook. Even after you open the workbook EXCEL automatically updated the links. (not good)
General
Here I have checked off the ask me to UPDATE LINKSHow 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-