Workbook Contains Links To Other Data Sources? Where?

S

Sue N.

So I messed up and now I need help :)

I was trying to copy a tab from a workbook and forgot to check off 'copy'.
Later I realized what I had done, so I copied the tab from the new workbook
back into the old workbook and now I get the dreaded "This workbook contains
links to other data sources" message! The workbook has about 40 tabs and I'm
not sure which one I had copied back in - is there an easy way to determine
where the links to other data sources are so I can remove them?
Thanks!
Sue in NH
 
L

Luke M

You might be able to accomplish your task from the Edit-Links option box. The
other option would be to do a Find, search entire workbook, and look for
".xls"
 

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

Top