A very strange thing has happened to my Excel 2003 - the Freeze Panes menu command is now always greyed out - see the attached screenshot. I haven't seen such a thing ever before and I do not know how it happened...
Can anyone please suggest how I can bring the Freeze Panes command back alive?
Just to make the situation clear :
1) The command is now ALWAYS disabled, on any spreadsheet, even the newly created blank ones
2) I'm in the Normal view, not the Page Break View.
3) I'm running Excel 2003 under Windows XP
4) I've tried unloading all the add-ins, inlcuding COM add-ins - the problem persists. I've even tried clicking "Repair" on Microsoft Office in "Add Remove Programs" in the conrol panel, and then restarting the PC - No effect.
I hope that anyone has seen this before. Any help would be greatly appreciated. Thanks a lot.
I see you also have both Hide and Unhide available... which means there must be a hidden workbook... not sure if that may cause a problem.. but try to select Unhide and see if a workbook is hidden.. try to unhide it... does that do anything to help?
Microsoft MVP - Excel
Where there is a will there are many ways. Pick One!
Please read the Forum Rules
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Preferred Charities: Lupus Canada and Sick Kids Foundation.
Feel Free to Donate if you want to, for the assistance you received today.
Also check that you are in Normal View
Microsoft MVP - Excel
Where there is a will there are many ways. Pick One!
Please read the Forum Rules
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Preferred Charities: Lupus Canada and Sick Kids Foundation.
Feel Free to Donate if you want to, for the assistance you received today.
The hidden workbook is a personal.xls with my handy macros. Closing it and removing it from the XLSTART does not help - the freeze panes is still disabled.
And yes, I am in the Normal view, not the Page Break view...
Any other ideas? It's really annoying to go to the Immediate window of VBE and execute ActiveWindow.FreezePanes = TRUE/FALSE every time I need to freeze or unfreeze panes (which strangely does work!)
Your help will be very appreciated!
Hi,
I also have the same problem.
But little different.
Already i posted my problem with screen shot
http://www.excelforum.com/excel-gene...el-resize.html
Kindly help me out.
Tanza
Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread.
Microsoft MVP - Excel
Where there is a will there are many ways. Pick One!
Please read the Forum Rules
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Preferred Charities: Lupus Canada and Sick Kids Foundation.
Feel Free to Donate if you want to, for the assistance you received today.
@ NBVC,
I only wanted to say that i also have the same problem since my excel freezepanes is also not working.
and also provided the link since I have already posted the problem
Anyway... next timeI will take care of that
Tanza
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks