Re: $$Excel-Macros$$ **Pivot Table Doubt**

Hi Shaik, When i Uncheck- "Enable Show Details, Pivot table is not expanding with the details. Normally if i double click the value of the Pivot table automaticly separate sheet will appear but after unclick the Enable Show Details details not appearing. Can you plz help. Prabhu -- ---

Re: $$Excel-Macros$$ **Pivot Table Doubt**

Right Click on the pivot table, select Pivot Tabel Options, move to 'Data' tab and then Uncheck- "Enable Show Details". For the date format i think its working fine in both rows n columns. On Thu, Sep 1, 2011 at 10:18 PM, Prabhu wrote: > Hi Friends, > I think topic got changed. Actually i have a

Re: $$Excel-Macros$$ **Pivot Table Doubt**

Hi Friends, I think topic got changed. Actually i have attached a pivot file, when is double click the numbers a new sheet is appearing. But in that sheet all numbers are shows in date format!!!. Plz help to know the reason and how i can get Numbers in numbers format and date in date format??

Re: $$Excel-Macros$$ **Pivot Table Doubt**

Hi, Write the correct problem in subject section, like "pivot, conditional formatting, lookup function,". and then elaborate the problem as clearly as u can, and also if possible attach the sample sheet. Regards, Waheed. On Thu, Sep 1, 2011 at 7:26 PM, Shankar Bheema wrote: > Sir, > I totally co

Re: $$Excel-Macros$$ **Pivot Table Doubt**

Sir, I totally confused to put my query in group ID. pls tell me the procedure On Thu, Sep 1, 2011 at 5:58 PM, Shaik Waheed wrote: > Plz put all ur queries n replies to the group id. So that everyone > will try n learn, that is wht our objective. > > Thnx > Waheed. > > On Thu, Sep 1, 2011 at 4:

Re: $$Excel-Macros$$ **Pivot Table Doubt**

*If two geographical data match in two sheets, then add/copy/replicate unique id/code* Hi guys, this is my problem. I have a geographical data (divided into four colums per REGION, PROVINCE, MUNICIPALITY/TOWN, and BARANGAY/STREET) in one sheet. This sheet contains a UNIQUE GEOGRAPHICAL CODE that

Re: $$Excel-Macros$$ **Pivot Table Doubt**

Plz put all ur queries n replies to the group id. So that everyone will try n learn, that is wht our objective. Thnx Waheed. On Thu, Sep 1, 2011 at 4:47 PM, John Alliage Tinio Morales wrote: > Thank you very much! > > Hope we could get in touch soon for future problems on Excel. Thank you! > > O

Re: $$Excel-Macros$$ **Pivot Table Doubt**

Hi, Right Click on the pivot table, select Pivot Tabel Options, move to 'Data' tab and then Uncheck- "Enable Show Details". For the date format i think its working fine in both rows n columns. Regards, Waheed. On Thu, Sep 1, 2011 at 7:55 AM, Prabhu wrote: > HI All, > Plz find the pivot table sh

Re: $$Excel-Macros$$ **Pivot Table Doubt**

HI All, Plz find the pivot table sheet. kindly help. Regards, Prabhu -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Li

Re: $$Excel-Macros$$ **Pivot Table Doubt**

Hi Prabhu, Send send some sample data with pivot... *Best Regards,* *Venkat * *Chennai* *My Linked in profile * On Wed, Aug 31, 2011 at 12:28 PM, Prabhu wrote: > Hi Friends, > > When i double click my Pivot table value a new sheet is appearin

Re: $$Excel-Macros$$ **Pivot Table Doubt**

Can you post the pivoted file plz ? Thanks Prasad Sent from BlackBerry® on Airtel -Original Message- From: Prabhu Sender: excel-macros@googlegroups.com Date: Wed, 31 Aug 2011 12:28:10 To: Reply-To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ **Pivot Table Doubt** Hi Friend