Re: $$Excel-Macros$$ Pivot table problem

2011-02-01 Thread Deepak Rawat
20 | Mobile - 90290 32123 > > > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *Deepak Rawat > *Sent:* Tuesday, February 01, 2011 11:11 AM > *To:* excel-macros@googlegroups.com > *Subject:* $$Excel-Macros$$ Pivot table probl

RE: $$Excel-Macros$$ Pivot table problem

2011-01-31 Thread Anil Bhange
Subject: $$Excel-Macros$$ Pivot table problem Hi All I have a problem in fetching the data from the raw data, pls suggest the best way. Problem file is attached. There are two worksheets, 1st one is Raw Data & 2nd one is Required data. Regards, De

$$Excel-Macros$$ Pivot table problem

2011-01-31 Thread Deepak Rawat
Hi All I have a problem in fetching the data from the raw data, pls suggest the best way. Problem file is attached. There are two worksheets, 1st one is Raw Data & 2nd one is Required data. Regards, Deepak -- -- Som

Re: $$Excel-Macros$$ Pivot table problem

2010-08-11 Thread Deepak Rawat
Thanx!! Flemos On Sat, Aug 7, 2010 at 2:50 PM, Deepak Rawat wrote: > Hi all > > I have attached a file containg pivot table with some data. > I have two qurries > 1. I want to put a foruma next to pivot table and want to copy and paste > all formula to all rows but its taking freezing cells by

Re: $$Excel-Macros$$ Pivot table problem

2010-08-08 Thread Fabio Lemos
Hi Deepak Rawat, You can create a calculated pivot field. it´s possible by accessing Options tab (when selected a pivot table cell) and click on formulas button. I´ve created the formula in the attached file. Regards, FLemos. 2010/8/7 Deepak Rawat > Hi all > > I have attached a file containg

$$Excel-Macros$$ Pivot table problem

2010-08-07 Thread Deepak Rawat
Hi all I have attached a file containg pivot table with some data. I have two qurries 1. I want to put a foruma next to pivot table and want to copy and paste all formula to all rows but its taking freezing cells by default. If data quatity is high than how could i put the formula in all cells.

Re: $$Excel-Macros$$ Pivot table problem Pls help me

2010-07-27 Thread Venkatesh Narla
Thanks a Lot I have done that.. On Tue, Jul 27, 2010 at 6:32 PM, Venkatesh Narla wrote: > Dear All, > I have problem in 2007 Excel Pivot table > Pls find the Pictures. > > > Best Regards, > Venkatesh narla, > 9886058917 > > -- >

Re: $$Excel-Macros$$ Pivot table problem Pls help me

2010-07-27 Thread praveen kumar
Hi Venkatesh, Solution for your problem. Right click on pivot - Pivot Table option - Display - classic pivot table option(check this option). Let me know if it works On Tue, Jul 27, 2010 at 6:32 PM, Venkatesh Narla wrote: > Dear All, > I have problem in 2007 Excel Pivot table > Pls find the P

Re: $$Excel-Macros$$ Pivot table problem Pls help me

2010-07-27 Thread kaza deepu
hey venkatesh, both are one and the same wt is your excat problam in that. Can u please eleabrate? or give me the sample file. On 7/27/10, Venkatesh Narla wrote: > > Dear All, > I have problem in 2007 Excel Pivot table > Pls find the Pictures. > > > Best Regards, > Venkatesh narla, > 9886058917

Re: $$Excel-Macros$$ Pivot table problem Pls help me

2010-07-27 Thread anil panchal
Hi Venkatesh, Please right click on Pivot Table & Cilcik On Pivot Table Options Then Cilck on display & Cick On Classic Pivot Table layout & Ok Thanks & Regards Anil Kumar On Tue, Jul 27, 2010 at 6:32 PM, Venkatesh Narla wrote: > Dear All, > I have problem in 2007 Excel Pivot table > Pls fi