Dependencies in Excel
Hi,
I have 5 sheets in excel workbook.
SheetA
SheetB
SheetC
SheetD
SheetE
I have a dashboard in sheetE for which i am using data from some other sheets.
How do I know from what sheets the data is coming to SheetE. I want to delete other sheets if i am not using them for SheetE dashboard.
Please help.
If you run Find & Replace with SheetA etc. in the search window, you will find any instance of that in the sheet. If there is none, then that sheet can go.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Another way - delete teh sheet anyway, and see if it throws out an error on your dashboard. If it does, use CTRL Z (undo), or just reload the file. If you are sure there is 9and wont be) any errors, leave the sheet deleted
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
hmm you could also use the Trace Dependencies function, but that can sometimes be hard to follow if there are lots of dependancies
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks