Sorry.. just to reframe the question... I wanted all the details but not in "Table" format, because there I again need to convert the table to Range
I want the information in normal format without any formatting. 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: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 'Data' tab and then Uncheck- "Enable Show Details". On Fri, Sep 2, 2011 at 4:44 PM, Anil Bhange <anil.bha...@tatacommunications.com<mailto:anil.bha...@tatacommunications.com>> wrote: 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 to Range" Is there any shortcut where I don't get these details in Table format and will get in the normal data details. Anil Bhange Assistant Manager Financial Reporting & Compliance, TATA Communications Ltd. VSB, Fort, Mumbai - 400 001, India ' Desk : + 91 22 6659 2320<tel:%2B%2091%2022%206659%202320> | IP Phone : 51 2320 | Mobile :+ 91 90290 32123<tel:%2B%2091%2090290%2032123> anil.bha...@tatacommunications.com<mailto:anil.bha...@tatacommunications.com> -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com<http://www.excel-macros.blogspot.com/> 4. Learn VBA Macros at http://www.quickvba.blogspot.com<http://www.quickvba.blogspot.com/> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com<http://exceldailytip.blogspot.com/> To post to this group, send email to excel-macros@googlegroups.com<mailto:excel-macros@googlegroups.com> <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com<mailto:excel-macros@googlegroups.com> <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
