In one of my application, couple of pivot tables which was there in one of the sheet was showing "Allocated memory exceeded". But when I copy and paste the same sheet which contains the pivot table I am able to see the data in the pivot table.
Just increase the size of the memmory for the object in the General tab---Memory in the same sheet. Sometimes the expressions will cause this issue. So can you please provide the complete details.
