Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
consolidate data, dynamic ranges
Using the detail on the contextures website to overcome the limiations of
pivot tables, I came upon another issue as usual. To explain further, I have data that filled through an Oracle query. The range of data changes continuously, so I was using a dynamic range(using instructions from the Contextures website). My dillema is that when I use the dyamic range, the dyamanic range names don't show up as tables when I follow the instructions for creating a pivot table based using an external data source. It will bring up all of the other named ranges, but will not show the dynamic ranges. Is there a way around this? Appreciate any help with this issue. http://www.contextures.com/xlPivot08.html#Limitations http://www.contextures.com/xlPivot01.html |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
consolidate data, dynamic ranges
No way to make them show for selection. That doesn't mean they aren't
available. Just type them the source range dialog box. -- Regards, Tom Ogilvy "Excel GuRu" wrote in message ... Using the detail on the contextures website to overcome the limiations of pivot tables, I came upon another issue as usual. To explain further, I have data that filled through an Oracle query. The range of data changes continuously, so I was using a dynamic range(using instructions from the Contextures website). My dillema is that when I use the dyamic range, the dyamanic range names don't show up as tables when I follow the instructions for creating a pivot table based using an external data source. It will bring up all of the other named ranges, but will not show the dynamic ranges. Is there a way around this? Appreciate any help with this issue. http://www.contextures.com/xlPivot08.html#Limitations http://www.contextures.com/xlPivot01.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dynamic data ranges | Excel Worksheet Functions | |||
How do I consolidate data into ranges | Excel Discussion (Misc queries) | |||
data validation, dynamic ranges | Excel Worksheet Functions | |||
Data Validation and Dynamic Ranges | Excel Discussion (Misc queries) | |||
Dynamic data ranges and Charts | Excel Programming |