software

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 quot;Week_Endingquot; pivot table field. Any ideas or help will be
much appreaciated!
Thank you. Annie

Hi Annie

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

--
Regards

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

--

Regards,

Peo Sjoblom

quot;Anniequot; gt; wrote in message
...
gt; Pivot tables in Excel 2003 are all fine, except - I typed a date
incorrectly
gt; in the database and now the Pivot table retains this mistake when you
click
gt; the Field Name drop-down. The date was corrected, and I have refreshed all
gt; the data to the database and have tried removing the date field from the
gt; layout and adding it back again. Nothing works! Though no data is returned
if
gt; this erroneous date is chosen, I would like it not to appear at all as a
gt; choice under this quot;Week_Endingquot; pivot table field. Any ideas or help will
be
gt; much appreaciated!
gt; Thank you. Annie
Thank you Roger. This solution just saved me from recreating the entire
report from scratch in a new file. Solution worked perfectly. Annie

quot;Roger Govierquot; wrote:

gt; Hi Annie
gt;
gt; Drag the filed off the PT.
gt; Carry out a Refresh.
gt; Drag the Field back to the PT again.
gt;
gt; --
gt; Regards
gt;
gt; Roger Govier
gt;
gt;
gt; quot;Anniequot; gt; wrote in message
gt; ...
gt; gt; Pivot tables in Excel 2003 are all fine, except - I typed a date
gt; gt; incorrectly
gt; gt; in the database and now the Pivot table retains this mistake when you
gt; gt; click
gt; gt; the Field Name drop-down. The date was corrected, and I have refreshed
gt; gt; all
gt; gt; the data to the database and have tried removing the date field from
gt; gt; the
gt; gt; layout and adding it back again. Nothing works! Though no data is
gt; gt; returned if
gt; gt; this erroneous date is chosen, I would like it not to appear at all as
gt; gt; a
gt; gt; choice under this quot;Week_Endingquot; pivot table field. Any ideas or help
gt; gt; will be
gt; gt; much appreaciated!
gt; gt; Thank you. Annie
gt;
gt;
gt;

Thank you too Peo. Annie

quot;Peo Sjoblomquot; wrote:

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