| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot Table as Source Range | Excel Discussion (Misc queries) | |||
| Pivot Table Range | Excel Worksheet Functions | |||
| Help Pivot Table Date Range | Excel Discussion (Misc queries) | |||
| Pivot Table Date Range | Excel Discussion (Misc queries) | |||
| Dynamic Range in a Pivot Table | Excel Discussion (Misc queries) | |||
Linear Mode
