Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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 01:59 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"