ukdane
04-20-2009, 02:47 AM
Long story short, I did something stupid this morning, and deleted a number of excel worksheets I'd been working on, contained within the same workbook.
Luckily I had a back up. Howver the backup doesn't have the latest versions of the non deleted worksheets.
So I copied the "deleted" sheets into the working workbook.
However now when I start the workbook up, I get the text box stating that the workbook contains links to other data sources.
I didn't get this message before I copied the worksheets into the workbook, so there must be one of the copied worksheets that is causing the link to exist.
1) How do I locate where/what is causing the link so that I can correct/remove it?
2) If I can't remove it, how do I turn off the messagebox that is asking me if I wish to Update/ Don't Update?
Thanks for your help.
Luckily I had a back up. Howver the backup doesn't have the latest versions of the non deleted worksheets.
So I copied the "deleted" sheets into the working workbook.
However now when I start the workbook up, I get the text box stating that the workbook contains links to other data sources.
I didn't get this message before I copied the worksheets into the workbook, so there must be one of the copied worksheets that is causing the link to exist.
1) How do I locate where/what is causing the link so that I can correct/remove it?
2) If I can't remove it, how do I turn off the messagebox that is asking me if I wish to Update/ Don't Update?
Thanks for your help.