Pivot Table Range Extension.

  • Thread starter Mattlynn via OfficeKB.com
  • Start date
M

Mattlynn via OfficeKB.com

Hi

Can you extend the range on more than one pivot table at a time.
I foolishly created a model with obout 50 pivots, to row 6000, but realise i
should have put 60000

Can anyone help.

Many Thanks
Matt
 
B

Bernie Deitrick

Matt,

If they are all based in the same range, select the data rows 6001 through
60000, then shift-drag them to row 5999, to insert them into the database.
All the pivots shuold update then.

HTH,
Bernie
MS Excel MVP
 
M

Mattlynn via OfficeKB.com

Hi Bernie
Sorry - but i am a bit confused on how i can drag that many rows ibnto a
space the 10th of the size.
Can you please explain further.
Many Thanks
Matt



Bernie said:
Matt,

If they are all based in the same range, select the data rows 6001 through
60000, then shift-drag them to row 5999, to insert them into the database.
All the pivots shuold update then.

HTH,
Bernie
MS Excel MVP
Hi
Click to expand...
[quoted text clipped - 7 lines]
Many Thanks
Matt
Click to expand...
Click to expand...
 
B

Bernie Deitrick

Holding down the shift key when you drag a selection does an insert and not a replacement. Give it
a try with a small area so you can see how it works. It is the same as selecting the range, pressing
Ctrl-X (or Cutting the range), and then using Insert / Cut Cells after selecting where to insert
them. Sorry for being so cryptic.

HTH,
Bernie
MS Excel MVP


Mattlynn via OfficeKB.com said:
Hi Bernie
Sorry - but i am a bit confused on how i can drag that many rows ibnto a
space the 10th of the size.
Can you please explain further.
Many Thanks
Matt



Bernie said:
Matt,

If they are all based in the same range, select the data rows 6001 through
60000, then shift-drag them to row 5999, to insert them into the database.
All the pivots shuold update then.

HTH,
Bernie
MS Excel MVP
Hi
Click to expand...
[quoted text clipped - 7 lines]
Many Thanks
Matt
Click to expand...
Click to expand...
Click to expand...
 
M

Mattlynn via OfficeKB.com

Wicked - Thanks very much - all working fine now - thats is just great....

Thanks
Matt




Bernie said:
Holding down the shift key when you drag a selection does an insert and not a replacement. Give it
a try with a small area so you can see how it works. It is the same as selecting the range, pressing
Ctrl-X (or Cutting the range), and then using Insert / Cut Cells after selecting where to insert
them. Sorry for being so cryptic.

HTH,
Bernie
MS Excel MVP
Hi Bernie
Sorry - but i am a bit confused on how i can drag that many rows ibnto a
Click to expand...
[quoted text clipped - 18 lines]
Click to expand...
 
Top