Most Valuable Professional


View Jan Karel Pieterse's profile on LinkedIn subscribe to rss feed
Subscribe in a reader

Subscribe to our mailing list

* indicates required

Audit !!!

Check out our RefTreeAnalyser
the ultimate Excel formula auditing tool.

Trainings

Excel VBA Masterclass (English)
Excel VBA for Financials (Dutch)

Third party tools

Speed up your file

FastExcel
The best tool to optimise your Excel model!

Repair your file

Stellar Phoenix Excel Repair
Best tool to repair corrupt Excel sheets and objects
Home > English site > Articles > Startup Problems
Deze pagina in het Nederlands

Fixing Startup problems

This article was used by Microsoft to create a set of automatic fixes (Microsoft FixIt).  See:

http://support.microsoft.com/kb/280504/en-us

Unfortunately, many Excel users sometimes start experiencing problems with their Excel: File not found errors, compile errors, GPF's, Excel refusing to load, files which do not open, etcetera.

This is a list of things-to-try when Excel exhibits problems.

Content

Diagnostic tools

Microsoft have created a tool that searches your Office installations for known problems. It is called The Office Configuration Analyzer Tool (OffCAT).

You can download and install OffCAT v1.2 from the Microsoft Download site. You can either extract the files from OffCAT.zip or you can run the installer using OffCAT.msi. We recommend using OffCAT.msi because it contains system requirement checks that ensure OffCAT will properly function on your computer.

OffCAT is designed to be used by anyone that has Office installed on their computer. This includes home users, small business people, Help Desk professionals, Microsoft support engineers, and IT administrators. Microsoft expects everyone to have the skillset required to follow the directions provided in the list of detected issues. However, the Configuration Details report is mostly aimed at moderate to advanced users that can understand information in the registry, event logs, Windows services and other places in Windows outside of the Office applications.

Windows 10 related problems

With Windows 10 many problems have been reported in the newsgroups and fora regarding Office. Microsoft has written an elaborate article on the known issues and their possible resolutions here: Known issues with Office and Windows 10

Excel shows errors during startup or behaves odd

Try opening Excel without any addins or hidden workbooks

Use the Automation switch to start Excel without loading addins or workbooks from the XLSTART folder:

Click Start, Run,
"C:\Program Files\Microsoft Office\Office\Excel.exe" /Automation

Quotes mandatory, Note you may have to change the path.

If your error disappears, either an add-in or a (hidden) workbook that is loaded upon Excel's start bothers you.

 

Locate the offending file using the following steps:

 Excel Add-ins.

  1. Tools, Add-ins
  2. note which are checked
  3. Uncheck all (but one)
  4. Restart XL
  5. If no error, check the next one and repeat from step 4
     

Got the error? uncheck the one you last checked.

Com Addins

Another type of addins are COM addins. The way to get at these add-ins differs per Excel version.

Excel 2007/2010/2013

  1. Click the Office button/File tab and select Excel Options.
  2. Click the Add-ins tab
  3. In the dropdown near the bottom, select "COM Add-ins" and click Go.

Excel XP to 2003

  1. Rightclick a commandbar and choose customise
  2. Click the commands tab
  3. Find an entry in the tools section called "COM addins"
  4. Drag to any toolbar or menu
  5. Close customise dialog and click that menu item
  6. Uncheck all shown COM addins

If your problem still persist, some COM addins are not shown in the userinterface and can only be unloaded from the registry. Check the registry, at this location:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\Excel\AddIns\

Warning: Backup your registry before making ANY changes!!!

Not an add-in? It may be a (hidden) workbook causing trouble then.

