Link updates Excel 2007

  • Thread starter Thread starter Alain Schneiter
  • Start date Start date
A

Alain Schneiter

Hi,
We have svereal spreadsheets with exeternal contents. Excel 07 always starts
with trying to update this links even if we change the settings in the trust
center - external contents.
Excel shows then the cells in "value". I would like to start Excel without
updating the links.
Can somebody help me please?
 
Hi,

Try, Data, Edit Links (in the Connections group), Startup Prompt, Don't
display the alert and don't update automatic links.
 
Shane,
I tried this. Same problem. The spreadsheed points to a not available file
share. The cells still shows "value".
Cheers,
Al
 
Hi,
Can you please explain a bit more what you mean. The workbook points to an
external source.

Regards,
Al
 
Hi,

Click on Ctrl + F3 to see if you have any names which evaluate to error
values I.e. #DIV/0!, #NUM etc.. Delete these names.

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com
 
Hi,
Nothing like that in there. Any other idea?
The file should not update the content as this is pointed to external not
reachable files or fileshares.

Cheers,
Al
 
Back
Top