Error "invalid data source reference" for pivot table

  • Thread starter Thread starter Manny
  • Start date Start date
M

Manny

I am attempting to create a pivot table (which I've done in the past) but I
get an error stating that the "data source reference is not valid." The excel
data was created from out internal software in Comma-Seperated Values (CSV)
format. Any thoughts on how to fix this?
 
That didn't work. Anything else I should try? All columns do have headings.
 
Check that the source range doesn't include extra columns at the right
or left.
 
What version of Excel are you using?
In Excel 2003, can you create a list from the data (Data>List)?
In Excel 2007, insert an Excel table.

Then, try to create a pivot table based on the List or Table.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot Table with Data Model Connection - getpivotdata reference issue 0
WHAT DOES 'DATA SOURCE REFERENCE NOT VALID' MEAN? 1
Pivot table data source 1
Excel Error while updating an external data source into a pivot table! 0
Pivot Table Source 3
Workbook pivot table design function 6
Pre-configuring Pivot table "views" 4
Using VLOOKUP when referencing data from Access 2

Back
Top