Sleeper: Error message pivot table is not valid

[lhs42]

gremlins have been @ my file since friday. went to refresh P/table this morning & get message "Pivot table is not valid - then popup with: Microsoft excel cannot make this change because there are too many row or colums items. Drag at least one row or column field off the pivot table, or to the page position. Alternatively, right click Hide or Hide Levels on the shortcut menu.

When i try to change my pivot table (as per above suggestion) , it says that my pivot table is not valid (most helpful).

i've tried saving both files, closing them down. closed all other applications down. had a cup of tea. but i'm still baffled. please help!

[geekgirlau]

There are limitations as to how much data a pivot table can handle. Microsoft states that Excel will cope with up to 8,000 items in a pivot table report, so sometimes you'll receive this error not because of the number of rows or columns, but because of the amount of data you're attempting to pivot.