Posted to microsoft.public.excel.programming

Rodolfo[_2_] Rodolfo[_2_] is offline

external usenet poster

Posts: 1

Pivot Table - ShowDetail property using VBA

Hi all,
a double click on a "data" pivot item creates a new sheet containing all the
related rows. Instead of this I need to have the VBA code able to obtain the
same result in an array (without the creation of the new sheet). The pivot
table is connected to an external source (Oracle db). Many thanks in advance.
Kind regards, Rodolfo

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
PivotTable ShowDetail not into ActiveWorkbook	baldmosher	Excel Programming	1	July 11th 09 06:46 PM
ShowDetail on PivotTable does not work in VBA	Ray C	Excel Programming	0	May 21st 09 04:13 PM
Excel Pivot Table, Property Fields	Jim Plant	Excel Discussion (Misc queries)	0	February 27th 07 02:59 PM
ShowDetail on PivotField rather than PivotItem??	[email protected]	Excel Programming	0	September 25th 06 12:41 AM
Pivot table....building arguments for the .RowField property	sclark	Excel Programming	0	January 21st 04 05:31 PM

All times are GMT +1. The time now is 06:35 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us