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

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

Hi Friends, When i double click my Pivot table value a new sheet is appearing with the details. But all the amount columns are showing in date format. Can anybody help how to rectify the same.(value should show in Number format and date should be in date format) Plz help. Regards, Prabhu --