Check workbooks that load at startup.

  1. Find your XLSTART folder (On Windows XP it may be a path like this:
    C:\Documents and Settings\Username\Application Data\Microsoft\Excel\XLSTART
  2. Move all files out of it;
  3. Open them one by one (in Excel) and find the one with the error;
  4. Move the others back.

You can also check whether a folder has been set to load at startup and repeat the above for that folder.

 Excel 2007/2010/2013:

Office button or File tab, Excel Options, Advanced tab:

Office button, Excel Options, General tab in Excel 2007/2010

Office button/File tab, Excel Options, General tab in Excel 2007/2010/2013

Excel 2003 and older:

Tools, Options, General, "Alternate Startup file location" or "At startup, open all Files in:" (The text depends on your version of Excel).

Tools, Options, General tab in Excel 2003

Open Excel in Safe mode

Start, Run,
"C:\Program Files\Microsoft Office\Office\Excel.exe" /Safe

The safe switch ensures Excel starts without opening any addins or using your menu customisations. If this works, chances are that your toolbar customisation file is corrupt. Locate all files with extension .xlb and rename the extension(s) to something like .old
Now try and start Excel again.

In Windows 7, the xlb file is found by entering this into Explorer's address bar:

%AppData%\Microsoft\Excel

Tip: You can also start Excel in safe mode by holding down the control key whilst you double-click the Excel icon.

Removing Excel's registry entries

Sometimes all actions listed above don't help to resolve the problem. For various users, removing Excel's main registry entry in Windows Registry solved the problem.

Warning: All cautions about tampering with the registry apply!!

As a last resort, remove the entire root folder of Excel from the registry (it should be recreated when you launch Excel). This is the registry key to remove:

HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\Excel

First find this key and export it to your desktop by right-clicking on the "Excel" entry in the folder tree and selecting Export.

Exporting Excel's main entry in the registry

When the export is done, right-click the entry in the tree again and choose Delete:

Deleting the Excel registry key

Now restart Excel and see if that has helped.

Opening Files From Desktop Or Explorer Fails

Reregister Excel with Windows

If you have trouble loading Excel files by double-clicking, the shell registration for Excel may have to be re-written. How to do that depends on your Excel version.

Excel 2007, 2010 and 2013.

In older versions of Excel, the /Regserver switch was used to write the shell registration for Excel. This was true up to Excel 2003, and was removed in Excel 2007. For Excel 2013, 2010 and 2007 you need to run setup/repair (running the Office setup in Repair mode from "Programs and Features", aka "Add/Remove Programs").

Excel 2003 and before

Click Start, Run and enter:

"C:\Program Files\Microsoft Office\Office\Excel.exe" /Regserver

This generally fixes trouble with opening Excel files from the desktop or by (double)clicking them in Explorer.

Ignore other applications

Check in Tools, Options, General tab whether "Ignore other applications" is set. Uncheck it.

Excel 2007/2010/2013

Ignore other apps in Excel 2007/2010/2013

Excel 2003

Ignore other apps in Excel 2003 and older

Trouble caused by antivirus software

NAV has shown to cause "Excel caused an invalid page
fault in module VBE6.DLL".
You might try disabling the Office plug in of NAV.

Trouble caused by corrupt temporary files

Try cleaning your TEMP folder:

In Windows 95/98 and ME

Delete all files in C:\Windows\Temp

In Windows NT/2000/XP

Find and Select C:\Documents and Settings\<user>\local settings\temp
and delete all files in there.

When a workbook contains controls from Excel's control toolbox temporary files are created in that folder. If such a temporary file is somehow corrupted it may prevent the workbook it belongs to from working normally and sometimes even causes Excel to crash.

Select Start, run and type %temp% and hit OK to directly open your temp folder.

Disabled files

As of Excel XP and 2003, files may have been disabled when Excel thought them to be the cause of a crash.

If you have had a problem with opening a file, Excel may have labeled it as suspect.

Excel 2007/2010/2013

Select the Office button (File tab in 2010) and click Excel Options. Click the Add-ins tab and use the dropdown:

Disabled Items in Excel 2007/2010

Disabled Items in Excel 2007/2010/2013

Excel XP, 2003

In Excel, select Help | About Microsoft Excel.
Click the button near the bottom labeled "Disabled Items..."

Disabled items in Excel 2003 and older

Disabled Items in Excel 2007/2010/2013

If the offending file is listed, select it and click Enable. The file you just enabled may of course cause Excel to crash again, click here to find some pointers on how to open corrupt Excel files.

Other resources

Do you have one particular file that causes trouble? Check out this page.

Microsoft Fix-it

Microsoft has recently added two pages on this subject, both with so-called "Fix-it" solutions for several elements stated above.

Excel 2003 and older:

How to troubleshoot startup problems in Excel

Excel 2007 and up:

How to troubleshoot Excel 2007 startup problems

With Windows 10 many problems have been reported in the newsgroups and fora regarding Office. Microsoft has written an elaborate article on the known issues and their possible resolutions here: Known issues with Office and Windows 10

Some information on startup switches:

http://support.microsoft.com/default.aspx?scid=KB;en-us;211481

What other people have to say about this subject:

http://www.cpearson.com/excel/StartupErrors.htm

http://www.contextures.com/xlfaqApp.html


Comments

All comments about this page:


Comment by: Mark Moore (3/15/2006 9:32:46 AM)

Thanks for this. I have written several addins for my users and these were placed in a Network Startup folder. Yesterday we had a network crash and afterwards, some but not all users were not able to access the addins. It was driving me crazy. But your page showed me the "new" feature I was not aware of, and for the affected users, Excel had indeed marked my addons as "disabled" even though it was a network problem. Thanks again

 


Comment by: Jan Karel Pieterse (3/15/2006 10:24:56 PM)

Hi Mark,

Thanks for your comment! Glad you solved the problem.

 


Comment by: YILDIRIM AYDIN (3/28/2006 12:56:42 AM)

"Could not load an object because it is not available on this machine"

 


Comment by: Jan Karel Pieterse (3/28/2006 10:49:33 AM)

Hi Yildirin,

Are you referring to a problem you are experiencing?

Regards,

Jan Karel Pieterse

 


Comment by: Jeremy (4/7/2006 9:37:07 AM)

Wonderful ! I thought I had created a template that would automatically save back-ups on all files. From the ensuing start-up I kept getting error messages and Excel would close down. After deleting and reinstalling, same problem. I found your suggestions, started in safe mode - it worked. I renamed XLBs (and XLTs) to OLD, and voilà!
Many thanks

 


Comment by: Carlos A Montgomery (4/18/2006 8:59:35 AM)

New weird problem... Some of my users have a problem when they open an Office file from a network share. If they open a folder from the desktop to a server share, then click on an Excel file, it will open. but, if they try to save it, Excel dies. Also, if they start excel and try to navigate to a server share, excel dies. They can copy/move files from the share to their local PC, edit to their hearts content, save to their local PC, exit Excel then move the files back.
Any ieas?

 


Comment by: Jan Karel Pieterse (4/19/2006 1:14:18 AM)

Hi Carlos,

Hmm, this might have a number of causes. The first that comes to mind is a rights issue. Do the users have full rights to the folders in question?

Regards,

Jan Karel Pieterse

 


Comment by: David Hawkins (4/30/2006 7:31:28 AM)

Every time I start Excel I get the error "Class not registered - looking for object with CLSID:{AC9F2F90-E877-11CE-9F68-00AA00574A4F}.
I have followed your instructions and Excel will open ok in "Automation". If then I check Add-ins, all boxes come up checked. If I either leave one checked or all unchecked, then tick "ok" I get the original error message "Class not registered etc" I notice at the bottom left hand corner it says "OPENING ACC LINK .XLA (followed by the small blue squares making a bar).
I am fairly sure this has happened since I downloaded Excel updates about a week ago. If I make a restore point before this date do you think this will fix the problem, or maybe you have another solution.
Your help would be appreciated as I use the Add-ins to send part of the workbook to others.

David Hawkins

 


Comment by: Jan Karel Pieterse (4/30/2006 12:15:36 PM)

I searched google with that error message and found this post:

<a href="http://groups.google.com/group/microsoft.public.excel.crashesgpfs/browse_thread/thread/3f8890b723deb7e9/976ab10802ff72f5?lnk=st&q=excel+looking+for+object+with+CLSID%3A%7BAC9F2F90-E877-11CE-9F68-00AA00574A4F%7D.&rnum=1#976ab10802ff72f5">this post</a>

 


Comment by: kannan (5/3/2006 4:50:39 PM)

I am not able to open Excel 2002
while double clicking the Excel icon the startup screen appear & then disappear then no process going on.
( I have removed office & reinstalled but the problem not solved)

 


Comment by: Jan Karel Pieterse (5/3/2006 9:56:12 PM)

Hi Kanan,

Did you try starting Excel in Safe mode?

 


Comment by: YILDIRIM AYDIN (5/4/2006 7:38:34 AM)

hi Jan,

Thans for the info.

 


Comment by: MaxRem (5/12/2006 1:09:43 AM)

BIG THANKS

 


Comment by: Sadi Ozdem (6/8/2006 4:20:38 AM)

Many thanks, I have moved the "pdfmaker" file from the xlstart file and it works. Thanks a lot

 


Comment by: hisbani (6/22/2006 4:45:37 AM)

i would like to run excel without one particular add-ins. Is there any way i can separate excel sessions so that when user run normal excel icon it loads all add-ins. In separate shortcut icon which only exclude one addin. I know it is possible just don't know how what extra switch needed in Icon Target path.

Any Advise??

 


Comment by: Jan Karel Pieterse (6/22/2006 8:09:04 AM)

Hi Hisbani,

You can use the /Automation switch, which prevents Excel from loading any addins.

Alternatively, you can download the <a target="_blank" href="http://www.excelkb.com/article.aspx?id=10192">Excel Loader</a>.

 


Comment by: Fredric Goodman (9/16/2006 1:01:33 AM)

After using Excel 2003 (XP) for a while opening and closing files slows down until I reboot. It happens on two computers.

 


Comment by: Jan Karel Pieterse (9/16/2006 12:15:00 PM)

Hi Fred,

Have you tried emptying your temp folder?

 


Comment by: aNIRBAN (9/20/2006 10:59:13 AM)

WHEN TRY TO START EXCEL
A EXCEL SPLASH CAME
BUT EXCEL NOT OPEN

 


Comment by: Jan Karel Pieterse (9/20/2006 9:19:19 PM)

Hi Anirban,

Didn't any of the suggestions on this page help?

 


Comment by: Daniel Amezquita (9/26/2006 9:45:19 AM)

Hi. Some of my users are experiencing problems to save Excel (Office 2003) files on a shared disk on server (Win 2003). The save takes long time, then at the end it says that there is not enough disk space on the disk (it has more than 30Gb free). I've tried everything (User rights, Network Connection, Opportunistick Locks Timeout Setting) and nothing helps. Any Idea?
Thanks

Daniel

 


Comment by: Jan Karel Pieterse (9/26/2006 9:57:38 AM)

Have you checked the anti virus software's settings?

 


Comment by: Greg (10/7/2006 2:41:44 PM)

thanks but none of the suggestions are working. No Office2000 products will open correctly on my xppro machine, they have worked fine for years until something-maybe the latest "critical update"-or maybe a virus messed itup. application loads but it locks and says "application not responding" after a bit. any app, word, excel, powerpoint the same- any ideas?

 


Comment by: Jan Karel Pieterse (10/8/2006 1:55:12 AM)

Hi Greg,

No, I'm sorry. Sounds like you need to reinstall your Office.

 


Comment by: Kush (10/9/2006 5:46:14 AM)

Hi,

Has anyone seen Excel disappear when pressing either the ctrl+c or ctrl+x shortcut keys? The menu and toolbar buttons seem to work ok. Reinstalling office has made no difference. Neither has "repair shortcuts" when repairing office.. This has been seen in both XP and 2003.

 


Comment by: Jan Karel Pieterse (10/9/2006 7:53:48 AM)

Hi Kush,

Does this KB article apply?

<a target="_blank" href="http://support.microsoft.com/kb/283667/en-us">
http://support.microsoft.com/kb/283667/en-us</a>

 


Comment by: sam (11/1/2006 5:24:40 AM)

Could not load an object because it is not available on this machine

any ideas why this happens

 


Comment by: Jan Karel Pieterse (11/1/2006 6:03:20 AM)

Hi Sam,

This is probably caused by either an addin or by a workbook in your XLSTART folder. See instructions on this page how to troubleshoot.

 


Comment by: Sandy (11/25/2006 4:22:55 PM)

This was of Great. Thank you.

 


Comment by: Danny P (12/4/2006 1:27:57 PM)

I cannot open files in excel, think there is some macro crap preventing them from opening. I get the "class not registered, looking for files with...." message

 


Comment by: Jan Karel Pieterse (12/5/2006 2:56:13 AM)

Hi Danny,

Have you tried the options on this page?

 


Comment by: Daniel McGilvry (12/10/2006 12:37:20 PM)

When I open Excel I get the following message twice before I can open a spreadsheet:
"The procedure entry point LdrLockLoaderLock could not be located in the dynamic link library ntdll.dll"

 


Comment by: Jan Karel Pieterse (12/10/2006 10:51:04 PM)

Hi Daniel,

Did you try the tips in section 1?

 


Comment by: Premanand (12/26/2006 11:12:30 PM)

For me, it is showing the error,
"Compile Error in Hidden Module UserForm 14".
This error is coming in my PC only.
My collegues are not getting this message for the same program although we all are having same configuration (i.eOffice 2003 with Windows XP)

 


Comment by: Jan Karel Pieterse (12/27/2006 3:26:08 AM)

Hi Premanand,

That is caused by either an addin or a file in the XLSTART folder. Instructions on troubleshooting are on this page.

 


Comment by: Gus (2/28/2007 3:59:20 PM)

Awesome! Cured my Personal.xls startup problems pronto! Many Thanks.

 


Comment by: Neil (3/2/2007 11:22:26 AM)

Should I see personal.xls in the XLSTART folder? I don't, and my macos disappear after I restart Excel after writing them.

 


Comment by: Jan Karel Pieterse (3/3/2007 2:37:23 AM)

Hi Neil,

You should. But maybe your IT guys have blocked access to that folder?

 


Comment by: brad (3/26/2007 3:48:41 PM)

the server that my default file location was on has been removed, and replaced on a new server. When i now go into excel options (2003)it advises me that it cannot find the server, I then cannot change tabs to go to General. Any ideas?

 


Comment by: Jan Karel Pieterse (3/26/2007 9:19:13 PM)

Hi Brad,

This is easy enough to fix, with one line of VBA code. We'll put it in what's called the Immediate window:
- Start Excel
- Hit Alt-F11 to open the Visual Basic Editor
- Hit control-g to open the "Immediate window"
- type this line of code:

Application.DefaultFilePath=""

- With your cursor on that line (anywhere), hit enter
- Close the VBE and return to Excel
- try tools, options.

 


Comment by: 4z4zel (4/4/2007 11:21:20 AM)

Hi,
I have a problem after starting an random excel file - every time i start it the excel file is opening and after that excel saves the file right away.

Problem is there are many files on random shares which are mapped - if the file is big it can take a really long time to open the file. We tried everything - every addin is turned off autosave is turned off but still the problem exists...

MS office 2000

Any ideas?

 


Comment by: Jan Karel Pieterse (4/5/2007 2:15:48 AM)

Hi 4z4zel,

What happens if you open the file whilst holding down the shift key (prevents any auto-open macros from running)?

 


Comment by: JimRac (7/17/2007 8:10:54 PM)

Hi,

I have a strange Excel startup problem here at work.

I have released a suite of macros to a number of biz users as an add-in, works fine for all people except one.

When she enables my add-in and then exits and restarts Excel, all of her Excel workbooks start acting like Add-in's, i.e. when she tries to open any workbook, the worksheets are hidden and the menu options are grayed out. Again, this happens with any workbook she tries to open.

But if she goes to the Application Data\Microsoft\AddIns folder and launches my add-in, all is good - Excel than functions normally for all her workbooks.

The kicker is that if she then goes to the Add-Ins menu and screen and disables my addin, then everything works normally again, including my add-in (it's a toolbar that drives some macros).

Any ideas? This just occurs with the one user, others are fine. I was considering just giving her the xls with the macros, and have her keep that open whenever she needed them.

We are all on XP & Excel 2000.

Thanks, great site btw.

Jim

 


Comment by: Jan Karel Pieterse (8/1/2007 10:07:17 PM)

Hi Jim,

Strange problem indeed. Does your addin have any code that changes the way Excel loads, i.e. startup path, things like that? Or does it contain application event code that runs when workbooks are opened?

 


Comment by: Steven Moore (9/12/2007 8:12:25 AM)

I have an error message that appears at the startup of a spreadsheet.

"Could not load an object because it is not available on this machine"

I have tried everything shown on this page and nothing has worked.

The spreadsheet has a userform that starts automatically when it is opened and the message appears before the userform is shown.

Do you ahve any other suggestions on how to fix this?

 


Comment by: Jan Karel Pieterse (9/12/2007 9:41:06 AM)

Hi Steven,

Your problem is caused by the fact that the userform contains a control that is not native Excel and does not exist on your machine. If you look in Tools, references (in the VBA editor) you will probably see one saying "MISSING". That file is the culprit.

 


Comment by: Steven Moore (9/13/2007 7:33:09 AM)

Thanks for the help. I've just found the "MISSING" reference.

 


Comment by: CV (9/23/2007 3:30:47 PM)

Hi,

I've got a Userform which opens when i open the excel sheet. The suer form contains a label which has shows today's date. For some reason that is not loaded (shows Missing in References)and the error pop up"could not load an object becuse....".

Any way i can add tht in the code to be loaded.

Can u help me..

 


Comment by: Jan Karel Pieterse (9/23/2007 9:04:10 PM)

Hi CV,

Your userform obviously contains a control that is both: Not native Office and not on your machine. Check Tools, references (inthe VBA editor) and note which are marked MISSING. That should indicate what dll houses the offendig control.

 


Comment by: john embree (9/27/2007 4:46:24 AM)

excel 2007 the above does not work,...my excel 2007 will open..but only a blue screen appears...but choosing a new spreadsheet will work... but this is no good.. help would be grateful..john

 


Comment by: Geert Rottiers (10/4/2007 1:34:45 AM)

Hi all,

I am having an issue where excel seems to corrupt my personal.xls file whatever I try. Even when simply deleting it, I still get a message in excel stating 'the file is corrupt'. I am opening text-based files so there are no macro's in there.

Would anyone have an idea? I already cleared temp folders and even ran the Excel repair tool but no luck.

Thanks!
Geert

 


Comment by: Jan Karel Pieterse (10/4/2007 9:49:44 PM)

Hi Geert,

Are you sure it is Personal.xls which is causing the problem?

What Excel version are you using?

 


Comment by: madani (12/12/2007 10:57:33 PM)

hi,
in my excel 2007 when i double click on any excel file in explorer. The file does not open but only excel application opens. Now from the excel when i click on open icon, open file dialog box appears, without selecting any file if i click cancel, it opens the file which i clicked in explorer.
"ignore other applications that use dynamic dde" is uncheck.

 


Comment by: Jan Karel Pieterse (12/15/2007 8:16:43 AM)

Hi Madani,

Hmm, no idea really, sorry.
Have you tried the "regserver" advice stated above?

 


Comment by: john (2/9/2008 6:45:44 AM)

hi
thanks to you for your help in solving various problems for me i have yet another excel constantly tells me that "there are not enough resources to completely show page or object", now this can happen by just scrolling accross a spreadsheet or clicking on a cell , my program does not need any of the add ins to work its just a simple database of furniture and i wrote all the macro's in excel 2003 without any add ins loaded the resource thing started in excel 2003 i got all the updates ...no effect so i installed office 2007 done updates still same another factor i dont understand is this i have 2 machines
the specs are
1st machine

amd 3.2
ati x200 video 128mb
1gig memory
200gb hard drive

2nd machine
intel celeron 3.2
ati x200 video 128mb
1gig memory
200gb hard drive

excel works without a hitch on the amd system

but on the intel system error after error
after error
i am sorry to rant on but its just so frustrating and i am also sorry if this is the wrong place for this problem any way thank you for taking the time and thank you fopr your patience


john

 


Comment by: Jan Karel Pieterse (2/10/2008 12:49:21 PM)

Hi John,

Have you tried to remove all files in your temp folder and in:
c:\documents and settings\[user name]\Application data\Microsoft\Forms\

 


Comment by: Melissa (4/16/2008 1:37:31 PM)

Hi,
I have XL 2000 at work, WinXP, and when I open any XL file, it also opens my PERSONEL.xls. What could be causing this, and if I try some of the things above, will it stop?

Thanks!

 


Comment by: Dharm (4/23/2008 1:10:19 PM)

I use MS excel 2003.
Recently i had downloaded Google desktop and a few desktop gadgets alongwith it. after using them i started having problems with my MS Excel 2003.
I have the same problem as listed above, i can open excel in safe mode, on double clicking MS excel shortcut a blank workbook opens and excel files also open using the Open command on the menu bar.
The files do not open however on double clicking in windows explorer (Note: The excel application opens)
Have carried out all the above troubleshooting tips, removing add-ins, com addins, registry fixes, .xlb files, .pip files, detect and repair.
I have also uninstalled Google desktop,
and uninstalled and reinstalled MS Office 2003.
The problem still persists even after reinstalling MS office.
Have troubleshooted exactly as done even in the microsoft articles.
Please advise solution

 


Comment by: Jan Karel Pieterse (4/23/2008 11:30:36 PM)

Hi Dharm,

Is by any chance Ignore other applications set in Excel's Tools, options, general?

 


Comment by: Dharm (4/24/2008 9:49:53 AM)

I have unchecked the Ignore other applications in General Tab and also the open files in text box is blank

 


Comment by: Jan Karel Pieterse (4/25/2008 6:39:40 AM)

OK, what about this:

How to reinstate Excel's ability to open files with spaces
in their name/path by double clicking:

1. Have Excel correct it

1. Choose start (Start button), Run, type:
"C:\Program Files\Microsoft Office\Office\EXCEL.EXE" /Regserver
2. Click OK

2. Do it yourself

1. Open Windows Explorer.
2. Choose from its menu: View, Options. (or View / Folder Options in Windows 98)
3. Select the File Types tab
4. Scroll to Microsoft Excel Worksheet
5. Click Edit
6. Select the OPEN entry (it should be highlighted (bolded)
7. Click Edit and check that the fields are set as follows:
a) Application used: should be EXCEL.EXE, loaded from the correct directory
b) Use DDE should be checked
c) The DDE message should be (exactly): [Open("%1")]
d) Application should be: excel
e) DDE Application not running should be empty
f) Topic should be: system
8. Click OK
9. Click Close
10. If you wish to double-click other Excel file types, e.g. template
(xlt) or workspace (xlw), select the appropriate type in the File Types
tab and repeat from step (5)

For the XLVIEWER:

- Use DDE turned OFF
- Command line: "c:\program files\xlview\xlview.exe" "%1"

 


Comment by: Dharm (4/26/2008 10:15:53 AM)

1.Carried out the unregserver / regserver from the run command.

2.after which i opened Windows explorer / Tools / folder options / File types / selected the xls extension advanced options.
checked open command is bold and in edit options

The following is in the text boxes :
Action : &open

App. used to perform action : "C:\Program Files\Microsoft Office\OFFICE11\EXCEL.EXE" /e

Use DDE is checked and DDE message : [open("%1")]

Application : Excel

Application not running : <blank>

Topic : system

I am yet unable to open excel on double clicking. I have uninstalled and reinstalled office 2003 too.

 


Comment by: Jan Karel Pieterse (4/26/2008 12:37:59 PM)

Odd, These are exactly the same as mine.
I'm out of idea's.

 


Comment by: Ernie Rincon (9/25/2008 11:10:12 AM)

I appreciate the great information. Its nice to see that people like you are still
around on the NET. I'm tired of running into sites where they always try to bleed
people for information, that is not what the internet was about but now it sadly is
becoming that way. Thank you once again.

 


Comment by: Aytekin (9/26/2008 3:48:36 AM)

John,

If you are getting "Out of memory" message on XP & Excel check the below link. It
seems it's due to XP's desktop heap size. It helped me.

http://support.microsoft.com/kb/126962

 


Comment by: Jan Karel Pieterse (9/26/2008 4:32:26 AM)

Hi Aytekin,

Thanks!

 


Comment by: Pedro Sousa (1/7/2009 6:49:43 AM)

When I exit Excel 2007 there is a crash with the following message: "Microsoft Office Excel has encountered a problem and needs to close. We are sorry for the inconvenience".
The box Recover my work and restart Microsoft Office Excel is checked.
This error appears 2 times, on the third time to exit EXCEL there is no problem.
When I open again EXCEL with a document or I create a simple text document like: ABCDE when I try to close Excel the same error occurs again...
I try the same on safe mode, there is no problem !

