cancel Update message?

B

Bob

I copied and pasted several worksheets from one workbook to another. When I
open the new workbook I keep getting a message to update or not. How do I get
rid of any links to the other workbook.
I have checked all formulas and none have a link to the other book. I also
selected tools/option/edit and unticked the update box, but I still a message
to 'continue'.
How do I sort this out?
 
J

Joel

Go to menu Edit - Links to find the links that are still in your workbook. I
have found occasionally in workbooks there are invisible errors in the
workbook where excel thinks there are still links after you removed them all.
I then have to copy each sheet one at a time to a new workbook to remove
these hidden links.
 

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

Link won't break in Exel. 2
Update links 1
Where are the links to other data sources? 1
Update links 1
Saving through a network affecting ability to update automatically 1
File size too big 1
Paste Values in linked Cells Only 4
Link? 1

Top