I have a workbook that consists of dozens of worksheets, all of which I would like to have deselected "Show a zero in cells that have zero value." I want formulas to return empty cells instead of a zero.
Many times I have gone in to Options/Advanced/Display Options and deselect this option for all of the worksheets. Somehow the setting reverts when I come back to the file after colleagues have worked on it and I have to keep changing it back, over and over again.
Does anyone know why this setting might be reverting back to selected? I've noticed the problem happens when sharing across email and Microsoft Teams. Interestingly, I don't think this problem happened when we were using Slack to share the file. Or maybe something else about the file changed that indirectly effected this.
Does anyone know how to write a macro that would deselect this setting? I could perhaps do so for all of the worksheets anytime I notice the zeros are showing up again.
Many times I have gone in to Options/Advanced/Display Options and deselect this option for all of the worksheets. Somehow the setting reverts when I come back to the file after colleagues have worked on it and I have to keep changing it back, over and over again.
Does anyone know why this setting might be reverting back to selected? I've noticed the problem happens when sharing across email and Microsoft Teams. Interestingly, I don't think this problem happened when we were using Slack to share the file. Or maybe something else about the file changed that indirectly effected this.
Does anyone know how to write a macro that would deselect this setting? I could perhaps do so for all of the worksheets anytime I notice the zeros are showing up again.