ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Why do I get invalid data source when creating a pivot table? (https://www.excelbanter.com/excel-discussion-misc-queries/153667-why-do-i-get-invalid-data-source-when-creating-pivot-table.html)

Stricia

Why do I get invalid data source when creating a pivot table?
 

--
Striciaw

Debra Dalgleish

Why do I get invalid data source when creating a pivot table?
 
Maybe one of the heading cells is blank. Check to see if there are any
hidden columns, or if you've selected an extra column to the right of
the data.
To create a pivot table, the data must have an entry in every cell in
the first row.

Stricia wrote:

--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html



All times are GMT +1. The time now is 02:21 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com