| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table "Data source reference is not valid" error cause?
What causes this error:
"Data source reference is not valid" when I'm trying to insert a Pivot Table from simple Excel data that is properly formatted with no blank cells and appropriate headers as column labels? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Pivot Table "Data source reference is not valid" error cause?
Hi Bill
One possibility, the source range has become invalidated because rows have been deleted. Right click on any cell within PTPT WizardBackcheck the source range -- Regards Roger Govier "Bill Neurohr" <Bill wrote in message ... What causes this error: "Data source reference is not valid" when I'm trying to insert a Pivot Table from simple Excel data that is properly formatted with no blank cells and appropriate headers as column labels? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Error "invalid data source reference" for pivot table | Excel Worksheet Functions | |||
| Pivot Table "Field Name is not valid" error | Excel Discussion (Misc queries) | |||
| "Reference not valid" error when I try to edit the macro in excel | Excel Discussion (Misc queries) | |||
| Create pivot table, error "Range is not valid" | Charts and Charting in Excel | |||
| Pivot Table - Error "Reference Is Not Valid" | Excel Discussion (Misc queries) | |||
Linear Mode
