C# Excel interop Open

Question

c# excel 2013 workbook.open gives error

"Microsoft Excel cannot open or save any more documents because there is not enough available memory or disk space. \n\n• To make more memory available, close workbooks or programs you no longer need. \n\n• To free disk space, delete files you no longer need from the disk you are saving to."}

There is plenty of space.  Program has been working for very long time.  Now also just when I click from desktop I get same message.  I had replaced disk so assumed that might have caused problem.  Put old disk back in - same problem.  There is plenty of space > 500 gb on disk and 24 gb memory, 17 available.

Answer 1

Hi ffAzure,

Are you coding an app in C# which connects to Excel, via the Interop?

Answer 2

Yes I am.

I repaired Excel and that did not help.

I just found the problem.  Excel was using a volume on a drive that got re-lettered when I moved disks around.  Putting the volume back to the original letter solved both problems (program and desktop).

Does anyone know how to tell Excel to use the C: drive for (I assume) its temp space?  This is my understanding of the history.  I added an SSD drive for the boot drive and imaged it with Macrium Reflect from the old drive's C: volume.

The old drive had a C (boot partition) as well as a D partition.  When I moved the old drive to the 2nd bay, the old drives D partition stayed the same but the old boot partition changed to F.  Apparently Excel kept using the F.  Now I tried to replace the D drive and the problem started occurring (because there was no F partition as it turns out).  I put the old drive back in but now Windows made it a G drive.  I solved the problem by renaming the G to F.

What I would like to do is have Excel use the C drive for its temp space and remove the F partition totally. Does anyone know how to do that?

Answer 3

It happens when I try to start up Excel from start menu also before I try to select a file.  What I am really trying to do is create a worksheet from a program with the interop dlls.  This has been working for months.  A file has not even been named yet.

Most likely the repair mentioned above will work.  I am trying it now.  Thank you very much.

Answer 4

See if this solution given here apply for you.

https://answers.microsoft.com/en-us/msoffice/fo...

Answer 5

Hello. I'm Rey, a Community Expert willing to help the users.

Does this issue happens with all your Excel files or just one specific?.

Have you tried repairing Office?. If not follow the below link:

https://support.office.com/en-us/article/Repair...

Best Regards