Hello, I went through this forum and I found some tips how to hide and un-hide items in pivot table using macro, but I couldnt get what I need. The problem is, I have lot of data and with loop it is VERY slow. I was always able to hide all items except, for example, last seven. But what I need is to hide everything and keep seven items, but not the last seven items. Plus, the data is growing every day, so I need something flexible and it must be based on date.

Example:

. -> lot of dates (from 2010)
.
11.5.2013
12.5.2013
13.5.2013
14.5.2013
15.5.2013
16.5.2013
17.5.2013
18.5.2013
19.5.2013
20.5.2013
.
. -> few more dates ınto the future

so what I need is to hide all items and based on current date, I need to keep seven (but not last seven items), so for example 12.5.2013 till 18.5.2013 must stay checked and all other will be hidden

Can anyone help me? Is there even any function to hide all items without loop? I know that in pivot table, it is not possible unmark everything, at least one item must be checked.

Thx for you ideas.