Point being you need to create the Pivots in Compatibility Mode ... if they were created in XL2007 you can not convert them retrospectively.

Quote Originally Posted by mztexas
I would like for the pivot tables to update with the added data when refreshed but not sure how to do that either in 2003.
Use a Dynamic Named Range as the source for the Pivot (see link in sig. for more info) and/or use an appropriate VBA event to refresh the Pivot cache as when that data is altered.