I wish to save space in my spreadsheet, which has sheet A containing extensive use of formulas and IF statements based on a Master sheet. This document will be distributed so I want people to see only the Values in the cells, not crazy formulae - I will discard Master and Sheet A and send only the resultant Values and some graphs.
The problem is there are tons of Background error checking green triangles in my Values only sheet. I can of course disable background error checking, but I want the entire spreadsheet to have this disabled when others open it.
Is this possible as a default for the document itself? Does anynore recommend another workaround? I use pivot tables to make charts and the file is 1.2MB which is not too big, but I really want to get rid of the green triangles.
The problem is there are tons of Background error checking green triangles in my Values only sheet. I can of course disable background error checking, but I want the entire spreadsheet to have this disabled when others open it.
Is this possible as a default for the document itself? Does anynore recommend another workaround? I use pivot tables to make charts and the file is 1.2MB which is not too big, but I really want to get rid of the green triangles.