PivotTable

  • Thread starter Thread starter J Le Brasseur
  • Start date Start date
J

J Le Brasseur

Hi,
Is it possible in some way to fix the structure of a pivot table in excel or
even in Access so that I have a familiar layout even though the data may
vary from differences in the data. By implication, thefore to show empty
colums/rows somehow. This is very important to my situation.
 
I couldn't think of any way of changing the format of the
pivet tables.

However to solve your problem, you could have your own
format in a different sheet (within the same file) and
link the pivet table using VLOOKUP( formula to get the
numbers to the right place.

You could use refresh data to update your values.

Regards
 
Hi

I had a similar problem a couple of weeks ago. The route I took was to use a
raft of SUMPRODUCT formulas to replace three pivot tables. The file went
from 16MB down to under 4MB. It depends on how your data is laid out as to
how it would be best to do the job, however, but I suggest you have a look
at the possibility of this rather than trying to fix a pivot table
structure.

Andy.
 
Back
Top