Thread
:
Pivot Table "Data source reference is not valid" error cause?
View Single Post
#
2
Posted to microsoft.public.excel.misc
Roger Govier[_3_]
external usenet poster
Posts: 2,480
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 With Quote
Roger Govier[_3_]
View Public Profile
Find all posts by Roger Govier[_3_]