I've created an ASP.NET page that uses the Microsoft Office Interop assemblies to create an excel file. Currently, if I run the site on my local machine, it runs fine. Excel is opened, the .xslx file is created and stored to a directory called "Temp" (where it is later deleted automatically).
I've a server (running Server 2008 R2 and IIS 7) which I already have the main site running on. When I upload the newest code, which includes this new excel spreadsheet feature, trying to generate the Excel file gives the following error:
Microsoft Excel cannot open or save any more documents because there is not enough available memory or disk space.
To make more memory available, close workbooks or programs you no longer need. To free disk space, delete files you no longer need from the disk you are saving to.
I've looked at various sites and most point to an issue with permissions. I've tried giving rights to various groups and users but nothing works.
Could you point me in the right direction?