Excel 2007 - Page layout view is not compatible with freeze panes

  • Thread starter Thread starter Barb Reinhardt
  • Start date Start date
B

Barb Reinhardt

Can someone explain what this error message means? I'm guessing the
workbook was being saved as a compatible version when the error occurred, but
haven't tested it yet myself.

Thanks,
Barb Reinhardt
 
Hello Barb
In XL2007 with an XLSX (not compatibility mode) file, I froze a worksheet
from cell D5 - I got 'crosshairs' on the screen.

I clicked the Page Layout View tool on status bar (very useful addition to
Excel)
The message is "Page layout view is not compatible with freeze panes. If you
continue the sheet will be unfrozen. Do you wish to continue?"

I clicked Yes and the worksheet is in Page Layout without frozen panes.

If you think about it, frozen panes and Page Layout view at the same time
would be impossible or at least very strange!
best wishes
 
Back
Top