Office automation throws exception upon initialization

[Lars_V_J]

I have a webapp where the user can make excel sheets. It's been working fine for some time, but suddenly things start to fail.

When I initialize my Excel process I get an exception.

Code:

            xlApp = new Excel.Application();
            if (xlApp == null)
                m_log.WriteLogLine("xlApp is null", LogLevel.High, LogType.Info);
          
            xlApp.DisplayAlerts = false;
            xlWorkBook = xlApp.Workbooks.Add(misValue);

I get the exception:
[OutOfMemoryException: Insufficient memory to continue the execution of the program.]
Microsoft.Office.Interop.Excel.Workbooks.Add(Object Template)

I've checked that there's enough ram and hhd space, and that we have access to our file destination (even though we're far from the place where we actually try to write to the disk).

Anyone who knows what may cause this and how to fix it?

Edit: I use Office 2013

[dglienna]

Talk to the ISP and ask them. Sounds like a setting that can be changed.

[Lars_V_J]

It is on an intranet...

I even ran the browser on the server

[dglienna]

Check the logs on the server, then.

[Arjay]

If you are not cleaning up the objects, you may be holding onto COM references, so clean up after yourself.

Wrap the xlApp call inside a using block.

using( var xlApp = new Excel.Application())
{
  if (xlApp == null)
    m_log.WriteLogLine("xlApp is null", LogLevel.High, LogType.Info);
          
    xlApp.DisplayAlerts = false;
    xlWorkBook = xlApp.Workbooks.Add(misValue);
}

If Excel.Application doesn't support the IDisposable interface, then explicitly call Close() (or read the documentation on what to call).

Do the same for xlWorkBook.