Is there anything what I can check, f.example which service or process is doing that problem ?

Thanks from Portugal

Pedro Sousa

 


Comment by: Jan Karel Pieterse (1/7/2009 7:21:06 AM)

Hi Pedro,

I'd suggest trying to turn off the addins as described above. Also remember to turn off COM addins.

I'll update this page to include the Excel 2007 instructions later this week.

 


Comment by: Paul (2/11/2009 9:12:54 AM)

In Excel 2007, when another user on the network has the file open, my attempt to open the file indicates that the file cannot be found, as opposed to getting the message that it is locked for editing with the option of Read-Only or Notify.

The problem is that on some 2007 installations it seems to work as expected and others it gives the file now found message. So I'm assuming there is a setting somewhere, or a conflict with something.

Any ideas?
Thanks,
Paul

 


Comment by: Jan Karel Pieterse (2/11/2009 11:23:24 AM)

Hi Paul,

No, I'm afraid I have no answer to that one. Given that you got to this page I assume you have already searched Google for an answer?

 


Comment by: Paul (2/11/2009 12:55:40 PM)

Many, Many, Google Searches. 15 to 30 pages deep with nothing solved. There was one site that hade an inquiry about it. They gave some screen shots and along with it. It is exactly what I'm asking. The only thing, it is Experts-exchange and in order to see the replies, they want money.

http://www.experts-exchange.com/Microsoft/Applications/Q_24107997.html

Chances are that the replies don't give any futher explanation. In addition to the URL above, I have seen others with the same problem...but no solutions. What's add is that some Office 2007 installations on the same network do not experience the same issue. However, some do...it's not just me.

I guess I'll keep looking.
Thanks,
Paul

 


Comment by: Jan Karel Pieterse (2/12/2009 4:39:15 AM)

Hi Paul,

And chances are there isn't even a useful answer in there anyway!

I suspect this is a user profile problem. Have you tried logging in (with an offending account) on a different machine?

If that solves the problem, get in touch with your IT support and ask them to remove the profile from your machine (remember to ask them to salvage important stuff like Outlooks pst files and your "my documents" folder).
If it does not help, you might get it solved by removing your roaming profile (if you have that) AND remove the profile from the machine. Your IT support should be able to do this stuff.

 


Comment by: Gordon (2/18/2009 6:27:50 AM)

@Paul
The accepted solution was related only to Netware and the suggestion was to check the Novell settings, particularly that the Netware opportunistic locking and file caching is set to 'off', and the client file commit set to 'on'.

ExpertSexchange uses a bit of sneaky obfuscation to show Google's spider their full answer, but hide it from casual viewing. This gets them high pageranking and is against Google's T&Cs, but they seem to get away with it.

You can use Google's cached version to see the full version, all you have to do is scroll down. They have mucked about with the exact methods used to hide the solution text in the past though, Google "experts exchange scroll down" to find out more.

 


Comment by: Nicky (2/26/2009 9:50:00 PM)

This problem may occur if a noncontiguous selection is included in any one of the following:

    * Sheet selection
    * AutoFilter
    * Publishing Excel data to a Web page
    * Conditional formatting
    * Pivot Table reference
    * Pivot Table area
    * Pivot Table location
    * Unknown XML

This issue is fixed in the Excel 2003 hotfix package that is dated February 29, 2004. But still if you are facing same error then you need to try excel repair software from here: http://www.repair-excel-file.com/

I have used Stellar Phoenix Excel Recovery Software to repair my corrupted excel database and by using this software, I was able to recover my database.

 


Comment by: Petri Wilska (2/28/2009 3:45:43 AM)

Hi JKP

Solved my Excel Crash problem. A COM add-in (Bluetooth one) was the cause.

Thanks a million. Life is a whole lot easier now!

Petri Wilska

 


Comment by: Jan Karel Pieterse (2/28/2009 3:49:53 AM)

Hi Petri,

Could you perhaps tell us what bluetooth addin this is (what installed it)?

 


Comment by: Daniele Finocchiaro (3/13/2009 5:11:05 AM)

I think I had a problem similar to Petri.
Excel 2003 crashed on startup (when double-clicking)/exit on Windows Vista.

The problem disappeared after I changed the following entry in the registry:

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\Excel\Addins\BtOfficeAddin.BtOfficeIntegration.1]
"LoadBehavior"=dword:00000000

(previous value was 3).
No idea on who installed this add-in related to Bluetooth.

 


Comment by: Jan Karel Pieterse (3/13/2009 7:39:54 AM)

Hi Daniele,

Are you by any chance using a Toshiba machine?

 


Comment by: Katherine (3/22/2009 8:11:17 PM)

Thank you, thank you, thank you. I have been trying to fix a problem with my undo and redo buttons and menu backgrounds in forever. I used your advice to edit the registry and delete the excel folders and it worked. Yeah!!!!

 


Comment by: Remis (3/31/2009 1:04:42 PM)

Thanks a lot! same problem was on my Dell Latitude E5500.
Excel crashed continuosly at startup if double clicking file, problem was in same registry key, HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\Excel\Addins\BtOfficeAddin.BtOfficeIntegration.1]
"LoadBehavior"=dword:00000000

(previous value was 3).

 


Comment by: Jan Karel Pieterse (4/1/2009 12:40:01 AM)

Hi Demis,

I'd be interested to learn which addin was causing your trouble. You have disabled the addin by using the registry change. Note that normally you should be able to change load behaviour of an addin using the COM addins dialog, which is the recommended method.

The registry change is only needed for addins which are causing havoc AND are not available in the COM addins list.

 


Comment by: Zeev (4/3/2009 9:48:47 PM)

Not Spam

Thanks a lot! same problem was on my Lenovo T500.
Excel crashed at startup if I tried to open a new file from a working excel file. The problem was in same registry key, HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\Excel\Addins\BtOfficeAddin.BtOfficeIntegration.1]
"LoadBehavior"=dword:00000000

(previous value was 3).

 


Comment by: Margaret Mc Daniel (4/10/2009 2:28:36 PM)

My problem is when I open MS Office Excel 2007 the page is gigantic and stretched out so big I can't use it. If I have any other programs open at the same time, they all change into this HUGE stretched out page also.
When I use the MS Office Word 2007 I have no problem, it is just with Excel, not the others.
I have asked this question other places, but no one seems to understand what I am trying to say.
Any ideas?
My Dell computer runs Vista.

 


Comment by: Jan Karel Pieterse (4/11/2009 2:36:29 AM)

Hi Margareth,

You mean the window of Excel is much wider than your screen width? I have seen this happen on systems that sometimes use two monitors, but other times not and Excel still thinks it can span two screens. I expect a quick way around this (if you have only one program running) is by right-clicking the taskbar of Windows and selecting "Cascade windows".

Then drag Excel's window to the dimensions you like it to have and close Excel.

Now try to open Excel again and see whether the window size is back to normal.

 


Comment by: zacharias (4/29/2009 7:08:16 PM)

when i try to close excel 2007 sp2 the program does not respond and appear window says "microsoft program stop working" , after restart program . how can i correct this the problem ? this is appeared only in excel .

thank you

 


Comment by: Jan Karel Pieterse (4/30/2009 1:45:19 AM)

Hi Zacharias,

I'd suggest to try the suggestions on this page until you find the culprit.

 


Comment by: Mike (5/18/2009 11:55:51 AM)

I'm running Office 2003 on Windows XP. All programs work except Excel, which crashes immediately upon loading. I've deleted the temporary files; the XLSTART folder is empty though. Could this be the problem? If so which files should be in this folder? Thanks.

Mike

 


Comment by: Jan Karel Pieterse (5/19/2009 12:58:47 AM)

Hi Mike,

I suggest you try the other options shown above first. XLSTART may be empty, that poses no problem. In fact it may prevent trouble, as Excel cannot load anything from an empty XLSTART folder.

 


Comment by: Amit (5/28/2009 8:26:16 AM)

I recently installed 2007 and with 2003 excel exisiting on my laptop. For various reasons I deleted the 2007 version. I have this macro enabled spreadsheet which nows give me a System Error &H800004005 (-2147467259).Microsoft Visual Basic Out of Memory.
I have an add-in which is TM1 8.44 version. This worked with both versions. Now error occurs
Appreciate your advice.

 


Comment by: Jan Karel Pieterse (5/28/2009 10:58:09 AM)

Hi Amit,

I advise you to open Excel and do a Help, detect and repair. Removing Office 2007 may have caused your problem.

 


Comment by: Amit (5/29/2009 1:15:42 AM)

Thanks Jan,
This worked perfectly.

 


Comment by: Matt (7/8/2009 1:38:39 PM)

I'm running excel 2003 from Office 2003 on Windows Vista Home Premium. I have recently been unable to launch Excel, The message says "Excel.exe has stopped working" I have tried all of the solutions I can find to no avail, every attempt returns the same message.
Can you help?
I have also tried to re-install from the original disk but the computer freezes before completing. Also tried to uninstall with the same result.

 


Comment by: Jan Karel Pieterse (7/8/2009 9:22:38 PM)

Hi Matt,

Maybe you can try one or more of the "Fix-It" solutions found here:

http://support.microsoft.com/kb/280504

 


Comment by: Martin (7/24/2009 2:42:56 PM)

Yes, disabling bluetooth made it ...

 


Comment by: Amit (8/5/2009 1:15:39 AM)

Hi,
I am doing a small automation of Excel in VB6. I have a Excel Addin(.xla). Actually I have this template stored in some location. While doing the automation, I copy this file to the desired project related output folder and then try to work on this copy.

Now the issue, is my template Excel file has the correct file for the Addin, but when I see the excel copied to the project folder, the addin is not working. When I manually open the File and see, the Addin is selected, but not working. Then, when I manually Browse and select the desired Addin, I am getting all the values correctly.

Could you please help me with this?

Thanks in advance,
Amit

 


Comment by: Dutch (8/11/2009 8:32:39 AM)

Have had similar problems, Excel crashed immediately. Starting in Safe mode was OK, but back in normal mode it was able to start once but then crashed again.

Cleared XLSTART, Registry, disabled Add-Ins, uninstalled and reinstalled, analysed and repaired, deleted XLB's, PIP's, everything without success.

Finally solved the problem by hunting my harddisk for all files called "EXCEL*.*" and deleted some that were not those that you would expect from the standard installation.

I don't remember which ones it were, but now Excel boots without problems.

Dutch

 


Comment by: Jan Karel Pieterse (9/7/2009 9:02:20 AM)

Hi Amit,

This page shows you what it takes to install an Excel addin using the registry:

http://www.jkp-ads.com/Articles/AddinsAndSetupFactory.asp

 


Comment by: Pepper Reasnover (9/30/2009 7:47:28 AM)

When I delete a saved document anew window opens up automatically when I did not want it to. Why is that happenning?

 


Comment by: Joe (9/30/2009 9:10:40 AM)

Jan,

Your tips helped solve my problem! I loaded MS Office 2000 Pro on a new, clean PC running XP SP3. From the get-go the problem I had was that when I used the "undo" button, the "redo" wouldn't light up. This would happen in empty workbooks as well as existing files. I went through the add-ins and found that "auto-save" was the culprit. I have unchecked it and now the "redo" button works properly. So is there anyway to fix it or does it mean that I can never use the auto-save add-in?
Thanks
Joe

 


Comment by: Jan Karel Pieterse (9/30/2009 10:15:39 PM)

Hi Pepper,

What program are you using to delete the file, Windows explorer?

 


Comment by: Jan Karel Pieterse (9/30/2009 10:17:57 PM)

Hi Joe,

When Excel saves your file, the undo and redo lists are emptied. There is nothing you can do about that. Please note, that as of Excel XP Excel has an autorecovery feature, which saves intermediate results so that if Excel crashes it can recover your work. Not an alternative to autosave exactly, but it may help to turn it on.

 


Comment by: Pepper B. Reasnover (10/2/2009 5:13:45 AM)

Yes I am trying to delete the excel doc using windows explorer.

 


Comment by: Jan Karel Pieterse (10/2/2009 5:37:12 AM)

Hi Pepper,

Odd. What kind of information does the window contain?

 


Comment by: Yansen (10/11/2009 11:51:14 PM)

Hi there! 10x for helping me to solve my problem! Good work! ;)

 


Comment by: Pepper Reasnover (10/12/2009 8:27:30 AM)

    Well actually I am working at a help desk and a customer called in with this issue, so as far as what they may have had in the doc im'm unsure of but I would imagine it being financials or orders of some sort inputed on an excel spread sheet.

 


Comment by: Jan Karel Pieterse (10/13/2009 12:43:39 AM)

Hi Pepper,

Sorry, I meant to ask what the window contains that opens up after the delete: what program opens, the program that "belongs" to the file being deleted?

Sounds to me as if the system of that user has a major problem.

Try if the problem persists if he/she logs on to a different machine. If that resolves the problem, you'd best remove the user profile from the offending machine and have the user log onto the machine again. Make sure all user files are backed up first however.

 


Comment by: Arlin Tate (11/5/2009 2:58:53 PM)

When I first open Excel (Office 2003) or an existing Excel file I get a message with the header Microsoft Visual Basic and the error message: “ License information for this component not found. You do not have an appropriate license to use this functionality in the design environment.” Then I click OK and get a Microsoft Visual Basic message that says: “ActiveX component can’t create object”. I click OK on this and then it lets me open Excel and I'm able to do whatever task in Excel that I choose. What is causing these messages? I'm using the same PC with XP Prof. for the last two years without these messages until just recently.
Thanks!


 


Comment by: Jan Karel Pieterse (11/5/2009 10:19:14 PM)

Hi Arlin,

Just follow the instructions starting from the top of this article, you should be able to find an addin that is causing this or a workbook that is loaded when Excel starts.

 


Comment by: jack (11/23/2009 11:30:30 PM)

I Want to use excel in vb but i have install excel in server not in my system.

How to access that excel in my system without install excel in my system.

Can Any one help me..

 


Comment by: Jan Karel Pieterse (11/24/2009 3:14:00 AM)

HI Jack,

I'm sorry, but in order to be able to use Excel you must install it on your system.

 


