Hi,
It depends upon which version you are using. Have a look at the page : <http://support.microsoft.com/kb/287736/en-us> http://support.microsoft.com/kb/287736/en-us Regards. Daniel De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De la part de Anil Bhange Envoyé : vendredi 25 mars 2011 11:48 À : excel-macros@googlegroups.com Objet : $$Excel-Macros$$ Don't want GETPIVOTDATA formula Hi Expert, Wanted your help.. while working on Pivot table and using formula with Pivot data by default we are “GETPIVOTDATA” formula and we can use this flexible way. So everytime we need to put manually like “D5” given below and can use as variable. Is there any VBA Code which I can save in personal.xlsx which will not give me formula “GETPIVOTDATA”. I found it interesting… and your suggestions will help many users Please try this and give us soultions.. Thanks & Regards, Anil Bhange IP - 512320 -- ---------------------------------------------------------------------------- ------ 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> http://exceldailytip.blogspot.com To post to this group, send email to <mailto:excel-macros@googlegroups.com> excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link <http://www.facebook.com/discussexcel> 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
<<image001.png>>
