View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bernard Liengme Bernard Liengme is offline
external usenet poster
 
Posts: 4,393
Default Excel 2007 - Page layout view is not compatible with freeze panes

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
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Barb Reinhardt" wrote in message
...
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