RE: How to get rid of an link message in Excel?

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" wrote:

> It sounds like you had formulas referencing another *** 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 *** in the workbook.
>
> --
> Good Luck,
> Peg
>
>
> "Jenny" wrote:
>
> > 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
> >
.