Bit of a guess, but I understand Excel stores your selected tool bar
settings in a file called something like "Excel11.xlb", in somewhere
like:
C:\Documents and Settings\YOURUSERNAME\Application Data\Microsoft
\Excel
Although this will vary based on your set up.
It might be that this file is corrupt?
You could consider trying to find a .xlb file on your machine and
renaming it excel11.old. Open Excel, amend the default font and then
see if that works?
If not, just restore the original filename.
Good luck!
Gord Dibben - 16 Apr 2008 21:19 GMT
Excel stores the default Font setting in the Registry.
HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\Excel\Options
Right-side key Font
What value do you have there? Mine is the hateful Arial, 10
Perhaps you do not have permission to alter the Registry?
Gord Dibben MS Excel MVP
>Bit of a guess, but I understand Excel stores your selected tool bar
>settings in a file called something like "Excel11.xlb", in somewhere
[quoted text clipped - 14 lines]
>
>Good luck!
William Oertell - 17 Apr 2008 01:31 GMT
> Excel stores the default Font setting in the Registry.
>
[quoted text clipped - 26 lines]
>>
>>Good luck!
I checked the registry, and the correct font is set there. I do have
admin privileges on my machine.
William Oertell - 17 Apr 2008 01:29 GMT
> Bit of a guess, but I understand Excel stores your selected tool bar
> settings in a file called something like "Excel11.xlb", in somewhere
[quoted text clipped - 14 lines]
>
> Good luck!
I tried renaming excel11.xlb to excel11.xlb.sav and restarting Excel, but I
didn't think of then setting the default font again. I'll give it a try.
Thanks.
Alan - 07 May 2008 14:55 GMT
> Bit of a guess, but I understandExcelstores your selected tool bar
> settings in a file called something like "Excel11.xlb", in somewhere
[quoted text clipped - 14 lines]
>
> Good luck!
Hi,
Perhaps the excel file is damaged or something. If necessary, I think
you can try a utility called Advanced Excel Repair to repair your
Excel xls file. It works rather well for my corrupt Excel xls files.
Its web address is http://www.datanumen.com/aer/
Alan