software

I can't get rid of a column in a pivot table.

After manually changing the date selection criteria in a query that supports
a pivot table report, the pivot table report continues to display that date
as a column even though there is no data to support it. The query results
show no records for that time period, and the pivot table is blank for that
period, but the column still exists in the pivot table report.

I've tried rearranging the table and manually refreshing the report, but the
unwanted column still exists. What can I do to to get rid of this column?

I am not sure I understand you, does this help?

www.contextures.com/xlPivot04.html
--

Regards,

Peo Sjoblom

nwexcelsolutions.comquot;Robert Hamiltonquot; gt; wrote in
message ...
gt;I can't get rid of a column in a pivot table.
gt;
gt; After manually changing the date selection criteria in a query that
gt; supports
gt; a pivot table report, the pivot table report continues to display that
gt; date
gt; as a column even though there is no data to support it. The query results
gt; show no records for that time period, and the pivot table is blank for
gt; that
gt; period, but the column still exists in the pivot table report.
gt;
gt; I've tried rearranging the table and manually refreshing the report, but
gt; the
gt; unwanted column still exists. What can I do to to get rid of this column?
This described the problem perfectly. The manual fix did not work, but the
supplied macro did.

Thank you so very much.
quot;Peo Sjoblomquot; wrote:

gt; I am not sure I understand you, does this help?
gt;
gt; www.contextures.com/xlPivot04.html
gt; --
gt;
gt; Regards,
gt;
gt; Peo Sjoblom
gt;
gt; nwexcelsolutions.com
gt;
gt;
gt; quot;Robert Hamiltonquot; gt; wrote in
gt; message ...
gt; gt;I can't get rid of a column in a pivot table.
gt; gt;
gt; gt; After manually changing the date selection criteria in a query that
gt; gt; supports
gt; gt; a pivot table report, the pivot table report continues to display that
gt; gt; date
gt; gt; as a column even though there is no data to support it. The query results
gt; gt; show no records for that time period, and the pivot table is blank for
gt; gt; that
gt; gt; period, but the column still exists in the pivot table report.
gt; gt;
gt; gt; I've tried rearranging the table and manually refreshing the report, but
gt; gt; the
gt; gt; unwanted column still exists. What can I do to to get rid of this column?
gt;
gt;
gt;