See Current Sheet References and Delete them
I have a sheet i'm building and I have run into the maximum number of sheet references. This isn't a big deal as I've just made another sheet, and i'm going to use a report to conglomerate them, but I found out that I cannot go through my references and delete some of them, or even see a list of the references made.
Is there a way to do this that I am missing? Has anyone else run into this issue?
Comments
-
I haven't found a way to list all of your sheet references, but if you click on a cell (single click) there should be an option to delete. If it is a sheet reference in a formula, you can "edit" the formula, click somewhere inside of the reference portion, and either delete it out from there or edit the sheet reference.
Help Article Resources
Categories
Check out the Formula Handbook template!