View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
[email protected] william.mcseveney@ntlworld.com is offline
external usenet poster
 
Posts: 14
Default Pivot Table - Calculated Item Formula

Hi

I have a pivot table which includes 3 Calculated Item formulas. Every
day the pivot table data will change so the number of columns in the
pivot table varies. I want to ensure that the 3 calculated item
formulas always stay in the same columns (as I have vlookups running
from these columns)

How do I ensure this happens.

Thanks

W