Type Mismatch Error appears everytime Excel is opened

Hi everyone,

I've been having a rather non-invasive, but annoying problem. Everytime I open Excel Type Mismatch, Microsoft Visual Basic for Applications, appears. I have already deleted all my macros but this problem still appears. Is there anyway i can solve this? Or is there a way to "reset" my excel?

Thanks,
Russ

Does this happen when you open a specific file, or any file?
Does it happen when you open Excel by clicking on the Excel icon rather than opening a file?

This happens with any file - even when i open Excel as a general application

Does it give you the option to click on a "Debug" button when the error shows up?

I suspect you have some kind of "Open Workbook Event" in a "Personal.xlsb".
Delete that (or fix that) and all should be fine.

Nah, it just shows the selection Ok or Help. It kept opening Personal.xlsb but i deleted that file a few hours ago. The error is still going on though...

If you open the VBE (Alt+F11) does the Personal.xlsb still show in the list on the left hand side?

If not, I'm stumped. I'm sure someone will come along with the solution though.

BSB.

Nope. I have attached my alt-F11 screen

ATTACH]335133[/ATTACH]

That's amazing. I disabled my add-ins and the error disappeared. Its weird why that should happen considering the add-ins were from microsoft!

I get exactly the same problem.
I have experienced the problem in Excel 2010 and 2013.
I get the problem opening either an Excel file or simply opening Excel (i.e. no file, blank worksheet)

I can reproduce the error by turning on or off the "Solver" add-in.
With the solver add-in -> error. Without the solver add-in -> no error

The behavior is that the error occurs immediately upon opening Excel even before the blank worksheet shows (2010).
Once I dismiss the error everything works fine. I do fairly complicated spreadsheets, but do not use macros and I don't know VBA programming.

Also, I get the error as soon as I enable the "Solver" add-in while Excel is running. As soon as I enable Solver I get the error with a blue spinning circle (i.e. nothing in Excel responds until the error is dismissed. Again, everything works fine after that until the spreadsheet is re-opened and the error occurs and, again, can be dismissed and everything works fine.

I do not have any macros, VBA macros, hidden worksheets (I found various advice on the web on how to check those things).

So, I don't see a ton of complaints about this on the web, so the only thing I can think of is that one of my Excel files is in some way messing with some part of the Excel environment (VBA??) that becomes part of my installation of Excel.

I'm thinking of uninstalling and re-installing and seeing if the error happens before I open any of my old files.

Thoughts?

In my experience this is 100% reproducible in either Excel version I mentioned above.

OK, I uninstalled Office 2013 and then re-installed.
Then I opened Excel (just the app, no file) and the error appeared. I checked the add-ins and sure enough Solver was enabled. A clean install should not include Solver being enabled.
This clearly indicates there was some environmental variables/data left around after the uninstall and picked up on the re-install.

That may account for the persistence of the problem across Excel 2010 and 2013 installations (leftover environment files not removed by un-install).
It also, perhaps, means that a somehow corrupted Excel file could have left environmental stuff that then generally affected Excel.

Originally Posted by newdoverman

Solver is part of the installation of Excel. You can however not select to install it when installing office. Look under Microsoft Excel, Addins and choose Not Available from the choices. Solver will then not be installed. You can uninstall Solver by going to Programs and Features, Microsoft Office, Change go to Excel, Addins and make solver unavailable.

I'm not trying to gt rid of Solver. I'm trying to understand why, immediately after installing office 2013, I get a Type Mismatch Error immediately after checking the Solver box in manage excel add-ins.

Major point: There is no VBA code. It's a clean install.
Major point: There is clearly stuff left behind after an uninstall that is being picked up with a re-install.

Seems to me that the problem is in the stuff left behind after the uninstall. (Obviously some lame-brained thing I did in the past that is being propagated along.)

Any ideas on how to clean the detritus left behind after uninstalling? I don't know how, but I'm betting that if I could do that it would solve the problem.

Thanks.

Originally Posted by midhenry

I'm not trying to gt rid of Solver. I'm trying to understand why, immediately after installing office 2013, I get a Type Mismatch Error immediately after checking the Solver box in manage excel add-ins.

Major point: There is no VBA code. It's a clean install.
Major point: There is clearly stuff left behind after an uninstall that is being picked up with a re-install.

Seems to me that the problem is in the stuff left behind after the uninstall. (Obviously some lame-brained thing I did in the past that is being propagated along.)

Any ideas on how to clean the detritus left behind after uninstalling? I don't know how, but I'm betting that if I could do that it would solve the problem.

Thanks.

Hey I'm having the same problem with excel, were you able to find a solution to this?

Thanks.

hey thanks for the reply, but no i didnt try it yet as i wanted to know if that helped the previous person.

Originally Posted by newdoverman

Did you do an absolutely clean install as suggested earlier?

i tried out with revo (and couple of other such uninstallers also) but some how i feel there are certain files that uninstallers dont manage to remove. Because as mentioned everytime i clean install office some how excel solver add on is also enabled. (afaik solver add on is not enabled by default. or is it in the office 2013?).

anyway issue is still there it is annoying. any more suggestions?