Forum Discussion
Issue with dynamic pivot chart
Dear All
I have created a dynamic pivot chart from a table.
Everything worked well till today. Some data do not refresh, so I tried to refresh one cell, and when I do it, I get an error saying there isn't enough resource. Message Excel was not able to refresh the dynamic pivot chart table 4 because it might have overlapped another dynamic pivot table. I tried to recreate the dynamic table in a new sheet but I ge the same error. Someone expert in Excel could help me please? thanks very much!! Catherine
CatherineEleen The 1st error is due to the fact that you have too many applications, windows, spreadsheets opened up which is causing the excel not to work smoothly. You need to either increase the RAM or switch to 64bit OS and Hardware System (If using 32bit System) or do both for best results.
2nd Error is causing due to the fact that you have two or more Pivot tables which will overlap each other when data is being refreshed. As you might be adding new datasets so that after refershing Pivot Table is unable to use additional space below or nearby as it is already occupied by another Pivot Table. You need to allocate more free spaces to each Pivot Table or you may shift each Pivot Table to each different sheets so that this error can not appear again when data is being refreshed with new data.
Hope this helps.
1 Reply
CatherineEleen The 1st error is due to the fact that you have too many applications, windows, spreadsheets opened up which is causing the excel not to work smoothly. You need to either increase the RAM or switch to 64bit OS and Hardware System (If using 32bit System) or do both for best results.
2nd Error is causing due to the fact that you have two or more Pivot tables which will overlap each other when data is being refreshed. As you might be adding new datasets so that after refershing Pivot Table is unable to use additional space below or nearby as it is already occupied by another Pivot Table. You need to allocate more free spaces to each Pivot Table or you may shift each Pivot Table to each different sheets so that this error can not appear again when data is being refreshed with new data.
Hope this helps.