Unable to permanently deselect "Show Zero in Cell..."

nomar116

New Member
Joined
Jan 27, 2020
Messages
16
Office Version
  1. 2013
Platform
  1. Windows
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.
 

Some videos you may like

Excel Facts

Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.

Watch MrExcel Video

Forum statistics

Threads
1,118,765
Messages
5,574,105
Members
412,571
Latest member
Ventura7
Top