Error Message
"The PivotTable field name is not valid. To create a PivotTable, you must use data that is organized as a list with labeled columns. If you are changing the name of a PivotTable field, you must type a new name for the field."
To resolve this problem,
Method 1
Modify the first row so that it does not contain any empty cells.
Method 2
Change the range the PivotTable references to a range where the first row does not contain empty cells. To change or to determine the range an existing PivotTable references.
Thanks : support.microsoft.com
ไม่มีความคิดเห็น:
แสดงความคิดเห็น