How to get rid of an link message in Excel?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,
I've copied and pasted two work sheets and merged them into a master
workbook in Excel, and have micro in the master workbook. Now each time when
I open the master workbook in Excel, it will have a message: "The workbook
you opened contains automatic links to information in another workbook. Do
you want to update the workbook with changes made to the other workbook?"...
Is there a way to get rid of this message? Any help will be greatly
appreciately.
Thanks,
Jenny
 
It sounds like you had formulas referencing another sheet in your original
workbook. You can do a Find/Replace, using [*] as the find and leaving
replace with empty. You may need to do this in > 1 sheet in the workbook.
 
Hi Pegl,
Thanks for your quick response and help. I tried this way and get rid of
all the references from the charts (data source link) and all the
calculations. Once I saved the file and I still get the message when I open
the file. Do you have any other suggestions? Is there anywhere (hidden
references) that I didn't get rid of yet? Thank you very very much for all
your help!!!
Jenny

PegL said:
It sounds like you had formulas referencing another sheet in your original
workbook. You can do a Find/Replace, using [*] as the find and leaving
replace with empty. You may need to do this in > 1 sheet in the workbook.

--
Good Luck,
Peg


Jenny said:
Hi,
I've copied and pasted two work sheets and merged them into a master
workbook in Excel, and have micro in the master workbook. Now each time when
I open the master workbook in Excel, it will have a message: "The workbook
you opened contains automatic links to information in another workbook. Do
you want to update the workbook with changes made to the other workbook?"...
Is there a way to get rid of this message? Any help will be greatly
appreciately.
Thanks,
Jenny
Click to expand...
Click to expand...
 
Hi Dave,
Thanks for your suggestions. By using Bill Manville's FindLink program, I
find a file link and solve the problem.
Thank you,
jenny
 
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

Merge Multiple workbook sheets into one workbook 0
How to create absolue path link to another workbook (Excel 2003) 1
Sharing workbooks limitations - Merged Cells 12
Link one worksheet in a workbook to another worksheet in same work 1
Connecting a master sheet to other sheets within the same workbook 3
Can I group or link sheets in seperate workbooks? 1
HELP - A formula or sheet you want to move or copy contains the name .... 0
Editing Data in Multiple Worksheets/Workbooks 1

Back
Top