Pivot Table Range Extension.
 

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

--
Matt Lynn

Message posted via http://www.officekb.com

Pivot Table Range Extension.
 

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


"Mattlynn via OfficeKB.com" <u44078@uwe wrote in message
news:89afc04df54db@uwe...
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

--
Matt Lynn

Message posted via http://www.officekb.com

Pivot Table Range Extension.
 

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 Deitrick wrote:
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

[quoted text clipped - 7 lines]
Many Thanks
Matt

--
Matt Lynn

Message posted via http://www.officekb.com

Pivot Table Range Extension.
 

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" <u44078@uwe wrote in message news:89b9da08fae31@uwe...
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 Deitrick wrote:
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

[quoted text clipped - 7 lines]
Many Thanks
Matt

--
Matt Lynn

Message posted via http://www.officekb.com

Pivot Table Range Extension.
 

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

Thanks
Matt




Bernie Deitrick wrote:
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
[quoted text clipped - 18 lines]
Many Thanks
Matt

--
Matt Lynn

Message posted via http://www.officekb.com