FREEZE PANES

[Guest]

Freeze Panes options is no longer available in any spreadsheet I work with,
new or old (where I have used it previously) Where spreadsheets are frozen
now, I can't unfreeze, either.

Maybe something I did/didn't do when using side-by-side comparison?

Anyway, how to I get back the function, as "Split" just doesn't do what I
need.

 

[Jim Cone]

Have you tried resetting the menu bar?...
Right-click the menu bar | Customize | Toolbars (tab) | Worksheet Menu Bar | Reset (button).
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware


"Lucy" <[email protected]>
wrote in message
Freeze Panes options is no longer available in any spreadsheet I work with,
new or old (where I have used it previously) Where spreadsheets are frozen
now, I can't unfreeze, either.
Maybe something I did/didn't do when using side-by-side comparison?
Anyway, how to I get back the function, as "Split" just doesn't do what I
need.

 

[Guest]

Tried it, but no difference. Any other suggestions?

 

[Jim Cone]

The toolbar and menu setting are stored in the Excel.xlb file.
If this file is removed all the menu bars and toolbars are
automatically rebuilt. (in a non-corrupt system).
Before doing this, go to Tools | add-ins, make a note
of all the check marked items and then uncheck them all.

Close Excel and then do a search in Windows Explorer
for *.xlb and delete all files found. There should only be one file.
(multiple files could be part of the problem)
The actual file name varies depending on the version of Excel
you are using....Excel10.xlb, Excel.xlb, User8.xlb or ?

Probable file locations are...
C:\Documents and Settings\user\Application Data\Microsoft\Excel
or
C:\WINDOWS

Restart Excel.

Jim Cone
San Francisco, USA
http://www.officeletter.com/blink/specialsort.html



"Lucy" <[email protected]>
wrote in message
Tried it, but no difference. Any other suggestions?