Have two pivottables working off the same Excel data file on the same 'tab' in a Pivottable worksheet. One is on top of the other. It seems that if my 'top' pivot grows in detail (# of rows increase), then it tries to overwrite my bottom pivot. I would prefer it just push my bottom pivot down further down the spreadsheet. Is there a way to accomplish this?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Pivottable formatting
- Thread starter gc6294
- Start date
only with VBA or by having the pivot tables side by side rather than top to bottom (will still give you issues though if your data expands sideways)
Even using VBA it will be pretty hard to do this - you would probably need to recreate the pivottable from scratch each time dependant on the no. of rows taken up by the initial pivottable...
Rgds, Geoff
We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.
Please read FAQ222-2244 before you ask a question
Even using VBA it will be pretty hard to do this - you would probably need to recreate the pivottable from scratch each time dependant on the no. of rows taken up by the initial pivottable...
Rgds, Geoff
We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.
Please read FAQ222-2244 before you ask a question
- Status
Similar threads
