While downloading data from 11G forms application to Microsoft Office Excel 2007 I am getting below error

Microsoft Office Excel cannot open or save any more documents because there is not enough available memory or diskspace......

Requesting for your suggestion.

Hi Sravanakumar,

Based on your description, you said you download data from Oracle Forms 11G application, did you mean you import data from Oracle Forms 11G application? If this issue appeared in other excel files or even a new file?

With your error message, this issue is normal and the reason causes it is different. First please check if your computer have enough memory or disk space. If the memory and disk space is normally, there are another 2 methods you can try:

Method 1

Correcting key in registry.

HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\User Shell Folders

Set Cache  to :

C:\Windows\Temp

You can watch this video and try this method:
https://www.youtube.com/watch?v=3ugck2ml_WE

Please Note: Since the web site is not hosted by Microsoft, the link may change without notice. Microsoft does not guarantee the accuracy of this information.

Method 2

1. Go to Run -> dcomcnfg (for 64 bit: dcomcnfg -32)
2. Click Component Services -> Computers -> My Computer -> DCOM Config
3. Right-click on Microsoft Excel Application and select Properties
4. On the Identity tab select The interactive user.
5. Click Apply to save the settings. Restart Microsoft Excel and the issue is resolved

Notes: Some people advice to also give ASP.net Read/Write permissions. You can do this on the Security tab. In my case this was not needed in order to fix the issue.

Please try these methods, and let me know if they work. Im glad to help and follow up your reply.

Regards,

Hi George,

       Thanks for your prompt response.

       Yes we are importing data from Oracle 11G forms application to Excel.

        From the server location itself we run our 11G forms application and tried to import data to excel,but couldnot work. But we can see the Excel.exe session been invoked in "task manager" -->"processes".

        I have cleaned up "%temp%" folder. And the RAM is 16GB. But still couldn't .

        Meanwhile I will try your steps and keep posted you.

Regards,

Sravan.

Hi,
I'm marking the reply as answer as there has been no update for a couple of days.
If you come back to find it doesn't work for you, please reply to us and unmark the answer.

Regards,