View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
CLR CLR is offline
external usenet poster
 
Posts: 1,998
Default Freeze pane works in some workbooks but not others

Does the FreezePanes feature fail to work the in all sheets in the workbook,
or just the one?

Maybe try right-click on the sheet tab, then select MoveOrCopy, check the
create copy box, select (move to end), OK.........this will make a complete
copy of your sheet within the same workbook..........check it to see if the
FreezePanes work there.

Vaya con Dios,
Chuck, CABGx3

"DAVE" wrote:

Hello,
Soemthing is wrong with some of my workbooks. When freezing a row, it will
stay frozen until I change the view, then it moves.

I was told to try creating a new work book and pastin in my info. When I
try this the rows and colums don't match up the same size and my workbook is
a mess.

Something must be corrurpt in my workbook to make the freeze pane stop
working.
DAVE