Home |
Search |
Today's Posts |
#1
|
|||
|
|||
file commands
When i open an excel file there are no commands or buttons at the top of the
sheet. This must be a central function as it is the same in all files and workbooks. |
#2
|
|||
|
|||
Hi Mark
Maybe you have a corrupt or bloated xlb file *normal* size is < 30 kb. The .xlb file has all Toolbar customization in it. 1. Close Excel 2. Do a search for .xlb in Windows (file is hidden) 3. Rename or delete the .xlb file or files (In 2002 the name = Excel10.xlb) 4. Start Excel Deleting the file or renaming will do no harm on your system Excel will create a new one for you. (You lost your customization remember that) If you make your own toolbars or add buttons to the others this file is important (backup it so you can restore it) -- Regards Ron de Bruin http://www.rondebruin.nl "mark" wrote in message ... When i open an excel file there are no commands or buttons at the top of the sheet. This must be a central function as it is the same in all files and workbooks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
cannot open excel file, please help!!! | Excel Discussion (Misc queries) | |||
copy excell file to a CSV file and than to Notepad | Excel Discussion (Misc queries) | |||
Locating a file in excel with a partial file name. | Excel Discussion (Misc queries) | |||
Read Text File into Excel Using VBA | Excel Discussion (Misc queries) | |||
Deleting custom Commands from File Menu are nor saved next time w. | Excel Worksheet Functions |