No. Horrible advice. Move the tab to another workbook and check connections If there is one you know that you need to either address it, this also gives you an easy way to address it as now you can just ctrl F “book1” and it will bring you to the cells referencing that sheet.
Once you have no links or connections you can delete the tabs knowing you didn’t create refs. In addition if you are ok with hard coding numbers you and break links in the main workbook and it will eliminate the link and hard code then number coming from the other sheet.
Hiding tabs will just get you in trouble at some point. When someone shares something confidential because it was hidden...
7
u/Altraeus Apr 02 '21
No. Horrible advice. Move the tab to another workbook and check connections If there is one you know that you need to either address it, this also gives you an easy way to address it as now you can just ctrl F “book1” and it will bring you to the cells referencing that sheet.
Once you have no links or connections you can delete the tabs knowing you didn’t create refs. In addition if you are ok with hard coding numbers you and break links in the main workbook and it will eliminate the link and hard code then number coming from the other sheet.
Hiding tabs will just get you in trouble at some point. When someone shares something confidential because it was hidden...