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

If you have a look at ToolsOptionsView "zero values" you will see it is
under the "Windows Options" section.

That's why it happens..............workaround, I don't know of any.


Gord Dibben MS Excel MVP

On Sat, 23 Aug 2008 01:49:02 -0700, pignick
wrote:

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

Hi,

Phrased a different way:

Some options apply to a sheet, some apply to the workbook, some apply to
Excel. This option applies to the active window.

This is the intended behavior - because Excel wants to allow you to display
your sheet in two windows two different ways.

As another example - with two windows on the same sheet open side by side
you can display the formulas in one window and their results in the other.
This may help in debugging formulas.

--
Cheers,
Shane Devenshire


"pignick" wrote:

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

Thanks guys - at least I know it's not something I've done with a duff setting.
--
pignick


"ShaneDevenshire" wrote:

Hi,

Phrased a different way:

Some options apply to a sheet, some apply to the workbook, some apply to
Excel. This option applies to the active window.

This is the intended behavior - because Excel wants to allow you to display
your sheet in two windows two different ways.

As another example - with two windows on the same sheet open side by side
you can display the formulas in one window and their results in the other.
This may help in debugging formulas.

--
Cheers,
Shane Devenshire


"pignick" wrote:

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