View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Robert Hamilton
 
Posts: n/a
Default Pivot Table Refresh Problem

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?