lhs42
04-11-2005, 01:44 AM
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!
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!