Terrific ! . I used the macro you suggested from http://www.contextures.com/xlPivot11.html#newcache and it does exactly what I need .

I was hoping there was a solution without macros (I'm reasonably competent but not totally fluent and for many if not most users using a macro to fix a problem is way beyond their skill level ... do you know if nwever versions ie 2010 / 2013 are the same ? )