| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Dynamic range in Pivot table
Hello I have a named ranged and in the refer to is this formula
=OFFSET(Pivot!$A$1,0,0,COUNTA(Pivot!$A:$A),COUNTA( Pivot!$1:$1)) the problem is that it stops at rows 487 so everything ater row 487 is not included in the pivot table ? what's wrong with the formula? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using dynamic range to create pivot table | Excel Discussion (Misc queries) | |||
| Populate a table with a dynamic range | Excel Worksheet Functions | |||
| Dynamic Range in a Pivot Table | Excel Discussion (Misc queries) | |||
| Crate group of date, with Dynamic Range in pivot table not working | Excel Discussion (Misc queries) | |||
| Pivot Table - Dynamic Field | Excel Discussion (Misc queries) | |||
Threaded Mode