Comment by: Kevin (1/14/2010 8:36:02 PM)

I been having trouble printing in Excel 2007. In files created in Excel 2003, the print range prints fine. But when we converted to 2007, it is chopping items over 100 rows. Not sure why? There are no macros or anything. I can't figure this out.

 


Comment by: Jan Karel Pieterse (1/15/2010 7:46:09 AM)

Hi Kevin,

Are you sure the proper range is set to print?
This may also be related to having a different printer driver, rather than just a different Excel version. Try if setting the print settings in Excel 2007 fixes things.

 


Comment by: Kevin (1/15/2010 9:25:47 AM)

No I believe it is a spooling issue. When I print preview or send to PDF / Onenote it only sends some of the print range (about 85 rows of data).

I am truly puzzled. I changed printers / drivers to no avail.

 


Comment by: Jan Karel Pieterse (1/16/2010 11:42:20 AM)

Hi Kevin,

Can you email me the file (just one sheet which shows the problem may suffice, replace sensitive data with random text please)?

 


Comment by: Ron Sullivan (1/24/2010 10:27:58 AM)

Comment:

Ref “Microsoft Visual Basics – License information for this component not found.”

Many thanks for your excellent tips. For your information I use MSO2003ProSP3 and Excel suddenly gave me the dreaded "MVB License information for this component not found" etc. With your guidance I was able to work through your instructions and located the problem at “Check workbooks that load at startup” - D:\Documents Settings\Username\Application Data\Microsoft\Excel\AltStart (not XLSTART) which contained an "OfficeReady Stuffit" sub-directory. I renamed the directory "\1Altstart" and the problem vanished. I must admit that the latest version of "Smith Micro Stuffit 2010" has caused a few hiccups with Office 2003 and they have intimated that it might cause problems with a few of the office components including using Word with Outlook. I will have to see if they have any upgrades or get them to deal with this problem.

Hope this helps any other users with this problem.

 


Comment by: Luis (2/3/2010 1:20:35 PM)

Removing the Add-ins worked like a charm!!!
Thanks a lot!

 


Comment by: Engr. Femi Ogunfowokan (3/25/2010 4:46:05 AM)

Hello, i dont know if you can help me out, when i save 2003 Excel file to desktop, when i try to open it, it will only open a blank sheet.

 


Comment by: Jan Karel Pieterse (3/25/2010 5:08:30 AM)

Hi Femi,

If you open Excel and click on the File menu (Office button for Excel 2007), is your file listed in the list of recently used files?

If so, if you click that entry, does your file open then?

If the answer to these two questions is Yes, then check out what I wrote under:

"Files will not open from explorer"

 


Comment by: Teri (4/24/2010 5:33:48 AM)

I also had problems with Startup, where I got a message stating "Unable to find quit on the file menu". The offending file was in C:\Documents and Settings\****(my username)***\Application Data\Microsoft\Excel\XLSTART, and was named TbRun97. I made a copy of the file (just in case I lost it and it needed to be put back!), then deleted it and tried opening Excel again. Perfect - no problems at all. Can't believe it was this easy!

 


Comment by: Keith Jacks (4/30/2010 3:57:46 AM)

When I open excel i get twp msgboxes:
msgbox1: MS Visual Basic
         Errors occurred during load
         OK    Help
Help = Check error log for more descriptive information
OK = msgbox2:
         MS Visual Basic
         Can't load or unload this object
                 OK
Clicking OK opens Personal.xls
I have 23 macros listed in VBE, the code for which was imported from another drive.
However - I can't import any forms, when I try the following msgbox appeared:
             MS Visual Basic
     Class not registered
Looking for CLSID:{C62A69F0-16DC-11CE-9E98-00AA00574A4F}

 


Comment by: Jan Karel Pieterse (4/30/2010 6:52:50 AM)

Hi Keith,

Check out if this mMSDN article helps:

http://support.microsoft.com/kb/182500

 


Comment by: Keith Jacks (5/5/2010 2:54:11 AM)

Hello Jan

Yes - brilliant, problem sorted (Good old Microsoft!! - guaranteed to disappoint!).

Many thanks.

 


Comment by: sql2k8 (5/12/2010 9:19:32 AM)

excel is not importing into an application

when i load an excel sheet into the application. it is not getting uploaded .it tells to me that it is an invalid spreadsheet. i had created a table in EXCEL and i had loaded the data into the excel using ssis.

is there any way the user can import the data from excel to the appplication with out opening and saving the excel sheet. if the excel is opened and saved then the excel gets loaded into the application. but i dont want that.

 


Comment by: Jan Karel Pieterse (5/14/2010 6:07:20 AM)

Hi sql2k8,

Which application are you referring to? Maybe this application cannot import all Excel file types?

 


Comment by: Kent (6/10/2010 2:47:16 AM)

Hi Jan Karel,

thanks for this article; I have a user who needs particular Add-Ins so I can't just disable them, and there is no Bluetooth COM Add-In or anything suspicious like that. I examined the Event Viewer logs and it's clear that Excel is crashing (the error that I get I presume is from MS Diagnostics: "Excel has stopped working") but it's not evident why. I have asked the user to try fresh worksheets and to see if the problem can be consistently replicated (I can certainly clearly see each crash event in the Event Viewer).

Any tips or ideas where to look for more diagnostics or other troubleshooting tips?

Alvast bedankt!

Met vriendelijke groet

 


Comment by: Jan Karel Pieterse (6/10/2010 4:29:55 AM)

Hi Kent,

It is not the intention to permanently disable those add-ins, just temporarily to see if any of them are causing the issue you are experiencing.

Look in the links section higher up this page for other pages on startup problems.

 


Comment by: Gunnar Hemström (8/2/2010 5:00:13 AM)

Hi Jan Karel,
I have reason to believe that you would recognise btsendto_office.dll and its associated COM addin as a source of trouble in Excel 2007: [B]What does this addin help me with?[/B] If I deactivate it, it certainly makes my excel sheets start and close allright, else Excel crashes after a sheet is closed and reopened however simple it is.

Best regards

Gunnar H

 


Comment by: jim jesberger (8/5/2010 9:25:10 AM)

unable to send a spread sheet directly from excel screen via the internet. the messages remain in the outbox. thanks

 


Comment by: Jan Karel Pieterse (8/16/2010 3:25:04 AM)

Hi Gunnar,

I have never heard of that dll, but it obviously contains a bug. I'd leave it diabled. Have you tried searching google for that dll?

 


Comment by: Jan Karel Pieterse (8/16/2010 4:26:01 AM)

Hi Jim,

I'm afraid I wouldn't know whow to resolve this, this is probably an Outlook issue.

 


Comment by: Thomas J Peel (9/4/2010 7:10:07 PM)

I have Excel 97. I click Tools,Options. Microsoft says it has to shutdown and I send error report to Microsoft. It worked properly before I had to reformat and restore the computer to factory defaults to fix andother unrelated problem. I have uninstalled and reinstalled in both normal and safe mode. I used the 2003 Office Resource Kit that a removal tool for removing all of Office 97. I have run CCleaner as well. My other source says the only way to fix is to backup all my data and do a full factory restore or run from CD. Do you have any other options.? Thank you. Have a nice day and smile!

 


Comment by: Jan Karel Pieterse (9/5/2010 3:21:59 AM)

Hi Thomas,

Removing the registry entries of Excel (see description on this page) should resolve that problem.

 


Comment by: Rick Montalvo (11/1/2010 8:35:39 AM)

Greate job with this article.

 


Comment by: Jan Karel Pieterse (11/1/2010 8:46:47 AM)

Hi Rick,

Thanks!

 


Comment by: Mack Barnes (11/2/2010 7:37:17 PM)

Thankyou for your help. as soon as i changed the autosave add on, the messages at startup went away.. THANK You!!!!

 


Comment by: Ferdie Javil (11/24/2010 5:08:20 AM)

Cool!!! Thanks for these tips, it helped me a lot!! I now have your page in my Favorites link

 


Comment by: Charlie (11/24/2010 7:52:37 AM)

YAHOO! Excel lives again.
you are a geniusssss
5 Stars!

 


Comment by: Susan (12/27/2010 4:16:40 PM)

My worksheet constantly saves while working in Excel. It is very frustrating because it freezes the worksheet for an instant every few seconds. I am very computer illiterate. So if you have a solution for me (oh please do) you will need to walk me through it step by step and not assume that I will know what you are talking about. Thank you in advance. By the way I have tried to set the auto save in Excel to every fifteen minutes (File, Options, Save, select auto Recovery box set on 15 min.), but does not effect my problem.

 


Comment by: Jan Karel Pieterse (12/28/2010 6:04:16 AM)

Hi Susan,

If this only happens to one particular file, then it sounds to me like there is some VBA macro in your file that is doing this saving business. Is there any VBA code in the file in question?

If this happens on any file, then an add-in or a workbook that opens during startup may be causing this. To check for that, follow the step-by step instructions in the section near the top called:

"Excel shows errors during startup or behaves odd
".

 


Comment by: Penny Ludeman (1/4/2011 8:47:22 AM)

I have a user running Windows 7 64 Bit, and Office 2007. He has a Quad Core Processor and 4GB/RAM. He is getting Random crashes of Excel with a 7001 Stop Error. He is running Google Desktop to access most of his files on a Server Share. He was running this same scenario on an XP 32 Bit PC without trouble. I've tried several of your solutions and his problem goes away for about a week then returns. Can you suggest how I troubleshoot this problem?

 


Comment by: Jan Karel Pieterse (1/5/2011 12:21:13 AM)

Hi Penny,

Are these crashes on particular Excel files, or are they on random files?
What happens if Google desktop is turned off?

 


Comment by: Penny (1/5/2011 7:21:16 AM)

Yes, these are Excel files, I have completely removed Google Desktop and he still gets the error.
I have now reinstalled Google Desktop and re-indexed his files.
I have also had him convert many of his old .xls files to the new .xlsx format. This seems to make it happen less frequently, but he still gets the crash.
I have run diagnostics on his PC for hardware problems and everything comes up clean.
I cannot seem to duplicate the problem, it is a very random thing. Re-opening the files in sequence when he received the error, does not force the crash.
The last crash he had, locked up his Outlook from Printing and then that crashed also. I'm not sure if the two are related at this point, but it certainly adds to the frustration.
I did run a repair on from the Office 2007 install disk at that point.

 


Comment by: Jan Karel Pieterse (1/5/2011 7:40:47 AM)

Hi Penny,

I seem to recall that there are some problems with Excel files opened directly from email attachments in Outlook, maybe that is at play here too?

 


Comment by: Penny (1/5/2011 7:55:15 AM)

I believe that does come into play here. I now have him saving the files to his desktop first or to a server share.
Shouldn't Excel be able to handle previous formats better than this? and work interactivly with other parts of Office? Is there a way to completely reinstall the program, without wiping the drive?
It just seems the end user should not have to do this tap dance of files just to get it to work properly like it did on his "lesser" PC.
I have not tried your suggestion of wiping Excel out of the Registry yet. I'm open to that suggestion, however on a Windows 7 64 bit PC, where do I do that exactly? Where the Wow6432Node comes into play in the registry, I'm not sure which files to remove.

 


Comment by: Jan Karel Pieterse (1/5/2011 8:50:03 AM)

Hi Penny,

I'm not sure this has a relation to the Excel file version, but rather to the fact that the file was an attachment. Of course Excel *should* be able to interact with the other Office apps properly, but sometimes things obviously go haywire.
There used to be an Office removal tool to completely remove Office from a system, but I could not find one for the current versions.
I doubt if wiping the Excel registry keys will help at all here, I think this is something caused by the particular Office/Windows/Networking/Exchange/[maybe something else] setup you have.

 


Comment by: Mike Barton (1/8/2011 5:17:56 AM)

Until recently, when I closed Excel 2007 at night at full screen (manually set) it would open the next morning immediately to full screen, again manually set, i.e. so that I could drag it immediately, if so desired, across to another of my four screens.

Currently, when I klick on the shortcut to open, the window appears in mini-form, i.e. about 12 x 8 cm, which necessitates setting it manually each time to full screen.

I've just checked Properties of the shortcuts for two or three Excel worksheets and they are all set to Normal. When I changed the Run setting in the tab Shortcut to Minimised, the worksheet opened correctly to full screen and was draggable.

Any suggestions as to why my original problem should have occurred: there have been no changes to my setup procedure or PC for ages.

Regards,
Mike

 


Comment by: Jan Karel Pieterse (1/9/2011 10:23:18 PM)

Hi Mike,

NOrmally, Excel should remember it's window settings, unless it has crashed. Maybe an addin is giving trouble?

 


Comment by: Jim (3/23/2011 9:56:28 AM)

Hi,

I'm having problems loading files directly in excel 2010.
I can only load files through File>Open but when loading directly the ribbon seems to be completely disabled & I have to force excel to close.

This issue happens on all files on the network as well as locally.

I've ran through all the above steps and nothing seems to be resolving the problem.

This is only occuring in excel; word etc are all working as normal.

 


Comment by: Jan Karel Pieterse (3/23/2011 10:21:25 AM)

Hi Jim,

Just checking: did you try running Office setup and doing a detect and repair too?

 


Comment by: Jim (3/24/2011 8:47:35 AM)

We don't have the office 2010 CD - would it be possible to use the serial key with a Office 2010 pro trial download?

Would a trial version allow for a repair?

 


Comment by: Jim (3/24/2011 10:17:13 AM)

Issue has been resolved - copied over msonpmon.dll to the system32 folder which has resolved the issue.

Best wishes,
Jim

 


Comment by: Peter (3/29/2011 8:42:16 AM)

Getting System error &80004005 (-2147467259), Click on OK then get "Out of memory"
We use Business Analyser as an addin launching from Microsoft Excel.

Any clues anyone please

Thanks

 


Comment by: Wes (4/7/2011 2:03:27 PM)

MS Office Pro Plus 2010 - Excel intermittently freezes upon save or save as. Just spins and enters not responding state. Unable to save latest changes, only option is to quit.

 


Comment by: Tony Last (4/12/2011 5:47:10 AM)

Excel 2010 does NOT permit opening of a file and then saving of file as a different file name. Program locks up. The initial file name opened has [compatibility mode] displayed behind the file name on the top of the screen. After clicking "Save As" program locks up and displays [compatibility mode](Not Responding) behind the file name. Help?

 


