If you find any, simply remove (or break) those particular links.
Navigate to your Data Tab > Queries & Connections > Edit Links and see if any of your links contain errors in them. Make sure you save after each tab is copied over in case the Saving event is what triggers the error message. You can do this by copying over your tabs one-by-one and determining which tab in your new workbook triggers the error message.
Sometimes if you have a enormous file with lots of tabs, you may want to start by isolating the specific tab(s) that are causing this error message. Best of luck! Isolate The Specific Spreadsheet Tab Well, I have been in your shoes feeling the exact frustration and hopefully I can guide you through the different parts of your spreadsheet that may be housing this invalid formula reference. So after clicking OK about ten times, you've probably more than a little time trying to figure out what is causing this message to keep popping up. Well, thank you Excel for giving us a blanket, catch-all statement that is essentially telling us, 'I've found an issue with your spreadsheet, I'm not going to tell you where it is or even what type of object is causing this.but enjoy scouring the entire file! Oh, and I almost forgot, I'm going to keep reminding you about this error until it's fixed.'
