amerj
Power User
Joined: 13 Apr 2004
Posts: 69
Location: Zurich, Switzerland
|
 Posted: Thu Apr 15, 2004 8:51 am Post subject: DataPilot - "behavioural problems" |
 |
|
More problems with Pivot Tables again ..... 
I have a data source sheet with 2 pivot tables generated - they are showing different values even though under Data-DefineRange they appear to look at the same data ?
This is a similar problem to topic 4561 as the difference between the 2 sheets relates to new data added to the bottom of my source data.
What is strange is that one sheet recognises the new data and updates totals accordingly, the other does not ?!
I am using the same workaround as 4561 for now i.e. I add new data in middle of worksheet.
Any ideas please ?
------------------------------------------------------------------------------------
hmmmm so far 32 people have read this ... and no replies ?!
I ended up going the long way round - I deleted the sheet/pivot table and started again, this time data reads OK.
Wierd ? 
_________________
/Jeremy |
|
