PivotTable

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.
 
J

jaya

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
 
A

Andy B

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top