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