Invalid references

S

Shell

I have several workbooks with many tabs in each. In several tabs, I have
cells which refers to data on different tabs or even in different workbooks.

Often I get an error messags as follows

"The workbook you opened contains automatic links to information in another
workbook. Do you want to update the workbook with changes to made to the
other workbook." Whichever cells are triggering this message, is definately
invalid.

How to I get the Excel program to list these rogue cells without having to
walk though each cell and analyze the reference?

Thanks
 

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