MajorGeeks Support Forums

Go Back   MajorGeeks Support Forums > ----------= PC, Desktop and Laptop Support =---------- > Software
Register FAQ Members List Calendar Casino Mark Forums Read

Software Software such as operating systems like Windows XP, Windows Vista, Windows 7 etc., or specific programs.


Reply
 
Thread Tools Display Modes
  #1  
Old 07-15-10, 13:51
be0's Avatar
be0 be0 is offline
Corporal
 
Join Date: May 2004
Location: Belgrade, Serbia (not really)
Posts: 274
Thanks: 8
Thanked 0 Times in 0 Posts
Default Microsoft.Office.Interop.Excel, Version=14.0.0.0 issue

Hello All,

Created a website in which I used Microsoft.Office.Interop.Excel using Visual Studio 2008 professional. I ran in on Windows XP 32-bit with Office 2007.

Now I got a Windows 7 64bit with Office 2010 installed. I have several webpages that basically export values into Excel. When I do a publish from my Workstation to my Windows 2003 web server with Excel 2003 installed on it I get the following error message:

Could not load file or assembly 'Microsoft.Office.Interop.Excel, Version=14.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c' or one of its dependencies. The located assembly's manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040)

Any ideas?
Now here is what I did. I picked from my GAC references version 11. of office. (I have 2 versions that I get to pick 11 and 12 but neither of them works for me and gives me the error.)

I tried editing my web.config file by adding this code to it with no luck:

Code:
<add assembly="Microsoft.Office.Interop.Excel, Version=11.0.0.0, Culture=neutral, PublicKeyToken=71E9BCE111E9429C"/>
        <add assembly="office, Version=11.0.0.0, Culture=neutral, PublicKeyToken=71E9BCE111E9429C"/>
        <add assembly="Microsoft.Vbe.Interop, Version=11.0.0.0, Culture=neutral, PublicKeyToken=71E9BCE111E9429C"/>
        <add assembly="stdole, Version=7.0.3300.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A"/>
Thanks for the help!
__________________
I still miss my girlfriend however, my aim is improving.
Me Tuco Ramirez, brother of Brother Ramirez!
Are you sure?
Yup, I'm sure I'm sure.
Reply With Quote
Sponsored links
  #2  
Old 07-15-10, 23:57
PC-XT's Avatar
PC-XT PC-XT is offline
Master Sergeant
 
Join Date: Oct 2007
Location: on a farm
Posts: 646
Thanks: 27
Thanked 80 Times in 74 Posts
Default Re: Microsoft.Office.Interop.Excel, Version=14.0.0.0 issue

I searched for "located assembly's manifest definition does not match the assembly reference" and "HRESULT: 0x80131040" and found basically the same list of several sites that talked about it. They seem to go into detail about their own projects, but one was marked solved, and said
Quote:
The solution was pretty simple. Just delete the assembly and associated files from my projects bin folder and then choose Add Reference to add the latest version back in.
from http://runtingsproper.blogspot.com/2...-manifest.html
It apparently happens with version changes.
__________________
I.think(code);
I.eat(code.spaghetti);
Reply With Quote
  #3  
Old 07-16-10, 07:09
be0's Avatar
be0 be0 is offline
Corporal
 
Join Date: May 2004
Location: Belgrade, Serbia (not really)
Posts: 274
Thanks: 8
Thanked 0 Times in 0 Posts
Default Re: Microsoft.Office.Interop.Excel, Version=14.0.0.0 issue

Alright.

yesterday I found that and I did it. I picked the appropriate DLs which were:

Microsoft.Office.Interop.Excel.dll
Microsoft.Office.Interop.Excel.dll.refresh
Microsoft.Office.Interop.Excel.xml
Microsoft.Vbe.Interop.dll
office.dll
office.xml

Can you point me out to the post where you found that answer?
__________________
I still miss my girlfriend however, my aim is improving.
Me Tuco Ramirez, brother of Brother Ramirez!
Are you sure?
Yup, I'm sure I'm sure.
Reply With Quote
  #4  
Old 07-16-10, 20:32
PC-XT's Avatar
PC-XT PC-XT is offline
Master Sergeant
 
Join Date: Oct 2007
Location: on a farm
Posts: 646
Thanks: 27
Thanked 80 Times in 74 Posts
Default Re: Microsoft.Office.Interop.Excel, Version=14.0.0.0 issue

I found that quote from http://runtingsproper.blogspot.com/2...-manifest.html
__________________
I.think(code);
I.eat(code.spaghetti);
Reply With Quote
  #5  
Old 07-19-10, 08:00
be0's Avatar
be0 be0 is offline
Corporal
 
