Update links dialogue box

[Marisol V.]

Hello,

I have an excel worksheet that has data links to other
sheets. Everytime I access this file I get a dialogue box
asking me if I would like to update the spreadsheet. I do
not want to update the spreadsheet. I want to keep the
data as is but would like to omit having to say "no" to
the dialogue box everytime I access the spreadsheet.

Is there a way to omit the dialogue box without affecting
the data on the spreadsheet?

Thank you.
Marisol

 

[Cindy Meister -WordMVP-]

Hi Marisol,

You should ask this question in an EXCEL newsgroup.

I have an excel worksheet that has data links to other
sheets. Everytime I access this file I get a dialogue box
asking me if I would like to update the spreadsheet. I do
not want to update the spreadsheet. I want to keep the
data as is but would like to omit having to say "no" to
the dialogue box everytime I access the spreadsheet.

Is there a way to omit the dialogue box without affecting
the data on the spreadsheet?

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jan
24 2003)
http://www.mvps.org/word

This reply is posted in the Newsgroup; please post any follow
question or reply in the newsgroup and not by e-mail

 

[Fay Yocum]

Have you checked Tools menu | Options | Calculation tab are calculations set
to Manual. If yes try automatic. But as Cindy said this is a question better
asked in an Excel newsgroup.

HTH
Fay