Tools/Options/View/Zero Value

M

Mia

Under Tools/Options/... I set up the defaul drive in G (net work drive).
Today, the network drive is down and I am working on C drive.

I'd like the worksheet doesn't show zero values when viewing it, so I unchecked
the box "zero values". But it keeps giving me the message "Cannot access
directory G:\excel\...", and the zero values are still there.

How can I by pass this message and the zero values would not show?

Thanks.
Mia
 
Top