What version of Excel are you using?
In Excel 2003, can you create a list from the data (DataList)?
In Excel 2007, insert an Excel table.
Then, try to create a pivot table based on the List or Table.
Manny wrote:
There are no extra columns in the source range.
"Debra Dalgleish" wrote:
Check that the source range doesn't include extra columns at the right
or left.
Manny wrote:
That didn't work. Anything else I should try? All columns do have headings.
"Stephen Lloyd" wrote:
Try pasting it into a new workbook.
"Manny" wrote:
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?
--
Debra Dalgleish
Contextures
www.contextures.com/tiptech.html
Blog: http://blog.contextures.com
--
Debra Dalgleish
Contextures
www.contextures.com/tiptech.html
Blog:
http://blog.contextures.com