Pivot Table - Select Multiple Items not ticked

I have a pivot table which takes data from another tab and I am using one of the value fields(premium) as a report filter so I can exclude any zero amounts. The problem I have is that the amount of data each month increases and when I refresh the pivot it does not automatically include the new values, they remain unticked.

I am using Excel 2007, I have an old version of this which I brought over from Excel 2003 into 2007 with old style pivot tables and these ones work fine. Its just if I create a brand new pivot in 2007(blue header and footer) it does not want to tick all new updated values!

Please could anyone help

Tnahks

Hi noddy and welcome to the forum,

This is a common problem that takes a Dynamic Named Range to easily solve.

1. Create a Dynamic Named Range using the Names Manager of the data your pivot table uses. See http://www.contextures.com/xlNames01.html
2. Then change the data source of your Pivot Table from the fixed range to the Dynamic Named Range name.

Hope this helps. If not, attach a sample workbook and I'll show you how.
To attach click on "Go Advanced" then the Paper Clip Icon above the message area.

Hi,
I only partially understand the question.
1. Instead of using a DNR you have a named range that will include all your data (and a lot of blank cells)
2. You add data to the bottom of your current data, but still in the named range.
3. These new items show in the filter list of the pivot, but on the bottom and are not checked.
4. You check the new items in the filter and refresh the pivot table and they don't show.

I need an example of what is happening. My guess is you haven't used the named range in the Pivot's Data Source. You are still using a static range for where your pivot is getting the data from.

Thanks for explaining how you solved the problem. I would never had thought of that.