Error message

  • Thread starter Thread starter Jen
  • Start date Start date
J

Jen

Of course I spend $200.00 and microsoft wants to charge
me when the software locks. I am receiving a message
everytime I open a workbook does anyone know why?

Message:

This workbook contains links to other data sources!
* If you update the links, Excel attempts to retrieve the
latest data.
* If you don't update, Excel uses the previous
information.

Update Don't Update Help

I have chosen "Update" and the next time I open I receive
the message again. I have chosen "Don't Update" and the
next time I open I receive the message again. I have
chosen "Help" and it just tells me what the question
means.

I do hope someone can help.
 
Do you think that your workbook doesn't contain links to another workbook?

If yes, get a copy of Bill Manville's FindLink program:
http://www.bmsltd.ie/MVP/Default.htm

It'll help you find those pesky ones.

I'm not quite sure what "locks" means here.
 
If you do have links and wish to keep them go to Tools>Options>Edit and
uncheck "Ask to update automatic links".

You won't get asked again.

Gord Dibben Excel MVP
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Still need help - Clear a cell upon workbook Close 2
Not receiving forum emails 14
Where are the links to other data sources? 1
Blue screen error message 1
SCAN.CO - £5,300 Gone. No PC. No Answers. One of the Worst Companies Ive Ever Dealt With. 3
Thunderbird problem 2
Strange Message when opening workbook 3
Why doesn't Excel 2007 automatically update links in Trusted Files 0

Back
Top