Link updates Excel 2007
 

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?

Link updates Excel 2007
 

Hi,

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

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Alain Schneiter" wrote:

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?

Link updates Excel 2007
 

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

"Shane Devenshire" wrote:

Hi,

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

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Alain Schneiter" wrote:

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?

Link updates Excel 2007
 

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" <Alain wrote in
message ...
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?

Link updates Excel 2007
 

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

Regards,
Al

"Ashish Mathur" wrote:

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" <Alain wrote in
message ...
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?

Link updates Excel 2007
 

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" wrote in
message ...
Hi,
Can you please explain a bit more what you mean. The workbook points to an
external source.

Regards,
Al

"Ashish Mathur" wrote:

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" <Alain wrote in
message ...
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?

Link updates Excel 2007
 

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

"Ashish Mathur" wrote:

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" wrote in
message ...
Hi,
Can you please explain a bit more what you mean. The workbook points to an
external source.

Regards,
Al

"Ashish Mathur" wrote:

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" <Alain wrote in
message ...
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?