I work for a large company and some folks are on Excel 2007, while others, like myself, remain with 2003. My problem is that I have an Excel 2007 file with a pivot table. The data it is based on is resident in the file, but I am unable to update the pivot. I built several macros for hte file, which run alright and I can update teh data---but not the pivot--the refresh option is grayed out and I can't even get to the layout or the field dropdowns in the pivot. What can I do? 
