Link updates Excel 2007

[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?

 

[Shane Devenshire]

Hi,

Try, Data, Edit Links (in the Connections group), Startup Prompt, Don't
display the alert and don't update automatic links.

 

[Alain Schneiter]

Shane,
I tried this. Same problem. The spreadsheed points to a not available file
share. The cells still shows "value".
Cheers,
Al

 

[Ashish Mathur]

Hi,

Please check the names defined in the workbook. Do you have any names which
evaluate to errors.

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

 

[Alain Schneiter]

Hi,
Can you please explain a bit more what you mean. The workbook points to an
external source.

Regards,
Al

 

[Ashish Mathur]

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

 

[Alain Schneiter]

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