A
Annie30
Hello !
I am using a pivot table in excel to create client reports. The pivo
table extracts its data from another sheet in the same workbook, an
there is exactly 475 lines...
Now when i try to refresh my pivot table, excel pops this message :
Microsoft excel cannot make this change because there are too many ro
or colums items. Drag at least one row or column field off the pivo
table, or to the page position. Alternatively, right click Hide o
Hide Levels on the shortcut menu.
When i try to change my pivot table, it says that my pivot table is no
valid ??? I don'T understand what's going wrong ?
Please help
Anni
I am using a pivot table in excel to create client reports. The pivo
table extracts its data from another sheet in the same workbook, an
there is exactly 475 lines...
Now when i try to refresh my pivot table, excel pops this message :
Microsoft excel cannot make this change because there are too many ro
or colums items. Drag at least one row or column field off the pivo
table, or to the page position. Alternatively, right click Hide o
Hide Levels on the shortcut menu.
When i try to change my pivot table, it says that my pivot table is no
valid ??? I don'T understand what's going wrong ?
Please help
Anni