Comment by: Jan Karel Pieterse (4/13/2011 12:40:55 AM)

Hi Tony,

Does Excel lock up immediately after clicking the save-as button on the ribbon, or after you have entered the new filename and clicked the save button on the save-as dialog?

 


Comment by: Wes (4/13/2011 7:45:20 AM)

Hi Jan
In my case, the lock up is immediate. But as I mentioned, it is random and has happened on new files I've created with "save" as well as existing files with "save as".

 


Comment by: Jan Karel Pieterse (4/13/2011 9:32:11 AM)

Hi Wes,

Is the file from a network location? If so, try if moving it to a local drive resolves the issue. In that case you have a networking problem.

 


Comment by: Wes (4/13/2011 10:33:26 AM)

No network involved, Jan. All on the local hard drive.

 


Comment by: Jan Karel Pieterse (4/14/2011 1:44:23 AM)

Sounds like a corrupt file to me. Have you still got Excel 2003 somewhere? If so, try roundtripping through HTML as I describe on this page:

www.jkp-ads.com/articles/corruptfiles.asp

 


Comment by: Tony Last (4/14/2011 2:06:47 AM)

Hi Jan once you click on the save button happens on random documnets at random times


Regards

 


Comment by: Jan Karel Pieterse (4/14/2011 2:36:29 AM)

Hi Tony,

Hmmm, Maybe a problem with Office then. Try running a repair from Office setup.

 


Comment by: Rob Amos (4/20/2011 3:09:15 PM)

Hi,

I used to run Excel 2007 on XP Pro and NEVER had a problem - the most stable programme ever.

I recently upgraded my laptop and now run 7 Pro. About 50% of the time, Excel locks up for no apparent reason. Nothing responds and the only solution is to close down, save on exit and re-open. This happens with both 2007 and compatibility mode files. It sometimes locks up on opening, but often after I've done some normal work. The files are generally quite simple data lists with no macros.

Can you offer any advice?

Thanks Rob

 


Comment by: Jan Karel Pieterse (4/20/2011 9:48:15 PM)

Hi Rob,

Since this started to happen after changing operating system all I can think of is some other cause than Excel.
Maybe using a different printer driver or changing the display driver might help?

 


Comment by: Bhanu (5/12/2011 1:10:03 AM)

We are using VB excel macros in one of our tools, recently in my laptop during security updates MS excel 2007- kb2464583 patch got installed. After this pathc got instaled i have problem in opening my excel application. If i uninstall the patch everything looking good. But i want resolution to fix the issue when the patch is installed.

 


Comment by: Jan Karel Pieterse (5/12/2011 2:08:26 AM)

Hi Bhanu,

I suggest you to contact Microsoft Product support about this, calls regarding problems caused by updates should be for free.

 


Comment by: Dejan (5/22/2011 12:35:39 AM)

My excel 2007 file (3-4 Mb with lots of formula and graphs) encounters a serious problem when trying to save (I have Vista OS installed). Namely, I constantly get a message that MS office excel has stopping working and consequently I lose all previous work. Please advice.

 


Comment by: Jan Karel Pieterse (5/22/2011 9:54:38 PM)

Hi Dejan,

Try creating a new workbook with the same worksheets as your original. After that, copy and paste all cells into your new workbook sheet-by-sheet. When done, you probably have a link to your old file. Save the new file and redirect the link to the newly saved file.

 


Comment by: Scott (8/10/2011 6:49:16 AM)

OK,

I've been through a lot of these fixes, made some progress, but not out of the woods yet.

Generally (but not always) Excel will start up, but not come up fully (sometimes it doesn't come up at all). It doesn't actually freeze but the cross cursor shows up everywhere and none of the fucntions or pull downs will activate.

When I repaired Office with the CD, it would work in safe mode (it did not work in safe mode before that). If I delete the registries, it will work the first time I open it, and seems to work as long as I want, but if I close it it will not work again.

Renaming the .xlb file didn't help. It won't allow me to erase the temp directory.

I could limp along deleting the registries everytime, but I'd love a permanent fix.

My problems seem to coincide with either, uninstalling Bitdefender (with their uninstall program) or installing Avast, or possibly both. When I went back to a restore point immediatelt before these two events, Excel worked fine, but I had other problems associated with programs looking for Bitdefender.

Any help would be appreciated.

 


Comment by: Jan Karel Pieterse (8/22/2011 2:43:47 AM)

Hi Scott,

I would suggest to contect the bitdefender and Avast people, see if they can help.

 


Comment by: v.venkatesh (8/24/2011 8:13:45 AM)

In Excel Personal.xlsb missing.I have checked in disabled item list. i could not find in Add-ins disabled itme list.

how to solve this problem.Kindly suggest

Thanks and Regards,

V.venkatesh

 


Comment by: Jan Karel Pieterse (8/25/2011 5:31:58 AM)

Hi,

Have you used Windows Find to find your personal.xlsb?
Make sure it looks in hidden folders and looks for hidden files.
If it does not find it, I'm afraid you are out of luck.
On the other hand, if you have never recorded a macro to your personal macro workbook, then there will be no personal.xlsb. SO record a macro, set it to "Personal macro workbook", do some things and stop recording. Now close Excel and click Yes to save changes to the personal macro workbook.

 


Comment by: V.VENKATESH (8/25/2011 5:53:03 AM)

Sir,

     Macros are missing,i coild not find macros in excel in Add-ins Diabled item list also i have checked there are no diabled items. In view menu Unhide window also greyed and inactive and personal.xlsb is missing. Kindly suggest how to rectify this problem.

Thanks & Regards,

V.Venkatesh.

 


Comment by: Jan Karel Pieterse (8/26/2011 5:14:02 AM)

Can you find the personal.xlsb in Windows Explorer?

 


Comment by: V.VENKATESH (8/26/2011 5:27:07 AM)

Sir,

    I Could not find personal.xlsb in windows explorer

Regards,

V.Venkatesh

 


Comment by: Jan Karel Pieterse (8/26/2011 9:47:47 AM)

Hi Venkatesh,

In that case, it looks like it has been deleted from your system. On my computer, personal.xlsb is located in:

C:\Users\JKP\AppData\Roaming\Microsoft\Excel\XLSTART

 


Comment by: E NOPPE (8/27/2011 4:27:11 AM)

dear Sir/Madam :)

since yesterday, when i select the icon to start word, powerpoint or excel, excel is started with a screen with message re macro to be run/ignore/more details...and regardless what I choose, it just doesn't do anything further...
i treid to repair from within excel, or outlook...but nothing happens? outlook still works. could it be space problem? I have approx 10% space on each of the C: and D: drive free?
windows xp; MS office 2003(think?) -my notebook at office-this email from home pc.

Regards
ENoppe

 


Comment by: Scott (8/28/2011 12:47:22 PM)

Update on my problem.

Word has startup instability issues similar to Excel.

I've found that I can get both programs to run fine if I delete all of the registry values in the folders:

HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\Excel

HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\Word

respectively. Then start the program(s). Windows loads a bunch of stuff to restore the missing registry values upon startup.

Then the programs will do whatever I want during a single session. If I close the program, it will not start up correctly again until the newly created registry values are deleted.

I'm limping along like this, but would welcome any insight into a permanent fix.

Thanks.

 


Comment by: Jan Karel Pieterse (8/29/2011 1:30:02 AM)

Hi Scott,

Do you have the proper rights to the relevant section of the registry? Right-click this registry entry and select Permissions:

HKEY_CURRENT_USER\Software\Microsoft\Office

Select your username in the list. You should have the options "Full control" and "Read" checked.

 


Comment by: Jan Karel Pieterse (8/29/2011 1:31:42 AM)

Hi ENoppe,

Am I right in understanding that even if you double-click Word, Excel starts?

If so, I'd suggest to reinstall Office.

 


Comment by: Harry (8/30/2011 8:49:00 PM)

in word when i use the insert > chart this function it will open a excel, but this excel haven't load any addin. Is there any way to fix it?

 


Comment by: Jan Karel Pieterse (9/2/2011 3:06:02 AM)

Hi Harry,

I don't think you can change this behaviour unfortunately!
What happens if you FIRST open Excel?

 


Comment by: Dutch (9/8/2011 2:47:41 AM)

I once ran into this problem myself, couldn't start Excel without crashing. After repair, it would run only once and after that it failed again consistently.

Repaired many times, re-installed, crosschecked the Registry, all without success.

I presumed it had to do with some corrupted file or setting and was finally able to solve the problem after I deleted a bunch of files from my hardrive, specifically those whose extension started with 'X' and were located in temporary folders and in folders usually addressed by Excel during boot (XLSTART, AddIns, etc.).

Hope this helps.

Dutch

 


Comment by: Mike Blake (9/27/2011 8:04:25 AM)

Cannot open Excel file on network if it contains a link to another Excel file on the same network. Using Office 2007 with Windows 7.
Error is "Microsoft Office Excel has stopped working." Then excel shuts down.
If I delete the user profile, and then add the user back, the File will open. But, after a while, the same error comes back. I have done an Office 2007 repair, and I have uninstalled and reinstalled Office. Other users on the same laptop can open the file.

 


Comment by: Jan Karel Pieterse (9/27/2011 8:25:55 AM)

Hi Mike,

Hmm, odd. Doesn't really sound like an Excel problem per se though.
If you remove the user profile, does that guarantee a fresh start for Office on that system (if Excel opens with all customisations gone and prompts for a username that is usually the case)?

 


Comment by: Mike Blake (9/27/2011 9:01:20 AM)

I'm not sure if the customizations are gone. Also, I was able to open the file with Open Office, even though excel would crash trying to open it. Currently, I am trying to duplicate the problem as the affected user. I used system restore to restore it to a point I knew it was working, instead of removing user profile.

 


Comment by: jackie (9/27/2011 12:19:37 PM)

We recently installed a new computer at work. The user of the new computer is having problems with the shared excel file. He can save a few times and then it kicks him off. The same user can log into another computer and have no problems with the shared excel file and no one else in the office is having problems.

 


Comment by: Jan Karel Pieterse (9/28/2011 12:02:29 AM)

Hi Mike,

Sounds like the workbook in question has a problem of some sort.
Shared workbooks are a risk, Excel is not the proper application if you want multi-users editing of data.

Jackie: Same message to you I'm afraid: sharing Excel files is not advised, you are risking corruption, loss of data and wrong information in your file. Don't!

 


Comment by: Mike Blake (9/30/2011 12:05:51 PM)

Hi Jan

It looks like the Excel problem I had was not an Excel problem, but an incompatible printer driver for a network printer. I upgraded the print driver for Windows 7, and it seems to have eliminated the problem.

Thanks for your help.

 


Comment by: Jan Karel Pieterse (10/2/2011 11:45:12 PM)

Hi Mike,

Glad you were able to sort out your problem. I appreciate that you took the trouble of letting me know what the culprit was!

 


Comment by: Anthony Green (10/14/2011 5:21:34 AM)

Hi there Jan, the problem I'm having is a bit different, it doesn't look to be a startup issue or a corrupt file issue. Whenever I open an excel workbook on the network that has macros in it, if I try to do an "Edit - Move or Copy" excel gives me a visual basic error that states that C:\DOCUME~1\UserNa~\LOCALS~1\Temp\VB**.tmp could not be found which makes the move or copy fail. You haven't happened to have run across this have you? We've tried clearing out %temp%, running detect and repair and finally reinstalling office 2003 altogether

OS: Windows XP Pro SP3
Program: Microsoft Excel 2003
Condition Needed: Network file containing macros.

 


Comment by: Jan Karel Pieterse (10/14/2011 7:54:31 AM)

Hi Anthony,

I expect this may be related to an addin or a (hidden) workbook with macro's. Try the options in this section:

http://www.jkp-ads.com/Articles/StartupProblems.asp#Startup

 


Comment by: Anthony Green (10/14/2011 10:32:05 AM)

I just ran "C:\Program Files\Microsoft Office\OFFICE11\excel.exe" /Automation and had the same issues with being able to move/copy worksheets in workbooks on the network that have macros.

 


Comment by: PRAVIN OSWAL (10/21/2011 3:01:41 AM)

Dear sir/madam,
Due to my hard disk failure & after recovery of hard disk data i found some of the excel files doesnt opens & shows error mgs that " {Excel Cannot open the file 'Xyz.xlsx' because the file format or file extension is not valid. verify that the file has not been corrupted and that the file extension matches the format of the file) ". We tried to open and repair the file given in the option in excel even after that file could not be repair and also we couldnt extract the data. So please inform the advance method to recover the file or data.
Thanking you,
Yours faithfully,
Mr.pravin Oswal.

 


Comment by: Jan Karel Pieterse (10/21/2011 3:07:58 AM)

Hi Pravin,

I'm afraid the suggestions on this page are all I have to offer!

 


Comment by: Michele Fullilove (10/31/2011 1:30:12 PM)

I am using Windows Vista and continuously have a problem with Excel not wanting to save a file and it's usually when I have been working within 2 - 3 worksheets in a file or I get an error message stating that MS Excel has stopped working. Has this problem occured with anyone else and if so what is the fix.

 


Comment by: Nirazan (11/22/2011 12:43:12 AM)

I'm receiving error message after i close my excel 2007 file...the same file wont show up error if i put it on my laptop and close it after working on it..the error message only occurs in my desktop..

The error message shows up like:
"Microsoft Office Excel has encountered a problem and needs to close. We are sorry for the inconvenience".
The box Recover my work and restart Microsoft Office Excel is checked.

 


Comment by: Jan Karel Pieterse (11/22/2011 2:49:28 AM)

Hi Nirazan,

First thing I'd suggest to check is whether both machines have the exact same Excel version: Office button, Excel options, Resources tab, button "About Microsoft Office Excel 2007".

 


Comment by: Nirazan (11/24/2011 12:46:36 AM)

ya i checked the Excel version on both machines and i came to find that they've got same version of excel 2007 installed...
I'm only facing this problem with my all excel files in my desktop..but those files donot seem to have any problems i my laptop..dont know what went wrong..it's really driving me crazy..

