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