Pivot Table Field Data

A

Annie

Pivot tables in Excel 2003 are all fine, except - I typed a date incorrectly
in the database and now the Pivot table retains this mistake when you click
the Field Name drop-down. The date was corrected, and I have refreshed all
the data to the database and have tried removing the date field from the
layout and adding it back again. Nothing works! Though no data is returned if
this erroneous date is chosen, I would like it not to appear at all as a
choice under this "Week_Ending" pivot table field. Any ideas or help will be
much appreaciated!
Thank you. Annie
 
R

Roger Govier

Hi Annie

Drag the filed off the PT.
Carry out a Refresh.
Drag the Field back to the PT again.
 
P

Peo Sjoblom

After you remove the date field in the layout, refresh the pivot table then
move it back
 
A

Annie

Thank you Roger. This solution just saved me from recreating the entire
report from scratch in a new file. Solution worked perfectly. Annie
 
A

Annie

Thank you too Peo. Annie

Peo Sjoblom said:
After you remove the date field in the layout, refresh the pivot table then
move it back

--

Regards,

Peo Sjoblom
Click to expand...
 
Top