And ya i did google and came with an option that a DLL file name "xllex.dll" might have been missing so i was suggested to download that particular file and install or say save it on C:/windows/system32 folder..

Do you have any idea about that?? What do you say??


thanks.

 


Comment by: Jan Karel Pieterse (11/24/2011 1:26:46 AM)

Instead of just downloading and installing individual dll's (which you risk being the wrong version), try running Office setup first and have it do a repair of your Office installation.

 


Comment by: Ashok Joglekar (12/3/2011 6:27:14 AM)

I am unable to insert charts in any of MSOffice 2007 programs.
In xcel, nothing happens. In Word, I get error "some chart types cannot be combined with other chart types".

I have tried the above solutions but none have worked. I am unable to resolve it. I have searched various forums on the subject but am still stuck

 


Comment by: Jan Karel Pieterse (12/5/2011 1:30:09 AM)

Hi Ashok,

Maybe your custom chart gallery file is corrupt.

Try of there is a file called something like:
Xlusrgal.xls (or .xlsx) on your system and move it to a different location so Excel cannot find it.

 


Comment by: Jim Cone (12/9/2011 6:14:08 PM)


JKP,
Timely tip... XL2003 starting crashing today (12/09/2011) when choosing the "Custom Type" tab in the Chart Type dialog box. Doing a repair did not help. Replaced the XL8GALRY.XLS file with its xl97 counterpart (same name) and all is right with the world.
Thanks,
Jim Cone
Portland, Oregon USA

 


Comment by: Hugh McCulloch (12/13/2011 7:09:56 AM)

After loading SP3 on Office 2007, whenever I try to open a file by double clicking (word or Excel) it opens the application twice. Once with nothing in it, them the second time pops the message that it is open by another user. If I close them both down and do it again it opens fine. Thoughts?

 


Comment by: Jan Karel Pieterse (12/13/2011 11:21:33 PM)

Hi Hugh,

Have you tried the suggestions listed here:

http://www.jkp-ads.com/Articles/StartupProblems.asp#OpenFiles

 


Comment by: Muhammad Asif (12/14/2011 3:16:03 AM)

When i install Ms-Office 2007, during the installation show new window @ Browser for Folder. How can i Install MS-Office?

 


Comment by: Hugh McCulloch (12/14/2011 7:57:49 AM)

Thanks Jan. I tried several of the suggestions in the article, but to no avail. I have also run the Office 2007 diagnostic tool. If I click on the Excel or Word shortcut on the desktop, everything opens correctly. If I double click a document or spreadsheet file Excel (or Word) opens twice, the first copy is blank, the second has the correct file. The error message that the file is locked by another user seems to have gone away though.

 


Comment by: Jan Karel Pieterse (12/14/2011 8:02:06 AM)

Hi Hugh,

Odd. Is this a network file or a file on a local drive?
Is Office run from the client or do you have some other setup?

 


Comment by: Jan Karel Pieterse (12/14/2011 8:03:14 AM)

Hi Muhammad,

I'm not sure I understand the problem, can you try to explain a little bit more please?

 


Comment by: Hugh McCulloch (12/14/2011 8:10:54 AM)

Hi Jan,

Yes very odd. The location of the file doesn't matter. Same result regardless of location - local or network. Office is being run locally on the laptop.

 


Comment by: Jan Karel Pieterse (12/14/2011 8:23:05 AM)

Hi Hugh,

What happens when you uncheck all add-ins?

 


Comment by: Tusarkanta (12/15/2011 11:18:00 PM)

when i am opening excel file,but automatically opened temporary excel file..

 


Comment by: Jan Karel Pieterse (12/16/2011 3:47:14 AM)

Hi Tusarkanta,

Look in Excel's File, Options, advanced tab, general section. See if there is anything entered in "At startup, open all files in...". (in Excel 2003 and earlier: Tools, Options, general tab)

 


Comment by: Matt M (12/20/2011 4:42:26 PM)

When I run VBA processes my Oulook 2010 freezes until it's finished running. My CPU usage is very low and I can use other programs just not Outlook. Any ideas of what I can do? I appreciate any help.

 


Comment by: Jan Karel Pieterse (12/20/2011 10:21:16 PM)

Hi Matt,

I've never heard of that one before. I googled and found some hits, albeit not quite the same as yours:

http://www.google.com/search?&q=vba+outlook+freezes

 


Comment by: Rose Hurley (12/22/2011 9:49:33 AM)

When Iopen Excel I get a compile error. When I remove the addin Excel opens up ok, but when I open up Pro systems Engagement it adds the addin EPace. Then if I open up Excel I get a compile error "Compile error in hidden module: mdlWorkbook". If I click ok it goes away and we can proceed. Is there anything I can do to stop getting the error? Any suggestions appreciated.

 


Comment by: Jan Karel Pieterse (12/22/2011 10:39:01 AM)

Hi Rose,

I would get hold of the people who created that Pro systems engagement addin and tell them about this error:

http://support.cch.com/productsupport/productsupport.aspx?path=%2fTopics%2fproduct_support%2fpfx_office%2fpfx_engagement

 


Comment by: Rus (12/28/2011 8:22:41 AM)

I have office2010, I can open, modify and print an excel spreadsheet fine but when I go to close excel I get a crash report ever time...any thoughts?

 


Comment by: Jan Karel Pieterse (12/29/2011 7:10:19 AM)

Hi Rus,

I would try the same things as mentioned in this article, especially the section on startup errors, as often closing errors can be caused by the same problems:

http://www.jkp-ads.com/articles/startupproblems.asp#Startup

 


Comment by: Rob Blaschko (1/5/2012 1:30:27 PM)

I have XL 2010. I want to open XL every time to a default location i.e. c:\files. I don't want most recent or anything like that. Open to the same place every time. Thanks!

 


Comment by: kailas (1/6/2012 11:50:31 PM)

how to convert microsoft word table to excel table by c porgram

 


Comment by: Jan Karel Pieterse (1/9/2012 1:04:28 AM)

Hi Rob,

Select File, Options and enter that path for the default file location. Please note that if you open a file from another location (or save a file to another location) this will automatically become the folder Excel will take you to next time you select File, Open or save-as.

 


Comment by: Jan Karel Pieterse (1/9/2012 1:05:04 AM)

Hi Kailas,

I'm sorry to say I do not know, I know nothing about C.

 


Comment by: micheal (2/1/2012 10:20:22 AM)

i have file corrupt but there is a password how can i open it?

 


Comment by: Jan Karel Pieterse (2/1/2012 10:42:24 PM)

Hi Michael,

Depends. What happens if you try any of the methods listed here:

http://www.jkp-ads.com/articles/corruptfiles.asp

 


Comment by: Athena (2/16/2012 12:35:00 AM)

Hi Jan, I sure do hope you can help. I have 2003 Excel, pc with 8 gb RAM on Vista, and 2 workbooks, 1 is 35 mb & the other is 20, both linking and using data from each other. It has been non stop crashing and shutting down my pc. It is random when it happens, not on start up all the time or when saving. I have tried all of the above suggestions. There isn't really a registry for Excel, which I find odd, I can't locate my tool bar in the normal places, but after restarting in normal mode after trying safe, the tool bar defaulted back.
I am using a lot of formats and formulas/functions and a few macros. But since the crashing started, I haven't added any new ones. I am rather concerned with the constant shut down of the pc. I have ran multiple tests on it, and it seems to fine and does not happen until I start using Excel. I hope this was enough info about my problem. Thanking you in advance.

 


Comment by: Jan Karel Pieterse (2/17/2012 7:31:48 AM)

Hi Athena,

Does the crashing happen on running macro's, or on any other specific event(s)?

What happens if you move both workbooks to a different location, preferably an entirely different drive?

 


Comment by: Athena (2/20/2012 7:55:45 PM)

Hi Jan - thank you for responding. No, it doesn't happen on any specific event or when running macros. Sometimes it will be when saving and sometimes when calculating, and occasionally when I just look at it the wrong way, lol. But, I have always had it on manual calculation, for time reasons. I did find the registry and tried the above suggestion, and no luck. I went a step further, to eliminate possible mb overheating and installed CPU Thermometer, and that's not causing the shutdown either. I tried running them from a flash drive, same problem. I didn't think the workbooks were very large at all, especially for my system, they only use about 2% of the processor, even during calculating. I'm at a loss. I'm not sure how these get "corrupted", maybe way too many array formulas?

 


Comment by: Jan Karel Pieterse (2/20/2012 10:52:26 PM)

Hi Athena,

In that case I suspect some kind of corruption in your file(s).

See:
http://www.jkp-ads.com/articles/corruptfiles.asp

 


Comment by: Athena (2/22/2012 9:32:52 PM)

Hi Jan - Sounds like a plan. One question for you though, if I am able to open them, am I just copying existing information into a new file name and workbook? I keep reading about rebuilding a workbook but not too sure what that means, in general. I'm just afraid that whatever the problem is will just get transferred into a new workbook. Or, if possible, could you explain what is meant by a corrupted file in Excel? I know it sounds like a silly question, but I'm just trying to understand what happens to these files and how to avoid future corruption.

 


Comment by: Jan Karel Pieterse (2/23/2012 3:00:40 AM)

Hi Athena,

I'd start with simply copying all worksheets to a new file. That sometimes suffices. If it does not, create a new workbook with the same worksheet tab names and then copy/paste all formulas and values to the new sheets. If that works, create a copy and copy/paste formatting to the new sheets. Etcetera...

 


Comment by: Britt Goudey (3/11/2012 3:15:42 PM)

Hello,

I just surfed in here while looking for a fix to this problem - was wondering if you could help or advise?

In Excel 2007, with Vista Business, when I select PAGE LAYOUT, Comodo Anivirus gives me the following Alert: "Excel tried to execute a shellcode as a result of a possible buffer overflow attack." "This is typical of a buffer overflow attack. COMODO Defense+ has already isolated EXCEL.EXE from the rest of the system and will keep it isolated unless you skip this alert. However, it is still strongly recommended to terminate this application and contact its vendor for a fix."

Yes, everything is up to date. I recently downloaded an excel spreadsheet from the internet. But, I haven't been using Excel 2007 long enough to know if this problem is new, or associated with the recently downloaded spreadsheet. I have scanned the spreadsheet with Comodo and nothing came up.

Thanks for whatever you can input.

 


Comment by: Jan Karel Pieterse (3/12/2012 12:57:52 AM)

Hi Britt,

I suspect your Excel.exe file may be infected with a virus. I suggest that you have your virus scanner scan and fix your entire system. AFter that, run Office setup so it can reinstall the removed items of Excel.

 


Comment by: Anand (3/19/2012 10:35:43 PM)

hi,

i am using laptop of dell latitude D531,and operating system is XP. when i am using excel the same take a lot of time to open the excel. please suggest what i have to do.

 


Comment by: Jan Karel Pieterse (3/19/2012 11:38:10 PM)

Hi Anand,

I would start with the part on starting Excel in safe mode. If that helps, try the other options listed on this page.

 


Comment by: John Mason (3/24/2012 5:08:03 PM)

I had the same issue and followed the steps above; none worked, even though I went as far as deleting the Excel part of the registry. After closing all Office applications and deleting the temp files, it's now functioning as it should again.

Very weird.

 


Comment by: Jessica (4/12/2012 7:45:50 PM)

I have successfully registered a COM Add in at hkey_local_machine\software\Microsoft\office\excel\Addins. Howver, when i followed the following steps:

1.Click the Office button/File tab and select Excel Options.
2.Click the Add-ins tab
3.In the dropdown near the bottom, select "COM Add-ins" and click Go.

My COM Add-ins is not shown in the "Add-Ins Available" list. What should i do to make it appear in the list ?

I am using Excel 2010.

 


Comment by: Jan Karel Pieterse (4/13/2012 2:16:15 AM)

Hi Jessica,

I'm not sure what is going on here, COM addins I activate that way do show up in my list. Perhaps it has something to do with the loadbehaviour setting? Mine is set to 3 (load at startup)

 


Comment by: Jessica (4/16/2012 3:49:34 AM)

mine loadbehaviour setting is set to 3 too. The Com addin just doesn't appear in the "Add-Ins" List. But i am able to use the function in VBA, but not on worksheet.

 


Comment by: Jan Karel Pieterse (4/17/2012 3:11:15 AM)

Hi Jessica,

Have you tried unregistering and subsequently registering the dll (make sure no instances of Excel are open when you do so)?

 


Comment by: Dutch (4/17/2012 3:12:46 AM)

Could be related to this issue: http://wp.me/pe53Z-6d

 


Comment by: Pamela (5/24/2012 11:22:37 AM)

Both excel and word 2010 open what can only be expressed as "phantom files". Clicking on almost any item in the Ribbon will cause excel and word to open 2 or 3 files (but they are not really files, just showing in the task bar at the bottom. I can be working in word and realize there are 62 files listed as open. Clicking on one of the "files" will cause many of the files to disappear but always there will be 3 to one real file in both office and excel.

Also I cannot maximize the screen in either program. I did find a way to maximize the screen once, but then I could not minimize it.    Any ideas????

 


Comment by: Jan Karel Pieterse (5/25/2012 2:00:39 AM)

Hi Pamela,

Odd problem indeed. THis doesn't sound like something in your settings is wrong.
I would start by removing Office and installing it again, see if that helps.

 


Comment by: Dewald Viljoen (6/7/2012 5:04:17 PM)

Thank you for the help, really saved my life...:-)

 


Comment by: Mike (9/26/2012 8:30:05 AM)

Hey there, i'm confronting somewhat a strange problem, when excel 2007 starts it automatically says "excel has stopped working", i tried all of the above+repair and a complete reinstal of the whole office package but still says that. Any other ideas i could try?

thanks

 


Comment by: Jan Karel Pieterse (9/26/2012 7:19:27 PM)

Hi Mike,

Just asking the obvious...

You also tried the xlb file and disabling all add-ins and checking the xlstart folder and the startup folder?

 


Comment by: Teresa (12/4/2012 4:21:43 PM)

