$$Excel-Macros$$ Pivot Table data extract

2011-10-11 Thread Anil Bhange
Hi Expert, In Pivot table data details, when we double click on any value the details of those values extract from main database and another worksheet get prepared. In this process, new worksheet details (extracted one) by default extracted in "Table Format" and everytime we have to do "Conver

Re: $$Excel-Macros$$ Pivot Table data extract

2011-09-02 Thread Mahesh parab
>> ** ** >> >> *From:* excel-macros@googlegroups.com [mailto: >> excel-macros@googlegroups.com] *On Behalf Of *Shaik Waheed >> *Sent:* Friday, September 02, 2011 04:54 PM >> *To:* excel-macros@googlegroups.com >> *Subject:* Re: $$Excel-Macros$$ Pivot Tabl

Re: $$Excel-Macros$$ Pivot Table data extract

2011-09-02 Thread Shaik Waheed
matting. > > ** ** > > Regards,Anil Bhange > > IP Phone - 512320 | Mobile - 90290 32123 > > ** ** > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *Shaik Waheed > *Sent:* Friday, September 02, 2011 04

RE: $$Excel-Macros$$ Pivot Table data extract

2011-09-02 Thread Anil Bhange
rom: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Shaik Waheed Sent: Friday, September 02, 2011 04:54 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Pivot Table data extract Right Click on the pivot table, select Pivot Tabel Options, move to

Re: $$Excel-Macros$$ Pivot Table data extract

2011-09-02 Thread Shaik Waheed
Right Click on the pivot table, select Pivot Tabel Options, move to 'Data' tab and then Uncheck- "Enable Show Details". On Fri, Sep 2, 2011 at 4:44 PM, Anil Bhange < anil.bha...@tatacommunications.com> wrote: > Hi Expert, > > ** ** > > In Pivot table data details, when we double click on any

$$Excel-Macros$$ Pivot Table data extract

2011-09-02 Thread Anil Bhange
Hi Expert, In Pivot table data details, when we double click on any value the details of those values extract from main database and another worksheet get prepared. In this process, new worksheet details (extracted one) by default extracted in "Table Format" and everytime we have to do "Convert