| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Error "invalid data source reference" for pivot table
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| "Cannot open pivot table source file" | Excel Discussion (Misc queries) | |||
| Why do I get invalid data source when creating a pivot table? | Excel Discussion (Misc queries) | |||
| Pivot Table - Error "Reference Is Not Valid" | Excel Discussion (Misc queries) | |||
| Excel Service error "cannot connect to external data source" | Excel Discussion (Misc queries) | |||
| Changing data source in pivot table- "Back" button is disable | Excel Discussion (Misc queries) | |||
Threaded Mode
