paste reletive reference in pivot table
 

We just upgraded from Excel 2000 to 2003. My co-workder has a pivot table
and now when he goes to copy and paste a formula into his pivot table it does
not use relative reference. However, it works like it is suppose to when not
using a pivot table. Is this correct for 2003 or am I missing a setting
somewhere.

Renee