 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / September 2007Format Cell Problem
When clicking on the format cell option on one of our computers, it immediately closes Excel out with an error stating that excel.exe has generated errors and had to be closed. It doesn't matter if you do it from the top menu or if you right click on the mouse. We have tried the repair option as well as uninstalling and reinstalling excel. Nothing has worked so far. Any suggestions on how to solve this problem. Thanks. Try this: 1. open a fresh, clean workbook 2. select all the cells 3. Edit > Clear > Formats Then try to set a format  SignatureGary''s Student - gsnu200745 > When clicking on the format cell option on one of our computers, it > immediately closes Excel out with an error stating that excel.exe has [quoted text clipped - 4 lines] > > Thanks. I just tried that and it still gives me the error when I try to select Format>cells. Any other thoughts? Mindy > Try this: > 1. open a fresh, clean workbook [quoted text clipped - 11 lines] > > > > Thanks. Try this trick which most times clears up the problem. Close Excel, do a file search for *.XLB Rename it to *.XLBOLD......ignore the warning. Re-open Excel and a workbook. Does the problem still exist? Gord Dibben MS Excel MVP >I just tried that and it still gives me the error when I try to select >Format>cells. [quoted text clipped - 18 lines] >> > >> > Thanks. Thanks Gord. I tried the search on the offending pc and it does not locate a file with that name. Mindy > Try this trick which most times clears up the problem. > [quoted text clipped - 30 lines] > >> > > >> > Thanks. It's a hidden file, make sure you have hidden files included in the search (more advanced options in windows xp) SignatureRegards, Peo Sjoblom > Thanks Gord. I tried the search on the offending pc and it does not > locate a [quoted text clipped - 40 lines] >> >> > >> >> > Thanks. This computer is running Windows 2000. I do not see a hidden file option. I did this search on another of our computers running the same version of Windows and it did come up with 4 files by the name of Excel.XLB when I did the search. That computer doesn't have any issues with Excel. > It's a hidden file, make sure you have hidden files included in the search > (more advanced options in windows xp) [quoted text clipped - 43 lines] > >> >> > > >> >> > Thanks. Your *.xlb file will be named Excel9.xlb and is usually found in C:\Documents and Settings\username\Application Data\Microsoft\Excel Gord >This computer is running Windows 2000. I do not see a hidden file option. I >did this search on another of our computers running the same version of [quoted text clipped - 48 lines] >> >> >> > >> >> >> > Thanks. Still no luck finding the file on that computer. Could this be part of the problem? > Your *.xlb file will be named Excel9.xlb and is usually found in > [quoted text clipped - 54 lines] > >> >> >> > > >> >> >> > Thanks. Excel will always create a *.XLB file if none exists. It is the default file where Toolbar and menus setups are stored. If you delete it, Excel will build a new one. You "must" have one on your computer if you open and close Excel even once. I have never used Windows 2000 but when you open My Computer and go to Tools>Folder Options>View you should find an option button for "show hidden files and folders" Gord >Still no luck finding the file on that computer. Could this be part of the >problem? [quoted text clipped - 57 lines] >> >> >> >> > >> >> >> >> > Thanks. Found the file. Tried the renaming. Still got the error when I opened Excel and asked for it to format. Mindy > Excel will always create a *.XLB file if none exists. > [quoted text clipped - 71 lines] > >> >> >> >> > > >> >> >> >> > Thanks. You are running Windows 2000. Which version of Excel? If 2000 or earlier have a look at this KB Article XL: Illegal Operation Error When You Attempt to Format Cells http://support.microsoft.com/kb/285347/en-us Gord >Found the file. Tried the renaming. Still got the error when I opened Excel >and asked for it to format. [quoted text clipped - 76 lines] >> >> >> >> >> > >> >> >> >> >> > Thanks.
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.