LS

I have macros in my workbooks to move date ranges on charts and to refresh a
pivot when clicking on the pivot tab.

How can I replicate the functionality best when moving to Excel 2007?

just switching the workbook from 2003 to 2007 diasables the macros.

A pondering Texas Tonie