No announcements
Found 2921068 threads
-
0 VotesVBA to set MS Access as Source for Pivot Table
, I was wondering if there was a way to set my source as an Ms Access Table so I can bypass the 65k row limit? Has anyone has success ...Unanswered | 1 Replies | 478 Views | Created by cdtakacs1 - Thursday, February 27, 2020 9:11 AM | Last reply by Hans Vogelaar MVP - Thursday, February 27, 2020 10:04 AM
-
0 Votes
VB Script to set MS Access as Source for Pivot Table
However, I was wondering if there was a way to set my source as an Ms Access Table so I can bypass the 65k ... -
0 Votes
MS ACCESS PIVOT TABLE ISSUE
Vengatesan -- You have erroneously posted your MS Access question in a public user forum dedicated to questions about Project Server, an enterprise ...Unanswered | 2 Replies | 852 Views | Created by Vengatesan - Thursday, March 10, 2016 12:12 PM | Last reply by Dale Howard [MVP] - Thursday, March 10, 2016 8:24 PM -
1 Votes
Changing the Data Source for a pivot table using VBA
Hi JT, Welcome to MSDN forum. A quick way to check the code is recording a macro to get VBA code. I tried ...Answered | 1 Replies | 4975 Views | Created by Dough54 - Wednesday, March 26, 2014 4:41 PM | Last reply by George Hua - Thursday, March 27, 2014 5:28 AM -
0 Votes
Setting data source programmatically for Pivot table
Hi, Does anyone know if a worksheet has a Pivot table, how can I set it data source programmatically via VSTO? Is there any sample ...Answered | 2 Replies | 6120 Views | Created by Watcherq - Wednesday, November 16, 2005 9:54 AM | Last reply by Paul Stubbs (Codetonium) - Wednesday, November 23, 2005 6:30 PM -
0 Votes
(Excel Pivot table) Data source as xlConsolidation
Hi Quist Thanks for the reply. but it doesn't help at all. I know how to get a list object as ...Unanswered | 2 Replies | 3272 Views | Created by SQLMa - Tuesday, February 5, 2013 4:54 AM | Last reply by SQLMa - Thursday, February 7, 2013 10:21 PM -
0 Votes
refresh Pivot table with New Data Source via VBA
best approach? I want to make sure that all the tables are being updated with the correct information and new row source. data is ...Unanswered | 1 Replies | 972 Views | Created by ellis Wa - Monday, March 14, 2016 3:16 PM | Last reply by ellis Wa - Monday, March 14, 2016 4:42 PM -
0 Votes
Pivot Table VBA Filter
Thanks for the reply Fei, Just to clear things up I want to set my pivot filter to a field called "Pivot ...Answered | 3 Replies | 1622 Views | Created by Blue_Dan - Thursday, February 5, 2015 4:33 PM | Last reply by Fei Xue - Monday, February 9, 2015 6:34 AM -
0 Votes
VBA vs regular pivot table?
ALWAYS set the pivot table ManualUpdate property to true before applying a new filter.Answered | 1 Replies | 670 Views | Created by Keith Ruck - Friday, December 5, 2014 12:09 AM | Last reply by Syswizard - Friday, December 5, 2014 4:40 PM -
0 Votes
Pivot Table VBA Filters
the VBA will filter all pivot tables in the worksheet to show a filter on Spain Country and Cars Product Type. Can someone help with how to adapt ...Answered | 2 Replies | 1084 Views | Created by InzieBear - Wednesday, August 31, 2016 11:38 AM | Last reply by David_JunFeng - Thursday, September 1, 2016 3:10 AM -
0 Votes
MS Excel Pivot Table
code. So, does anyone have an idiots guide to writing (NOT just using) a PivotTable Wizard in VBA for Excel 2000 onwards? I would need ...Unanswered | 1 Replies | 1564 Views | Created by VirtualPerson2012 - Friday, November 16, 2012 4:26 AM | Last reply by Ed Ferrero - Wednesday, November 21, 2012 6:24 AM -
0 Votes
Pivot Table VBA Correction
say the way I put it, but when I do the change of the year or the month the vba also changes the region to be the same as the one pivot ...Unanswered | 8 Replies | 2664 Views | Created by GjergjiPro - Friday, October 5, 2012 3:51 PM | Last reply by Quist Zhang - Thursday, October 18, 2012 10:01 AM -
0 Votes
pivot table loosing decimals (vba)
I declared the field type in the database anything other than currency or number. I tested it with Access Database. For the Number field, I set the field size ...Answered | 1 Replies | 4567 Views | Created by MistyTor - Monday, August 22, 2011 7:33 PM | Last reply by Siddharth Rout - Monday, August 22, 2011 11:28 PM -
0 Votes
VBA - Setting Pivot Chart height at pivot table refresh
rows in the graph. I have written following VBA code which gets the number of pivot table rows. Now I want to set the size of the pivot chart ... -
1 Votes
Diplsay Pivot table source data
Can you check if the following is getting any close to your requirement: Sub CheckSourceConnection() Dim pvtCache ...Answered | 2 Replies | 3538 Views | Created by hombre_joven - Wednesday, July 1, 2009 10:53 AM | Last reply by hombre_joven - Saturday, July 4, 2009 8:41 PM -
0 Votes
Change Table Source for Existing Power Pivot Table
for FY20. Then I created a copy of the Table and I like to change it to FY19 Data. The Power Query Connection for FY19 already ... -
0 Votes
VBA Pivot table
Hi Steve Rob, I'll move your thread to from Visual Basic forum to Visual Basic for Application forum since your question is related to ...Unanswered | 2 Replies | 3327 Views | Created by Steve Rob - Tuesday, July 7, 2009 12:29 PM | Last reply by Yichun_Feng - Thursday, July 9, 2009 6:56 AM -
0 Votes
Excel VBA Pivot Table Filter
Do you mean like loop through all Pivot Filters and set the filter to property ID or all items? Maybe this will guide you in the right direction ...Answered | 1 Replies | 909 Views | Created by Keith D P - Friday, September 26, 2014 8:48 PM | Last reply by danishani - Friday, September 26, 2014 10:40 PM -
0 Votes
Pivot Table VBA - Data Field - Original (source) field name
I have created simple pivot table (no OLAP) from excel data. I have data fields as CY (Current Year) and NY (Next Year). Once Pivot Table ...Unanswered | 1 Replies | 4848 Views | Created by hbgpausa0 - Tuesday, April 22, 2008 2:28 PM | Last reply by hbgpausa0 - Tuesday, April 22, 2008 3:24 PM -
0 Votes
Re: Pivot Table Source Data
(wsRL.Cells(2, 1), wsRL.Cells(lastRow - 1, lastCol)) Set PTCache = ActiveWorkbook.PivotCaches.Add(SourceType:=xlDatabase, SourceData:=pivotRng) ' ...Unanswered | 1 Replies | 4057 Views | Created by Alicia May - Thursday, June 23, 2011 4:48 AM | Last reply by mogulman52 - Thursday, June 23, 2011 11:44 AM - Items 1 to 20 of 2921068 Next ›
No announcements
