Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
CaymanCarrie
 
Posts: n/a
Default Lost customized toolbars & recalc

One of our users at my company has complained that he has all of a sudden
lost all customized toolbars in Excel. Is there any reason why this might
have happened to him, but not to anyone else on the network?

Also, Excel always seems to open up with manual recalculation set rather
than auto recalc.

Any words of wisdom would be greatly appreciated.

  #2   Report Post  
Jim Rech
 
Posts: n/a
Default

Excel keeps toolbar customizations in a file with a name like Excel.XLB in
this folder:

C:\Documents and Settings\<user name\Application Data\Microsoft\Excel

If this file was deleted (with Excel closed) user customizations would
disappear.

Excel always opens in auto calc mode but if the first workbook or template
opened was saved in manual mode it will switch. So it sounds as if maybe
the user's Personal.xls or a startup template was last saved while Excel was
in manual calc mode.

--
Jim
"CaymanCarrie" wrote in message
...
| One of our users at my company has complained that he has all of a sudden
| lost all customized toolbars in Excel. Is there any reason why this might
| have happened to him, but not to anyone else on the network?
|
| Also, Excel always seems to open up with manual recalculation set rather
| than auto recalc.
|
| Any words of wisdom would be greatly appreciated.
|


  #3   Report Post  
Dave Peterson
 
Posts: n/a
Default

First, the easy answer...

Excel determines what the calculation mode should be by the first workbook
that's opened in that session. So if the user opens a workbook that's been
saved in manual calculation mode as the first workbook, the user will be stuck
in manual calculation mode.

This seems to be a common problem for people who share workbooks in a common
folder--someone changes calculation to manual and then saves the file. Then a
subsequent user opens that workbook first and is in manual calculation mode.

The answer is either open a workbook that saved in automatic mode--or learn how
to toggle that setting.

===
The second answer is just a guess.

Excel stores customized toolbars in a file named *.xlb (name and location vary
with the version of windows and excel). This file is unique to each user.

If someone deleted that *.xlb file (by mistake), then there go the customized
toolbars.

I know that once I've customized my toolbar the way I like it, I find it (using
windows start button|search) and make a backup of it--just in case it disappears
(or I break it by mistake).



CaymanCarrie wrote:

One of our users at my company has complained that he has all of a sudden
lost all customized toolbars in Excel. Is there any reason why this might
have happened to him, but not to anyone else on the network?

Also, Excel always seems to open up with manual recalculation set rather
than auto recalc.

Any words of wisdom would be greatly appreciated.


--

Dave Peterson
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
hide toolbars, menu bar, etc runandrun Excel Discussion (Misc queries) 0 September 22nd 05 10:16 PM
Toolbars will not stay where I put them Dave Excel Discussion (Misc queries) 0 September 2nd 05 07:57 PM
removing customized toolbars news Excel Discussion (Misc queries) 1 February 24th 05 04:11 PM
Saving Customized Toolbars in Excel 2003 MIKE MEDLIN Excel Discussion (Misc queries) 5 January 13th 05 03:03 AM
Customizing ToolBars MIKE MEDLIN Excel Discussion (Misc queries) 0 January 13th 05 01:11 AM


All times are GMT +1. The time now is 03:49 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"