Dynamic Print Area Reset by Print Preview

So I have 5 worksheets with 5 different dynamic print areas.

The formula for Print_Area name is as follows:

Please Login or Register  to view this content.

Sec1LastRow is specific to each worksheet, Section # is for the pages 1-5.

The dynamic range works great UNTIL i press print preview. It locks in the value of whatever the formula would be. It's no longer dynamic after the print preview.

I have also attempt to have the Print_Area_formula name:

Please Login or Register  to view this content.

and then the print_area =Print_Area_Formula which gives the same result.

Is this a bug or by design and is there anyway to get around this preferably without a macro.

Thank you,
Dan

Bump - Has anyone else experienced this?