Pivot Table Field Data
Thank you too Peo. Annie
"Peo Sjoblom" wrote:
After you remove the date field in the layout, refresh the pivot table then
move it back
--
Regards,
Peo Sjoblom
"Annie" wrote in message
...
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
|