I cannot open excel or any saved excel files. When trying to do so a window opens saying "preparing to install, please wait while windows configures Microsoft Office 2000. OK. Then another window entitled Microsoft Office 200 SR-1 Premium, saying the feature you are trying to use is on a CD ROM or other removable disk that is not available. Insert the MSO 2000SR-1 Premium disk & click OK. I do not have this disk (neither was I aware I am running MSO 2000 SR-1 on my PC, I am running Windows XP. All these messages finally culminate with an Error 1706 No valid source could be found for product MicS Office 2000 SR-1 Premium. The windows installer cannot continue. Please can you help it is driving me mad ..... Thanks in anticipation.

 


Comment by: Jan Karel Pieterse (12/4/2012 4:43:30 PM)

Hi Teresa,

Looks like something wrecked your Office installation.

If you have no DVD or CD with Office on it, you have just a few options (start with first one!):

- Restore to a previous restore point of windows
- Find a system backup and restore that
- Reset your PC to factory conditions (remember to backup your data!!)

 


Comment by: Andy (12/13/2012 8:22:23 AM)

My "Ignore other application using DDE" turned on by itself now and then despite that i already unchecked it in my default settings.
What could be the cause of it?

Thanks.

 


Comment by: Jan Karel Pieterse (12/13/2012 7:38:06 PM)

Hi Andy,

Nine times out of ten this is due to some add-in or a macro in a file that does not clean up properly after itself.

 


Comment by: Andy (12/14/2012 2:02:07 AM)

Thank you for your reply!

In that case how can i prevent this from happening over and over again?

 


Comment by: Jan Karel Pieterse (12/14/2012 6:17:16 AM)

One thing you can do is check which addins are loaded and what Excel loads when it starts. See:

http://www.jkp-ads.com/articles/startupproblems.asp

for more information.

 


Comment by: Derrick Yu (12/14/2012 5:58:40 PM)

My excel 2003 macro with VBA code has been working fine. now that we move to Office 2010, it get an error "compile error automation error".

But i have no problem running the macro manually in office 2010. I have the problem only when i run the code automatically.

Any ideas,
Thanks,

 


Comment by: Jan Karel Pieterse (12/14/2012 7:40:39 PM)

Hi Derrick,

Perhaps your code is called from the Workbook_Open event?
Try calling the routine by using Application.Ontime.

 


Comment by: Dan Hall (12/19/2012 9:46:45 PM)

I have a excel 2007 vba app that 50 people are running fine. It has ActiveX controls on it, so when the users startup they receive the standard Windows Forms message that "This application contains ActiveX controls..."

All 50 just select the "Ok" button and the app works fine.

2 new users, in the same office, select "Ok" and receive the following "Microsoft Visual Basic" error:
"System error &H80004005 (-2147467259). Unspecfied error."

If they press "Cancel" in the ActiveX warning box, they still receive the error.

I've checked their updates on Excel, Memory, OS updates and cannot figure out why they are receiving this error.

Any ideas, suggestions, solutions appreciated!

 


Comment by: Jan Karel Pieterse (12/20/2012 11:34:56 AM)

Hi Dan,

I can think of two possible causes:

1. They are using 64 bit Excel
2. The activeX control in question isn't installed on their system.

 


Comment by: Dan Rogers (12/21/2012 9:36:38 PM)

I have a Excel 2010 user that when opening a file in full screen view. cannot access any of the menus (either by mouse or by short cut keys). Once the workbook is re-sized then they work fine. Menus can be seen, just nothing happens when trying to select them.
Any Ides why this would be?
Thanks,

 


Comment by: Jan Karel Pieterse (12/24/2012 4:43:03 PM)

Hi Dan,

Sounds as if the workbook is protected?

 


Comment by: sukeyna (1/17/2013 4:44:00 AM)

I have lost my Excel toolbar on Excel 2003, I have tried adding it through the VB editor, however each time I exit excel, the toolbar(FILE, EDIT, VIEW...) disappears again.

Can you provide with a fix, please and thank you

 


Comment by: Jan Karel Pieterse (1/17/2013 7:27:21 AM)

This is something that is likely to be caused by a file opened by Excel during startup. Check out this section

http://www.jkp-ads.com/Articles/StartupProblems.asp#Startup

for how to troubleshoot those issues.

 


Comment by: mike blak (1/31/2013 2:49:32 PM)

Dan, If you have:
"2 new users, in the same office, select "Ok" and receive the following "Microsoft Visual Basic" error:
"System error &H80004005 (-2147467259). Unspecfied error."

and if works for everyone else, check the MSCOMCTL.OCX in C:\Windows\System32 folder. Compare the dates of this file on the computers that are receiving the error with the file on a working pc. If they are different, copy the version from the working pc to the pc receiving the error. Then, you may need to re-register the ocx file:
at the command prompt:
change to C:\Windows\system32 directory and type each line separately, followed by enter. This will unregister and regisgter the mscomctl.ocx active x control

REGSVR32 MSCOMCTL.OCX /U

REGSVR32 MSCOMCTL.OCX

 


Comment by: Cameron (2/10/2013 10:41:28 AM)

Wow! I could not even guess about it)) Not bad.

 


Comment by: Mike (3/5/2013 4:16:56 PM)

Hi,
I face a serious problem with my new "Excel 2013".
I use a PERSONAL.XLS(m) file since 2003 version which caused no problem even in "2010".
If it resides in the XLSTART folder – Excel hangs/freezes after typing a simple number and pressing Enter.

The PERSONAL file has 10 macros which I need in my day to day use.

When I move the file to another drive(!)/DOK Excel works smooth as expected.

Is there any solution for my problem.

Any help will be appreciated.

Thanks, Mike

 


Comment by: Jan Karel Pieterse (3/5/2013 4:40:18 PM)

Hi Mike,

After moving the file, can you open it using Excel 2013?

 


Comment by: Mike (3/5/2013 7:16:07 PM)

Hi, Jan Karel,

Yes - I could.

After moving it from the XLSTART folder I renamed its name (added a few charaters) and saved it in derive D:

I opened it, now, in my "Excel 2013" but immediately after opening it - it got frozen.

By that word I mean that it takes 15-20 for the software to accomplish my moves.

Clicking some cells seconds and/or clicking the Ribbon takes a lot of time to respond.

However, when I press ALT+F11 and run some ot its macros (with F5) they work OK.

*** could not use the Icons which I have in my QAT because I changed the files name & path.

There is one more thing that I noticed with no connection
to the presence of the PERSONAL file:

Hitting CTRL+1 (to pop-up the format dialog, launches an empty border at the size of the expected dialog.
Only after few attempts - it opens as expected.

I must point out that I already ran the repair procedure of the "Office 2013".

Thanks, Mike

 


Comment by: Mike (3/5/2013 7:32:44 PM)

One additional remark:

I'm using the "Office Tabs v. 9.20" add-in since "Excel 2010".

I thought maybe it is causing some problem when it meats the Personal file (although there should be no connection between th two) so I disabled the add-in and immediately after putting the Personal file back to: C:\Users\Mike\AppData\Roaming\Microsoft\Excel\XLSTART\ and launching "Excel" it froze again after typing a few digits into a cell.

Mike

 


Comment by: Mike (3/5/2013 9:03:31 PM)

Well..., sorry to sound nagging but I found "some" solution or should I say a "workaround".

When I start "Excel" (while Personal.xlsm is in the XLSTART folder) and type some value - It hangs/freezes and it takes a long time to be able to choose an Ribbon item.

After being successful to UNHIDE the Personal.xlsm everything moves smooth and quickly.

When I HIDE the Personal.xlsm - Excel continues to behave OK.

Unless a permanent solution can be found - is there a way to put a small event-macro in the Personal.xlsm Thisworbook module to UNHIDE it and then HIDE it again ?
(It is too annoying to do it manually)

It seems as if this can be a temporary solution to my problem.

Thanks, Mike

 


Comment by: Jan Karel Pieterse (3/6/2013 11:36:48 AM)

Hi Mike,

Perhaps saving personal.xlsm after you hid it again solves the problem?

 


Comment by: Mike (3/6/2013 11:57:41 AM)

Hi, again,

Saving didn't help.

I finally deided to use a "workaround" like an Event-Macro in the PERSONALs ThisWorkbook module:

Private Sub Workbook_Open()
Application.ScreenUpdating = False
ThisWorkbook.Activate
ActiveWindow.Visible = True
Application.Wait (Now + TimeValue("0:00:01"))
ActiveWindow.Visible = False
Application.ScreenUpdating = True
End Sub

This prevents Excel from freezing but, as I said, this is only a workaround and should be taken into consideration by Microsoft.

Mike

 


Comment by: Jan Karel Pieterse (3/6/2013 7:35:41 PM)

Hi Mike,

While it is good that you have a workaround, it should not be needed to begin with.

What happens if you move your perosnal workbook again and after that, record a macro (in Excel 2013) to the personal workbook to have it re-created?

 


Comment by: Mike (3/6/2013 7:43:19 PM)

Hi, Jan Karel,

Checked all thus before(!) I posted my problem.

It must be something wrong with the "2013" version as this PERSONAL file works like charm in my other computers running "2010" and "2007".

The macros saved in my PERSONAL file are short & simple.

For example - on of them inserts a comment to a cell and copies the cells formula into the comment shape + formats that Shape.

There were no event macros I could suspect to be ignited and causing the problem.

Now, I have this single event macro and I'm happy.

By the way - do you know if there is a "MoreFunc" add-on compatible with "Excel 2013" ?

Thanks for your efforts,

Mike

 


Comment by: Jan Karel Pieterse (3/7/2013 8:32:57 AM)

Hi Mike,

Of course you tried tht already :-)
I just tried on my system, but I do not have the problem.

 


Comment by: Mike (3/7/2013 9:19:11 AM)

Hi,

What, exactly, did you try ?

Mike

 


Comment by: Jan Karel Pieterse (3/7/2013 11:22:17 AM)

Hi Mike,

I recorded a macro into my personal workbook, closed Excel and saved the pmw. Then opened Excel, checked if the PMW was there (it was) and tried things like editing cells, opening the formatting dialog, etc. Everything just worked as advertised.

However, it is a virtual machine and I have no other Office versions on this machine than 2013.

 


Comment by: Mike (3/7/2013 1:02:52 PM)

OK, understood.

This leaves my question - as per the "MoreFunc" add-on compatible with "Excel 2013" - still unanswered !?

mike

 


Comment by: Jan Karel Pieterse (3/8/2013 1:24:48 PM)

Hi Mike,

I don't know about morefunc. Isn't it working?

 


Comment by: Mike (3/8/2013 3:11:08 PM)

Hi,

Unfortunately - it is not.

Although showing up as a new added group in the Ribbon - none of its function work (they all result as #NAME?)

Mike

 


Comment by: Azmi Aziz (3/14/2013 9:39:02 AM)

I have set options for my new workbook to have only 1 worksheet when creating new file. But when I do right click from deskstop and choose new excel, the settings doesn't work and still give me 3 worksheets. Can help?

 


Comment by: Jan Karel Pieterse (3/15/2013 1:09:31 PM)

Hi Azmi,

I don't think you can change that. There are certain ways of creating a new Excel file that ignore your custom settings. This appears to be one of them.

 


Comment by: rafeek (4/19/2013 2:09:25 PM)

first i unstalled office2003in win7.then installed office2007. but the excel file is not open directly. excel.pip is in recommended program. microsoft excel could not add in recommended program.all excel file see in unknown format

 


Comment by: Jan Karel Pieterse (4/20/2013 9:14:10 PM)

Hi rafeek,

Have you tried the other options on this page already?

 


Comment by: Mayank (5/1/2013 7:51:48 PM)

I have a one user, opens the excel template gets the Automation Error, select "Ok" and receive the following "Microsoft Visual Basic" error:
"System error &H80004005 (-2147467259). Unspecfied error."

The same file works for everyone else,I checked the MSCOMCTL.OCX in C:\Windows\System32 folder. Compare the dates of this file on the computers that are receiving the error with the file on a working pc.Copied the file from working PC and re-register the ocx file:
using the command prompt:
change to C:\Windows\system32 directory and unregister and regisgter the mscomctl.ocx active x control.

But still gets the same error for him. I tried this multiple times using the different(mscomctl.ocx) files, but no luck.

Could any one suggest me what should I try more to fix the issue, what exactly causing the error.

Many Thanks in advance,

 


Comment by: Jan Karel Pieterse (5/1/2013 8:56:03 PM)

Hi Mayank,

That one user isn't by any chance on a 64 bit Office installation, is he/she?

 


Comment by: MAYANk (5/1/2013 9:50:14 PM)

Hi Jan,

Thanks for your reply, Not sure, how to check whether it is 64 bit Office installation or 32 bit.

But I m sure, that PC is 32 bit, coz I re-registered mscomctl.ocx using regsvr32 and it was successful.

 


Comment by: Jan Karel Pieterse (5/2/2013 9:46:29 AM)

Hi Mayank,

the fact that you can use regsvr32 does not mean you have a 64 bit system as far as I know.

If you launch Excel and click File, Help, it will show "About Microsoft Excel" on the right-hand side of the screen, which also shows whether it is 32 or 64 bit Excel.

 


Comment by: Margo Aguinaga (5/31/2013 7:32:11 PM)

I have a blank grey screen where a spreadsheet that I use monthly should appear.
If ask it to print, it appears in the print preview box, or if I change from 'Normal' workbook view to 'Full Screen' all of the data appears, but then I have no tool bars.
I cannot get it to appear as it normally does in any 'view' type.

HELP ! ! !

 


Comment by: Jan Karel Pieterse (5/31/2013 8:16:04 PM)

Hi Margo,

Perhaps it is minimised? View, Arrange, Tiled might help.

 


Comment by: Rand (6/28/2013 7:55:41 PM)

Hello, I just upgraded to 2013 - when I open Excel it goes to the "templates" option page, I'd like it to just automatically open the new a new workbook. Is there a start up option setting or another way to make this happen?

Also, when "save as" is there a way to have it go directly to the explorer view of the last location vs picking a place, then folder then explorer view?

 


Comment by: Jan Karel Pieterse (7/1/2013 7:49:28 AM)

Hi Rand,

In File, Options you can turn off the startup screen (last checkbox on the first tab).

If you add the save as button to your Quick access toolbar, it will show the "normal" browser.

 


Comment by: Tak Ko (7/2/2013 2:13:40 PM)

User is having problem opening Excel file, when opening a blank Excel file, it come up in a couple of seconds, but when opening an existing Excel file, it took from about 45 seconds to 1.5 minute. I copied a couple of the file from the network to the desktop, same issue.
I have tried the following but no help:

I have checked the addins and disabled them
Repaired Office 2010
I deleted all "Recent"
Uninstalled IE 10 and back to IE9
Workaround for Windows 7 and for Windows Server 2008 R2
To work around this issue, disable the Server Message Block (SMB) signing through registry keys. To do this, follow these steps:
· Click Start
type regedit in the Search programs and files box, and then press ENTER.
o On a client computer, locate and then click the following registry entry:
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\services\LanmanWorkstation\Parameters

· Under the registry entry, disable these two registry keys:
o Right-click Enablesecuritysignature, and then click Modify. Type 0 in the Value data box and then click OK.
o Right-click Requiresecuritysignature, and then click Modify. Type 0 in the Value data box and then click OK.
They are already "0"s
The microsoft validation add-in (which can be deleted) is an extreme PITA (Pain in the ass) as well and slow things down.
HKEY_CURRENT_USER\Software\Microsoft\Office\14.0\Excel\Options
Look for DWORD DisableRobustifiedUNC and see if the value is set to 1. If so you can either delete the key or set it to 0. I'd set it to 0 just to check.
It's not there
Running IE10 and Excel 2010 on 64-bit Windows 7 box):
1. Start Internet Explorer 8
2. Go to "Tools" menu
3. Go to "Internet Options"
4. Go to "Security" tab
5. Go to "Local Intranet"
6. Click on "Sites" button
7. Uncheck "Automatically detect intranet network"

