"Excel cannot complete this task with available resources. Choose less data or close other applications."
I have a RDS server running Server 2012 R2.
It is a single session host, with 32GB of RAM and 8vCPUs.
Currently there is only one user actively using this server. They have been having a constant issue with Excel, they are getting the message randomly when trying to open files:
"Excel cannot complete this task with available resources. Choose less data or close other applications."
This error occurs regardless if the excel file has 1 word in it or a hundred pages and fomula's. After researching around I tried obviously removals, re-installs, and switching from x86 to x64 Office 2013. Still same error. After this, we even built a new RDS server from scratch with no other purposes or software, but to run Office 2013 and Quickbooks 2015. Still same issue.
The issue happens when the user clicks on File -> Open -> And clicks a document to open. The documents are XLSX and are not old format. It has even happened with a new file that she opened, entered some basic text, and saved. She saved the doc, closed it, opened it and got the same error.
I would like to note, the user is configured with Folder Redirection and Roaming profile. I am out of ideas, my next step is to delete and rebuild her roaming profile, or have her try a local profile temporarily.
Any other ideas?
It is a single session host, with 32GB of RAM and 8vCPUs.
Currently there is only one user actively using this server. They have been having a constant issue with Excel, they are getting the message randomly when trying to open files:
"Excel cannot complete this task with available resources. Choose less data or close other applications."
This error occurs regardless if the excel file has 1 word in it or a hundred pages and fomula's. After researching around I tried obviously removals, re-installs, and switching from x86 to x64 Office 2013. Still same error. After this, we even built a new RDS server from scratch with no other purposes or software, but to run Office 2013 and Quickbooks 2015. Still same issue.
The issue happens when the user clicks on File -> Open -> And clicks a document to open. The documents are XLSX and are not old format. It has even happened with a new file that she opened, entered some basic text, and saved. She saved the doc, closed it, opened it and got the same error.
I would like to note, the user is configured with Folder Redirection and Roaming profile. I am out of ideas, my next step is to delete and rebuild her roaming profile, or have her try a local profile temporarily.
Any other ideas?
Justin Stear
I don't see any mention of you testing this with any other users or a test account, try that and rule out if it is the one users account or not.
Does this happen on the same file AFTER you FULLY log out and log in again? Can you try to close all open Excel windows (include removing them in task manager if you see them there), and then open the file again?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.