Glitch/Problem with Pivot table, how to handle this?

[radian89]

Hi All,

I found this problem and this is so serious!

I'm using Excel version : 2016 for Windows

So, when i have pivot table on a sheet, it'll render the all cells in the sheets can't be edited/inputted, see i was trying to type in E5, while the pivot table is in column M & N row 3.

how to overcome this problem? right now, i can move the pivot to a different sheet, but it'll make that sheet un-editable too!

HELP~

thanks

 

[oldbrewer]

the pivot table is not complete - there should be a summary table

only a field name is showing

[TABLE="width: 452"]
<colgroup><col span="4"><col><col><col></colgroup><tbody>[TR]
[TD]color[/TD]
[TD]score[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]red[/TD]
[TD="align: right"]47[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]blue[/TD]
[TD="align: right"]51[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]green[/TD]
[TD="align: right"]55[/TD]
[TD][/TD]
[TD][/TD]
[TD]color[/TD]
[TD]blue[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]red[/TD]
[TD="align: right"]59[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]blue[/TD]
[TD="align: right"]63[/TD]
[TD][/TD]
[TD][/TD]
[TD]Sum of score[/TD]
[TD]Total[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]green[/TD]
[TD="align: right"]67[/TD]
[TD][/TD]
[TD][/TD]
[TD]Total[/TD]
[TD="align: right"]189[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]red[/TD]
[TD="align: right"]71[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]blue[/TD]
[TD="align: right"]75[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]green[/TD]
[TD="align: right"]79[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]