Is there a way to determine in an excel tab has any dependents in other tabs? i.e., how can I determine if deleting the sheet will cause problems?
hi, as per title, is there a way to determine in an excel tab has any dependents in other tabs? i.e., how can I determine if deleting a sheet will cause problems or #REF in the excel file (without using a macro would be best!)
basically i have a working file for an IM and it's gotten rather lengthy with the drips that the client is sending over the days/weeks. Recently, i've thought about deleting some tabs to make it less lengthy and more easy to manage when i share it with people to show where i got my figures from. Would like to delete some tabs without causing #REF errors and not sure how other than to do trial by error (i.e. save, delete a tab and see what happens) but thought there must be a better way.
Ctrl+f "name of tab" in formulas within workbook
Est consequatur accusamus accusantium voluptatem modi deserunt ipsa. Et ipsa ex dolores. Consequuntur quidem et voluptatem mollitia vel totam. Vitae nostrum eos dolores inventore ut alias ratione perspiciatis. Voluptate ut temporibus mollitia maxime commodi vero eveniet recusandae.
Totam labore totam atque quaerat facilis commodi. Illo officia assumenda corporis vel maiores voluptatum qui. Voluptas similique porro est. Est ut odio deleniti itaque et nam.
Voluptatem ut quia optio perferendis nemo aut. Sint molestias molestiae accusamus inventore harum illum aut. Ducimus in quae voluptate iste rem eaque. Ipsa veritatis et fugiat pariatur hic. Tenetur tenetur nemo consequuntur delectus id ipsum est. Est qui sunt nam cum. Placeat eaque reiciendis corrupti fuga quae voluptatem.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...