The id value worked just find, but not so for the month part. Welcome Message to New users Spam Sample File VBA Code: Pivot Table Field Update Using Dropdown List Discussion in 'VBA Macros' started by jdppep, Feb 7, 2014. You may have to register before you can post: click the register link above to proceed. Compare Excel | Excel Templates | DownloaderXL Pro Finance Templates & Add-In Bundle | NeuroXL Predictor | Construction Estimating Merge Excel The Easy Way | Trading Add-ins For Excel
Unfortunately I am still receiving the same error message with both alternative examples you provided. Advanced Excel Integration XL-Dennis corner in the Excel-world OTHER STUFF DAVE HAWLEY FOUNDATION Newsletters Competitions HAV-A-CHAT Book Suggestions & Reviews Test Area Excel Development & Consultancy EXCEL SEARCH & RESOURCES Excel Any suggestions? with a . http://stackoverflow.com/questions/34817213/getting-unable-to-set-currentpage-property-of-pivotfield-class-error
Returns or sets the current page showing for the page field (valid only for page fields). This code creates a copy of the "SalesPivot" sheet for each Sales Rep whose name is included in the Rep field. The code I have is below. i am very grateful.
Share Share this post on Digg Del.icio.us Technorati Twitter Reply With Quote Mar 10th, 2011,05:20 AM #4 Andrew Poulsom MrExcel MVPModerator Join Date Jul 2002 Posts 73,092 Re: unable to set What would the code look like if strings were used instead of variables? In the debugger, accessing ActiveSheet.PivotTables("PivotTable2") works. Advanced Search Forum HELP FORUMS Excel General Error: unable to set currentpage property of the pivot field class Excel Training / Excel Dashboards Reports If this is your first visit, be
It exploits new functionality from Excel 2007, the PivotFilter object, so it will not work in Excel 2003 or earlier. Sub payment_look_up() Application.ScreenUpdating = False Vba Currentpage Multiple Items See our guidelines for contributing to VBA documentation. N(e(s(t))) a string How to explain the existence of just one religion? Join Now For immediate help use Live now!
No, create an account now. http://forum.powerpivotpro.com/forums/topic/error-when-updating-filter-via-vba/ LinkBack LinkBack URL About LinkBacks Bookmark & Share Digg this Thread!Add Thread to del.icio.usBookmark in TechnoratiTweet this thread Thread Tools Show Printable Version Display Linear Mode Switch to Hybrid Mode Run-time Error '1004' Unable To Set The Currentpage Property Of The Pivotfield Class Ozgrid is Not Associated With Microsoft. Field.currentpage = Newcat Error Is it possible to have more than one AD server with FSMO roles installed on it?
We are here to make you awesome in Excel. Programmers combine theory and practice: nothing works and they don’t know why Reply With Quote September 17th, 2012 #3 zilosoft View Profile View Forum Posts I agreed to these rules Join Excel links !!! The time now is 01:45 AM. Field.currentpage Error
It was because I was trying to reference the field without the PowerPivot field name. Not the answer you're looking for? Tom Author Posts Viewing 10 posts - 1 through 10 (of 10 total) You must be logged in to reply to this topic. When posting or responding to questions please remember our values at Chandoo.org are: Humility, Passion, Fun, Awesomeness, Simplicity, Sharing Remember that we have people here for whom English is not there
I appreciate any help I can get on this. This code is stored on the sheet module for the worksheet on which the pivot table is located. Members List Calendar Forum Rules Dashboard Commercial Services Advanced Search Forum Microsoft Office Application Help - Excel Help forum Excel Programming / VBA / Macros [SOLVED] PivotTable Pivot Fields CurrentPage To Pivotfilters.add Example Vba Remember Me?
Then, the best part of the PivotTable is when it comes to update any of its items, is a pane in the glass. February 1, 2016 at 8:14 pm #3224 straberiwineParticipant Started: 2Replies: 14Total: 16 I figured out the error above. Unable to set CurrentPage property of PivotField class". I tried updating directly (per Macro Recorder instructions) the value of the Please Login or Register to view this content.
Manual Sorting You can easily sort the pivot fields in the row or column areas, but there isn't a quick way to sort the report filter fields.