Dynamic Print Range Resets Itself

[miketastic]

Hello,

I have set up a dynamic print range via the Name Manager with the following formula:

=OFFSET('WIRES'!$A$1,0,0,COUNT('WIRES'!$E:$E)+5,6)

The formula works fine, but when I use it (both directly as the Print_Area and as a separate Name for Print_Area to refer to) the formula disappears and only the calculation is left. I can't get the formula to stick so that it actually is dynamic.

Any help is CRAZY appreciated!

Thanks

 

[puller90]

The print area formula will reset itself while in PAGE VIEW. In other views (NORMAL etc.) the intended formula lasts and the dynamic range works fine. If you switch to PAGE VIEW you'll have to return to another view and re-enter your formulas.
Running version 2302