zito2000
asked on
Error message when refeshing Pivot Table Data in Excel 2010 32 bit
We have a user running Excel 2010 32bit and she is experiencing an issue when she attempts to refresh pivot table information.
It takes at least 10-20 minutes "reading date", then eventually failes with the following error message.:
"Excel cannot complete this task with available resources. Choose less data, or close other applications"
I have tried disabling add-ins, closing other applications, ending intensive processes in task manager, disabling hardware acceleration in Excel, restarting the PC, and even switching calculation mode to manual with no success.
Our last solution would be to rip out Office 32bit and install 64bit, but we were wondering if there are ANY other fixeses someone may know of that I haven't tried yet.
Attached is a screenshot of the error message.
Thanks,.
error.png
It takes at least 10-20 minutes "reading date", then eventually failes with the following error message.:
"Excel cannot complete this task with available resources. Choose less data, or close other applications"
I have tried disabling add-ins, closing other applications, ending intensive processes in task manager, disabling hardware acceleration in Excel, restarting the PC, and even switching calculation mode to manual with no success.
Our last solution would be to rip out Office 32bit and install 64bit, but we were wondering if there are ANY other fixeses someone may know of that I haven't tried yet.
Attached is a screenshot of the error message.
Thanks,.
error.png
ASKER
@Norie,
I can ask the user if that is feasable,
Thanks,
I can ask the user if that is feasable,
Thanks,
Is the Pivot Data source in the same file or external?
How big is the data source? Might be worth considering Power Pivot.
How big is the data source? Might be worth considering Power Pivot.
ASKER
@Rob, I just emailed the user with your question... if she doesn't know, is there a way to find out?
With the cursor in the pivot table there will be an additional couple of tabs on the ribbon grouped under "PivotTable Tools". One of the tabs is "Analyze" and on that tab there will be a button for "Change Data Source". If you click on that it will show the current data source.
If it is within the same workbook it will just show "SheetName!Range"
If it is external there will be a file path and file name before the SheetName. This could be a network path eg "X:\\Folder\Sub-Folder\Fil eName" or it could be a web address style, eg a SharePoint address.
It may also be a named range eg =Pivot_Data
If it is the latter you will then need to do similar to find the Named Range definition. The Named Ranges are defined in the Name Manager which is under the Formulas tab. The source data for named range will be one of the same options; ie within the workbook or external file which could have a network or web address.
If it is within the same workbook it will just show "SheetName!Range"
If it is external there will be a file path and file name before the SheetName. This could be a network path eg "X:\\Folder\Sub-Folder\Fil
It may also be a named range eg =Pivot_Data
If it is the latter you will then need to do similar to find the Named Range definition. The Named Ranges are defined in the Name Manager which is under the Formulas tab. The source data for named range will be one of the same options; ie within the workbook or external file which could have a network or web address.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
PS Have you checked the range that's the data source for the existing pivot table?