You could also set the Default Table Style for the workbook containing the pivot table as one which contains no formatting, then double clicking on an item in the pivot table would still create a table, but it would have no formatting.
On Sep 2, 12:14 pm, Anil Bhange <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 > | IP Phone : 51 2320 | Mobile :+ 91 90290 32123 > > 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 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