Join Date: May 2004
Location: Belgrade, Serbia (not really)
Posts: 274
Thanks: 8
Thanked 0 Times in 0 Posts
Default Re: Microsoft.Office.Interop.Excel, Version=14.0.0.0 issue

lol. Says exactly what you said.

Hmmmm... this is turning out to be a pain...
__________________
I still miss my girlfriend however, my aim is improving.
Me Tuco Ramirez, brother of Brother Ramirez!
Are you sure?
Yup, I'm sure I'm sure.
Reply With Quote
Sponsored links
  #6  
Old 07-19-10, 18:16
PC-XT's Avatar
PC-XT PC-XT is offline
Master Sergeant
 
Join Date: Oct 2007
Location: on a farm
Posts: 646
Thanks: 27
Thanked 80 Times in 74 Posts
Default Re: Microsoft.Office.Interop.Excel, Version=14.0.0.0 issue

I just found the following quote from http://stackoverflow.com/questions/2...bly-reference:
Quote:
You can do a couple of things to troubleshoot this issue. First, use Windows file search to search your hard drive for your assembly (.dll). Once you have a list of results, do View->Choose Details... and then check "File Version". This will display the version number in the list of results, so you can see where the old version might be coming from.

Also, like Lars said, check your GAC to see what version is listed there. This Microsoft article states that assemblies found in the GAC are not copied locally during a build, so you might need to remove the old version before doing a rebuild all. (See my answer to this question for notes on creating a batch file to do this for you)

If you still can't figure out where the old version is coming from, you can use the fuslogvw.exe application that ships with Visual Studio to get more information about the binding failures. Microsoft has information about this tool here. Note that you'll have to enable logging by setting the HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Fusion\EnableLog registry key to 1.
(The quote has links in it that I didn't include.) The page also gives other possible causes, like dll's referencing a nonexistant dll, or other stuff.

Other links I found on Google, but haven't fully read are:
http://mrpmorris.blogspot.com/2007/0...efinition.html said to use a weak name rather than a strong one.
http://www.experts-exchange.com/Prog..._22851923.html (scroll to the bottom for troubleshooting ideas)
http://social.msdn.microsoft.com/For...a-93d64858eece
http://social.msdn.microsoft.com/for...9-e8d365a5fb3e
http://social.msdn.microsoft.com/For...0-e6315c3c5a2d
And the following links I never loaded, but thought I would mention:
http://forums.asp.net/p/1191303/2051870.aspx
http://forums.asp.net/p/1307394/2566065.aspx
http://forums.asp.net/p/934184/1102625.aspx
__________________
I.think(code);
I.eat(code.spaghetti);
Reply With Quote
The Following User Says Thank You to PC-XT For This Useful Post:
be0 (07-21-10)
  #7  
Old 07-21-10, 07:35
be0's Avatar
be0 be0 is offline
Corporal
 
Join Date: May 2004
Location: Belgrade, Serbia (not really)
Posts: 274
Thanks: 8
Thanked 0 Times in 0 Posts
Default Re: Microsoft.Office.Interop.Excel, Version=14.0.0.0 issue

Unfortunately there is only one solution that I was able to come to and that is by installing MS Office 2010 on my Web Server.

That is a bummer.
I tried all of the suggestions here and the ones in the below post.

http://forums.asp.net/p/1574881/3984336.aspx#3984336

Thanks all for your help.
__________________
I still miss my girlfriend however, my aim is improving.
Me Tuco Ramirez, brother of Brother Ramirez!
Are you sure?
Yup, I'm sure I'm sure.
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Microsoft Excel Issue, +'s turning to ,'s xdorkx Software 16 02-03-09 12:19
microsoft office 2007 Pro trial version bb4now Software 2 01-23-08 18:02
alternative to Microsoft Office Excel 2003? SpecialFNK Software 7 02-20-07 04:53
Microsoft Excel issue mindnmuscl2 Software 0 05-31-05 09:14


All times are GMT -5. The time now is 20:38.

MajorGeeks.Com Menu

MajorGeeks.Com \ All In One Tweaks \ Android \ Anti-Malware \ Anti-Virus \ Appearance \ Backup \ Browsers \ CD\DVD\Blu-Ray \ Covert Ops \ Drive Utilities \ Drivers \ Graphics \ Internet Tools \ Multimedia \ Networking \ Office Tools \ NEW! PC Games \ System Tools \ Macintosh \ Demonews.Com \ Top Downloads

MajorGeeks.Com \ News (Tech) \ Off Base (Other Websites News) \ Way Off Base (Offbeat Stories and Pics)

Social: Facebook \ YouTube \ Twitter \ Tumblr \ Pintrest \ RSS Feeds


All content Copyright MajorGeeks.com source code Powered by vBulletin® Version 3.8.4
Copyright © 2009 vBulletin Solutions, Inc. All rights reserved.
Ad Management by RedTyger