View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
John Pivot Table John Pivot Table is offline
external usenet poster
 
Posts: 2
Default Pivot tables & Vlookups

I´m trying to link a vlookup to a Pivot table, the problem is that every time
I change a parameter in the report filter, the number of columns in the table
changes; which messes up my formulas.

Is there a way to lock it?