View Single Post
  #1   Report Post  
kalz
 
Posts: n/a
Default keep pivot table layout

Hello,

I made a pivot table with ranges from multiple worksheets. However, the
layout has become different. It now turns out Rows, columns, etc., instead of
my original ones, colour , country, styles, etc. I wanna have the original
ones as it also provides filter function even in pivot table, not the ones
which are static with wrong data. Pls help, if u have the solution or any
alternatives.

Thx!