I don't know what else I can try and I hope you will have some ideas. Attached are the screen shot of Addins and the Office updates.

Thank you very much in advance for your help.

 


Comment by: Jan Karel Pieterse (7/2/2013 5:29:16 PM)

Hi Tak,

Sometimes, the only way out is removing the userprofile from the machine. You may have to remove the roaming profile too, depending on how profiles are managed in your network.

 


Comment by: Rand (7/2/2013 11:44:11 PM)

Thanks for your help with excel issue above.

How can I change the default location in explorer so it automatically opens to a specific drive vs libraries? Also is it possible to place a folder in the navigation pane?

 


Comment by: Jan Karel Pieterse (7/3/2013 10:54:03 AM)

Hi Rand,

You can set the default folder in the Options settings, under the Save tab.

Not sure what you mean by "Navigation pane". I think you mean the lefthand pane with the libraries and folders?

You can drag a folder from the right-hand side of the dialog up to the Favorites section.

 


Comment by: Jeff Ray (10/30/2013 2:23:00 PM)

Hi,
I appreciate your efforts to show us how to start excel.
I know my addin's are causing a problem in excel. I wanted to start excel and disable them. But I can't start excel. I thought maybe your command :
Click Start, Run,
"C:\Program Files\Microsoft Office\Office\Excel.exe" /Automation

But I run Windows 8 and I don't know how to get to a "Run" command anymore.
How to do this in Windows 8?
Microsoft has done a LOT of stupid things, but taking away the Start button was by far the most stupid.
Thanks,
Jeff

 


Comment by: Jan Karel Pieterse (10/30/2013 4:20:10 PM)

Hi Jeff,

You should be able to start Excel in safe mode by holding down the control key while Excel starts. That also prevents add-ins from loading.

 


Comment by: E2DK (1/14/2014 5:42:02 PM)

EXCEL 2013 Personal.xlsb Does Not Open At Start Up – Followed Advice And Restart

Hi,

My personal.xlsb (2013) did not open at start up. I spent a few hours following all of the advice I could find.
1) Backup personal
2) Delete personal
3) Rerecord macro in personal
     a. Personal appeared
4) Ensure personal is hidden
5) File -> Options -> Add-Ins -> manage: Disabled Items Go
     a. This was empty

None of these worked until I tried some hocus pocus and restarted my computer.

6) Restart
7) Replace the personal with back up and change name of file to personal

Never give up never surrender!
E2DK

 


Comment by: Maxilo (1/27/2014 2:44:43 PM)

Hi, thanks for the tips, however I could not recover my file, only I coudl recover my Excel file with ExcelFIX.

 


Comment by: Satish (2/7/2014 9:04:04 AM)

I have around 30 ms word objects in my excel file split between two sheets. I was working on the sheet after saving, when I re opened it it shows cannot start the source for this object for nearly 26objects rest I am able to open. This file is very important and I want to open all the objects so that I can access the data.

 


Comment by: Jan Karel Pieterse (2/7/2014 7:04:23 PM)

Hi Satish,

If you go to Windows Explorer and right-click on the file and select Properties, does the Previous versions tab perhaps contain previous versions of your file?

 


Comment by: Satish (2/8/2014 4:13:20 PM)

Hi jan,
There is no such option as previous version. I am using windows xp and excel 2003

 


Comment by: Satish (2/9/2014 12:48:25 PM)

Hi jan,
If you want I will mail u the excel file. You can try and see and let me know what can be done. Please help it's very important, I have been working on it for two years can't start all over again

 


Comment by: Gilles (5/25/2014 11:11:57 AM)

Hello,
Just want to say a big THANK YOU for this article.
My Excel 15 (Office 365 familly) was unable to start for a few days.
It was stuck on the splash screen in "starting" status.
No error message, no log in the events viewer.
I unistalled/re-installed Office, cleaned all the add-ins but the pb was still there.
Finally I found this page and after deleting the Excel folder in the registry as you explain, Excel starts normally.
Thanks again.

 


Comment by: Jan Karel Pieterse (5/25/2014 12:38:12 PM)

Hi Gilles,

You're welcome!

 


Comment by: rony009 (6/17/2014 12:24:49 PM)

Hey I had the same issue with my computer. I wasted my time on it for
many days but finally I got a solution from this link
http://www.microsoftliveassist.com/error-messages-when-you-try-to-uninstall-microsoft-office-2013/

 


Comment by: Manoel (10/14/2014 8:14:51 PM)

Thanks for that post, it was so useful.

 


Comment by: CJ (11/7/2014 4:06:34 AM)

I built an Excel VBA code that loops through many folders and sub-folders in our network drive. It then opens the Excel files on those folders, extracts the UPC numbers and copies them to a master sheet where it compiles them all. Some of those Excel files have macros that activate when the file is opened. That created conflicts with my code so I have a disable all macros on my code to prevent that. Also, some of those files are corrupt so I used the Workbooks.Open(CorruptLoad= xlRepairFile) method. That worked fine at first on a small data set. But when I tried it on a large data set (thousands of files) the code slowed to a crawl after 2 hrs. I restarted the computer, disabled all add ins, and still running very slow. To make matters even worse, now any Excel file with formulas or VBA code on it runs very, very slow. I tried uninstall & re-installing Excel and still nothing. What could be the problem?

 


Comment by: Jan Karel Pieterse (11/10/2014 11:37:42 AM)

Hi CJ,

Hard to say. Any add-ins loaded in Excel which might affect this?

 


Comment by: CJ (12/16/2014 4:31:02 AM)

Jan - I used your advise on "Trouble caused by corrupt temporary files" and voila it worked.
Thanks for that post, it was very useful.

 


Comment by: D. Rogers (4/1/2015 10:39:43 PM)

THANK YOU for this article.
My Excel 15 (Office 365 family) was unable to start for four days due to a old .XLA file in the Excel start up folder. Each time I tried to start would get a message "Excel has stop working....". It would work in safe mode. The file had been there for 6 months, but had given no problems.

I unistalled/re-installed Office, cleaned all the add-ins, deleted & added printers, download new drivers, and a whole host of other things, but the problem wasn't fixed. Talked to MS Support for 30 minutes to no avail. They finally wanted to sell a $199 service plan to continue conversation. Finally I found this page and after deleting the Excel folder in the registry as you explain, Excel starts normally.
Thanks again.

 


Comment by: Gurpreet Singh (10/1/2015 7:42:26 AM)

i have an excel file created in 2003 version of size about 25 Mb. It contains some macro code which were worked very well . But one day i tried to open it following error message was there

" Unable to Read the file"

Kindly help for its opening

 


Comment by: Jan Karel Pieterse (10/1/2015 11:17:12 AM)

Hi Gurpreet,

It looks like your file has become corrupt. Perhaps this page helps you find a solution:

www.jkp-ads.com/articles/corruptfiles.asp

 


Comment by: Edwad Rodman (12/19/2015 9:44:07 PM)

When using Excel 2013, VBA (Visual Basic) I lose the Visual Basic toolbar and am unable to select a reference. Its difficult to debug, and unable to use the watches.
I have no menu at all. This is happening with my Windows 10 Sufaces. I have a surface Pro 1 and it comes and goes, while my Surace 3, I cant get that menu to appear at all. HELP please.

 


Comment by: Jan Karel Pieterse (12/20/2015 3:21:18 PM)

Hi Edwad,

If you right-click just below the title bar of the window, do you get a short-cut menu listing the toolbars (Debug, Edit, Standard, Userform)?

The VBE settings are in the registry in this key:

HKEY_CURRENT_USER\Software\Microsoft\VBA\7.0\Common

In there you might consider exporting the key called UI and subsequently delete it (the VBE will recreate it).

 


Comment by: Debbie (1/21/2016 8:49:33 PM)

Question; Excel 2007 just began to have this problem... when selecting cells in an exiting workbook to copy and paste. the copy and paste features are grayed out (on right click menu). you can use ctrl c and v but not the menu commands. this is on a laptop if you access the file from another computer there is not the same problem, when I log onto the same laptop with my admin sign on, I see the copy and paste commands on the menu.
Help!

 


Comment by: Jan Karel Pieterse (1/22/2016 2:32:54 PM)

Hi Debby,

I would suspect an add-in to cause this perhaps. Try loading Excel in safe mode (see article how to do that). If the commands return, I bet there is an add-in that does this. There are also instructions to disable add-ins above.

 


Comment by: Steve Wright (2/25/2016 9:03:43 PM)

I've been tearing my hair out for a couple of days with an Excel start-up problem and getting nowhere fast. Just followed the relevant bits of your tips above and voila - within 10 minutes Excel is back to normal and I can at last get some work done. Many, many thanks for the help.

 


Comment by: Jan Karel Pieterse (2/26/2016 2:25:17 PM)

Hi Steve,

I'm very pleased to hear the information here helped you fix your problem, thanks!

 


Comment by: Satheeshchandrababu.G (5/10/2016 4:24:24 PM)

I was open the excel file. open ththe program but it will not open the pages.the massage was seen that there was a problem sending the command the program

 


Comment by: Jan Karel Pieterse (5/11/2016 3:56:11 PM)

Hi Satheeshchandrababu,

Probably you would benefit from repairing your Office installation (go to Control Panel, Software and find Office and click setup)

 


Comment by: Paul Harsley (7/26/2016 8:07:07 AM)

This doesn't apply or solve the issue with Excel 2016 and Windows 10. Any ideas?

 


Comment by: Jan Karel Pieterse (7/30/2016 9:39:53 AM)

Hi Paul,

Which issue?

 


Comment by: MARCO MESQUITA (1/17/2017 5:11:19 PM)


Hello,

Ive got a user using Office plus 2016, and the Ribbon (toolbar), sometimes the Icons are active, but not visible. All toolbar are in grey.

Does anyone faced a problem like that??


regards

Marco Mesquita

 


Comment by: Sardor (4/19/2017 9:04:55 PM)

Hello.

When I open excel file I get message "Microsoft office has identified a potential security problem". Automatic update of link has been disabled. Do not enable this content if you don't trust the source.

When I click "enable" excel offers me to update link and nothing happens then, regardless what I press (update links/don't update) I just get an empty excel work book.

 


Comment by: Jan Karel Pieterse (5/9/2017 3:48:57 PM)

Hi Sardor,

Perhaps another (possibly hidden) file is the one containing links?

 


Comment by: Monnie (6/14/2017 10:41:15 PM)

Something corrupted the Excel of my Office 2000. I am running Windows 7 64 bits. Excel will open in safe mode and also with /automation. I had deleted registry keys in HKEY_CURRENT_USER\Software\Microsoft\Office\9.0 and there are still some registry key in HKEY_CURRENT_USER\Software\Microsoft\Office\12.0 for Excel which I have not deleted. Add-ins are all deleted. XLSTART folder is empty. I have run repair Excel several times, and even uninstalled and reinstalled the entire Office.
Any suggestion?

 


Comment by: Jan Karel Pieterse (6/15/2017 9:14:19 AM)

Hi Monnie,

Hmm Office 2000 you say? You do know that version has been officially out of support for a looooong time now?

I would strongly advise you to consider upgrading to a newer version. Office 365 is very affordable in its most basic plan. I can't really advise on the cost as it depends on your situation. You may be eligible for a student and teachers license, I don't know.

What errors do you get when you try to run Excel?

 


Comment by: Monnie (6/15/2017 10:30:54 AM)

Thanks for all the suggestions and I finally found the culprit after running Excel in Window Safe Mode as well as in Excel Safe Mode. I recently installed Hitman Pro Alert and when I disabled it, Excel will open normally again. So I have contacted them to see if there is a fix for the conflict.

The errors was Excel will open and then shut itself down immediately, or rather shut down by Hitman Pro Alert it turns out.

 


Comment by: Jan Karel Pieterse (6/15/2017 10:34:11 AM)

Hi Monnie,

Odd that hitman pro triggers this, but glad you found the problem. I do hope your system isn't infected by something though.

 


Comment by: Richard Wright (8/15/2017 9:21:55 AM)

Within the last week I had a different problem to Monnie's with Excel in Office 2007. Found I could not save a spreadsheet or close Excel. When I forced closure of Excel by Ctrl + Alt + Del, Hitman Pro came on the screen to say I had been saved from a fate worse than death.

When I repaired Office 2007, I still had the same problem with Excel.

Only uninstalling Hitman Pro did the job.

 


Have a question, comment or suggestion? Then please use this form.

If your question is not directly related to this web page, but rather a more general "How do I do this" Excel question, then I advise you to ask your question here: www.eileenslounge.com.

Please enter your name (required):

Your e-mail address (optional but if you want me to respond it helps!; will not be shown, nor be used to send you unsolicited information):

Your request or comment:

To post VBA code in your comment, use [VB] tags, like this: [VB]Code goes here[/VB].