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?
 
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.
 

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