I need to create an excel file with some of the rows locked and some of them are unlocked. Also I need to protect the sheet using a password. I've done this by Interop.Excel component. But it's working well with default webserver. While configuring with IIS, it's throwing an error. I gone through several websites and cleared that error by doing some dcomconfig.
Now the application throwing another error such as "Insufficient memort". In my maching excel 2007 is installed. I tried the same application with the another machine, there excel 2003 is there. The application works well.
So, the Interop.Excel has some problems with office 2007.
Any one has faced same kind of issues and found the resolution kindly reply for this post???