Corrupt Pivot Table

[Ifatooki]

Hello
Ive noticed that over time my pivot tables become corrupt,for instance
i have two PT based on the same data range, in the beginning they both
worked correctly now one table is flawed. Since im new to Excel ive
got in the habit of making backup copies but if any one knows how to
prevent this please let me know

 

[Guest]

In what way is it flawed?

 

[Ifatooki]

In what way is it flawed?





- Show quoted text -

maybe flawed is a little harsh, let say Odd
i am using:
set cc_range = Worksheets("Pivot").range("Clist") ' Clist is a range
of cost centers 1000,1002,1110.1129 etc
set pivot_cc = worksheets("Pivot").range("B2") ' the cc cell on the
pivot table
to filter my Pivot table of payroll data
what i have notice first is that no matter how the Clist is sorted it
is random when i use:

for each c_cell in cc_Range
pivot_CC.value = cc_cell.value
'do some other stuff here
next c_cell

which becomes a nightmare when i have to print them out the order is
never the same
Since im doing this with more then one range they sometime get mixed
up (How I Dont have a clue)
Mangers end up in the cost center, directors end up in manager, and cc
show up in pay period, which mean i have to manually rebuild the
table, Unless someone know a way to reset the tables to there actual
values.

 

[Guest]

Hi,

Check the online help topic "Troubleshoot PivotTable reports "

Challa Prabhu