M
mab042
I went to create a new pivot table in my workbook and a message came up
advising me to use the same source as my existing table. I thought I *had*
used the same source so before replying 'Yes', I thought I better check the
source of my existing pivot table. The only way I could find to do that was
VBA "msgbox activesheet.pivottables(1).sourcedata". To my surprise this
showed as "ReportData!C1:C17" which I *know* is *wrong*. It should be
something like 931 rows by 16 cols!
Can anyone throw any light on this ie
- Why would the sourcedata property not be reported correctly?
- Can I check the sourcedata property without using VBA?
- Tell me anything else that might help unravel the mystery.
I am now worried about the integrity of my original pivot table
(although it *looks* OK) and unsure whether to allow Excel to use the same
data source for my second pivot table.
Thanks in advance for any advice.
Marc
advising me to use the same source as my existing table. I thought I *had*
used the same source so before replying 'Yes', I thought I better check the
source of my existing pivot table. The only way I could find to do that was
VBA "msgbox activesheet.pivottables(1).sourcedata". To my surprise this
showed as "ReportData!C1:C17" which I *know* is *wrong*. It should be
something like 931 rows by 16 cols!
Can anyone throw any light on this ie
- Why would the sourcedata property not be reported correctly?
- Can I check the sourcedata property without using VBA?
- Tell me anything else that might help unravel the mystery.
I am now worried about the integrity of my original pivot table
(although it *looks* OK) and unsure whether to allow Excel to use the same
data source for my second pivot table.
Thanks in advance for any advice.
Marc