Pivot Table Drop-down list

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have written a spreadsheet which queries external data and places it in a
worksheet list which also contains various extra formulas. This query
includes a criteria that states that the data must match a particular
year-period (e.g. period 4) A Pivottable looks at this worksheet list and
displays the data.
I have recently copied the workbook and altered the query so that only data
from period 5 is listed. However, the Pivottable dropdown still contains the
datalist from period 4 as well. Is there any way I can just display the data
called by the query, as even for period 5 the list runs to over 300 items. I
have tried refreshing all queries and pivottables, and also removing the
field from the 'row' area of the pivottable, saving and closing the workbook
and the reopening, but with no success.

Thanks,
Steve
 
Back
Top