Excel 2007 and refresh pivot table methodology
 

Hello,
I have moved from excel 2003 to 2007 and come with a question regarding the
way pivot tables refresh is handled. I have several pivot tables in different
sheet of the same workbook and all have the same data input range . The
question is that when I ask to refresh ONE pivot table excel will refresh ALL
pivot tables in all sheets having the SAME data range source. It was not the
case in 2003 and I'd like to ONLY refresh one specific table , is there a
possibility to do that ?
Thanks,
Bernard