Sheet dependancies?

[TheWennerWoman]

I have inherited a spreadsheet with literally dozens of tabs. The file is many years old.

Users have decided that they want to delete a lot of these tabs to reduce the file size and improve performance.

However, there are links anywhere and everywhere in this file.

Is there a quick way (maybe via VBA) that I can see which sheets I can't delete because they are referenced elsewhere in the workbook?

 

[Trevor G]

If you haven't used the Inquire tab before you can switch it on it will enable you to analyse your workbook.

There are various YouTube video's that will explain how to use it. One example is indicated below

 

[Burrgogi]

You will probably not see the Inquire tab in the ribbon by default. Here are the instructions for turning that on.

Turn on the Inquire add-in - Microsoft Support

To use the Spreadsheet Inquire tools, you need to turn on the Inquire add-in for Excel.

support.microsoft.com