This is likely an easy question, but I can't figure it out and its very annoying. I have some toolbars that I dont want to show in excel, each time excel opens I go to view-> toolbars and uncheck the ones I dont want but everytime I reopen excel the are back no matter if its a new blank sheet or a worksheet I have saved. Also I have under tools -> options unchecked the 'update remote referances' in the calculation tab, yet each time I open Excel it tries to update remote referances and the box is rechecked in the tools-> option box. How do you get this preferances to stay?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Excel Settings
- Thread starter greg303
- Start date
These are set in the .xlb file that currently exists on the pc.
Do a find for files with the extension .xlb
When you find it, rename it so that .xlb is .old
Now, you should be able to set your preferences and they'll "stick" in the newly created .xlb
"'Tis an ill wind that blows no minds." - Malaclypse the Younger
Do a find for files with the extension .xlb
When you find it, rename it so that .xlb is .old
Now, you should be able to set your preferences and they'll "stick" in the newly created .xlb
"'Tis an ill wind that blows no minds." - Malaclypse the Younger
- Thread starter
- #3
Did you find more than one .xlb file? Did you rename YOUR .xlb?
"'Tis an ill wind that blows no minds." - Malaclypse the Younger
This might also come in handy:
"'Tis an ill wind that blows no minds." - Malaclypse the Younger
"'Tis an ill wind that blows no minds." - Malaclypse the Younger
- Status