Forum Discussion
Issue with dynamic pivot chart
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.
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.