Forum Discussion
Pivot table from csv data saved as excel workbook
I have downloaded the data as csv from a financial institution website and saved the file as an Excel workbook. But when I try to create the pivot table, it says that I have empty cells and won't create the table. I am not seeing any empty cells in the range that I have selected.
2 Replies
You converted only one column in the range to the table, not sure what was the reason
If convert this column back to range and create the table from all columns, or use the range only, you may create PivotTable
- Whenever you select the data for pivot just verify whether the first row has data in all cells or not
Then you will not get that error
