PIVOT TABLES 1

[Bombbass]

I have a user who uses a pivot table with a source worksheet to update vatious pieces of information. This has worked successfully for years. All of a sudden when they run the Refresh to update for current figures it BLANKS out the entire table and seems to delete the information that is already there.
Anybody got any ideas?

Thanks

Bombbass

 

[SkipVought]

Hi,

Check the reference to the source data.

Select in the PT.

Right-Click and [Back]

Select in the Source Data Reference to verify that it corresponds to the entire Source Data Range.

Skip,

_{[red]Be Advised![/red] A chicken, who would drag a wagon across the road for 2 cents, is…
POULTRY in motion to PULLET for a PALTRY amount!}

 

[coachdan]

Agree with Skip, check the source rows by going into the wizard and reselecting the range.

coachdan32

http://www.malehsbaseball.com