gremlins have been @ my file since friday.

i have data in one w/sheet & pivot tables in another. all was working fine on friday.

opened both files this morning. changed & saved data. went to refresh P/table & get message

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, it says that my pivot table is not valid ??? I don'T understand what's going wrong ?

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!