Excel cannot complete this task with available resources error, Excel 2013

I have built a PowerPivot dashboard in which I have incorporated slicers. My problem is that users with whom I have shared the file get the below error prinstshot attached  while clicking on the slicers. Note that this does not happen with me. And it is not all user who are facing this issue. I have tried the following resolutions from technet but none of them have been able to help me resolve this error.

1) Repairing Office 13 on users system.

2) Emptying the temp files in  both temp folder as well as C:\Users\\AppData\Roaming\Microsoft\Excel\

3) All user use Windows 8 with Office 2013 with 4 gb Rams'

4) Also installed all Online windows Update.

5) Powerpivot is activated also.

6) 32 bit is being used by everyone.

August 9th, 2013 3:47am

Hi

Based on my research, we can solve the problem with following methods:

1.Create a new file and check if it works. If it helps, then copy the contents of the file to a new file and check if it helps.

       Also, you can refer to the following link:

        http://answers.microsoft.com/en-us/office/forum/office_2013_release-excel/excel-cannot-complete-this-task-with-available/4861a69a-6ce0-4c74-ad45-9012d5edf9f1?msgId=95b69652-0902-4564-9884-952e0ba54e15

2.Try to disable hardware graphics acceleration from File > Options > Advanced > Display section and disable Aero Themes (if you enabled) to check the results.

                For the hangs and crashes issues, we may use ADPlus.vbs to troubleshoot:

                http://support.microsoft.com/kb/286350/en-us

3.the error occurs when you:

        Open or save an Excel workbook
        Open an Excel workbook that references a relative name from another workbook
        Use a defined name in a formula in an Excel workbook
        Define or delete a name in an Excel workbook

         And there are several methods to check the issue, please refer to the following link:

        http://support.microsoft.com/kb/2655178

        The link applies to Excel 2010, but we can refer to it.

4.Repair of office 2013 may also help to solve the issue

Regards

Free Windows Admin Tool Kit Click here and download it now
August 11th, 2013 10:43pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics