In a workbook containing a number of sheets all are set not to display zeros,
but if I open a new window to view different sheets of the same workbook side
by side the sheets in the new window are displaying zeros and I have to go
into options to change that back. Any suggestions as to why this is
happening and how to avoid it please? Thanks
--
pignick