File or assembly name Microsoft.Office.Interop.Excel, or one of its dependencies, was not found.]

I have an ASP.NET application created on my server that uses Microsoft.Office.Interop.Excel to dynamically create an Excel workbook.
It has a necessary reference, and was compiled and run OK on my server.

But when I moved the application to the network server where it is supposed to run, it failed to load because of the runtime error:
"File or assembly name Microsoft.Office.Interop.Excel, or one of its dependencies, was not found."

I copied ALL project files and directories from my server to the network server.
The application loads if the line uses the Microsoft.Office.Interop.Excel  is commented out.
The network server is Windows 2003 server.

What can I do to resolve the problem?

Thank you very much.
pavelmedAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

prajeebkumarCommented:
if your dev or local box doesn't have office 2003, your application is probably refering to office 10.0 version dll.. but when you move to a 2003 box, you have the updated office 11.0 version.. since its a built in reference in .net, its probably not able to recognize the older version in 2003 box. You could install 2003 office version on your dev box and re-reference the excel interop assembly and that should solve your problem. I'm not sure if this is the best solution but unless you hear from someone else, you can try this.
0
Jojo1771Commented:
One peice of advice for you.. Install Excel on your sever, problem fixed.
0
pavelmedAuthor Commented:
My local server has Office 2003 installed.  The applicatiom has a reference to 11.0 library.  Therefore it does not look like this a cause.
But network server does not have Office installed since it is used only as a web server, no workstation users.
I thought that the application's DLL could have contain all necessary info to use Excel since it was compiled on the box that does have the Office installed.
I am not in charge for the server, but I'll try asking somebody to install Excel on it.

Related question:
On my local server, I tried to search for the Microsoft.Office.Interop.Excel.DLL hoping that I could be able to copy it to the network server.
However, the search did not find Microsoft.Office.Interop.Excel.dll on my local box.
I had searched the entire drive including hidden and system folders.  
How is it possible?
0
Jojo1771Commented:
You are right, That becaue the refrence is relally pointing to the Execl.exe, So trust me when I say that even if you had that  dll you still won't have 1/2 of what you need.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
pavelmedAuthor Commented:
Jojo1771,
I could not test it because I was suggested against installing Excel on the web server box because of company's specific reasons, so I'll need to redesign the application.
However I believe that your suggestion would help and therefore accept your answer.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
ASP.NET

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.