Pivot Table Field Data
 

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

Pivot Table Field Data
 

Hi Annie

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

--
Regards

Roger Govier


"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

Pivot Table Field Data
 

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

Pivot Table Field Data
 

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

"Roger Govier" wrote:

Hi Annie

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

--
Regards

Roger Govier


"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

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