CODEWITHSUNDEEP
vbapivot
Nitin
Nitin

Reputation: 5

Facing Error "Excel can not complete this task with available resources" and another error is "There is no enough memory to complete this action"

While refreshing pivot tables in a file I am getting the error: "Excel cannot complete this task with available resources". Another error is: "There is no enough memory to complete this action". May I get any help regarding this error? I am using this code for refreshing pivot tables in different sheets.

pt1.ChangePivotCacheDSC.PivotCaches.Create(SourceType:=xlDatabase,SourceData:=SourceAddress)
ws6.PivotTables("PivotTable5").PivotCache.Refresh

Upvotes: 0

Views: 1172

Answers (1)

timthebomb
timthebomb

Reputation: 230

This usually means that either your computer doesn't have enough RAM to store the information needed to complete the calculation, or that Excel's limits have been reached. If you press CTRL + Shift + Escape and look at how much of your computer memory is being used, you can narrow down the options pretty much to Excel being the limiting factor.

EDIT:

Some options to fix this issue could be:

-As ThunderFrame has hinted at, Install 64-Bit Excel.

-Perform the calculation on a smaller dataset.

-Install more RAM on your computer.

Upvotes: 2

Related Questions