I am having a strange problem with the OFFSET function and a dynamic print area.

I have used OFFSET to define a dynamic print area many times, but now it seems that Excel is running the function once and then wiping the formula out of the Name Manager and storing the resulting array as the print area rather than the formula itself.

Here is the formula I entered:

=OFFSET($A$1,0,0,14+$L$2,36)

Where $L$2 contains the number of rows to print after the 14 print tile rows, in this case 24.

Once I close Name Manager, the formula is wiped out and replaced with the resulting array $A$1:$AJ$38.

The sheet is set to Automatic Calculation. I've never encountered this problem before. Thanks for the help!