No announcements
Found 2914640 threads
-
1 VotesHow to save power pivot table as regular table?
then hand off the updated reports as regular Excel tables without power pivot tables. What's the best way to do this for large ...Answered | 1 Replies | 1195 Views | Created by Phar1402 - Thursday, August 23, 2018 6:14 PM | Last reply by willson yuan - Friday, August 24, 2018 3:15 AM
-
0 Votes
controling access to dimensions and measures in pivot table using cube as data source
I have a cube with a role defined for a group of users that restricts access to some dimension values. When one of the users in the group accesses the cube as ...Answered | 4 Replies | 4096 Views | Created by rpfinn - Wednesday, November 30, 2011 3:56 PM | Last reply by rpfinn - Friday, December 2, 2011 2:17 PM -
0 Votes
Change Pivot table Data Source Programatically
this sheet as source data for pivot table? Any help is ...Answered | 1 Replies | 4615 Views | Created by Chas484 - Friday, June 21, 2013 6:54 PM | Last reply by Jason Dot Wang - Tuesday, June 25, 2013 2:33 AM -
1 Votes
Use VBA to programmatically select filters for a pivot table
I have a pivot table (PvHandle) one one sheet (Pivot) and 2 cells (o8, u1) on another sheet (Control) that I would like to use to filter the ...Answered | 1 Replies | 19561 Views | Created by Qaspec - Monday, September 12, 2011 8:30 PM | Last reply by danishani - Tuesday, September 13, 2011 5:15 AM -
0 Votes
Sending Pivot Table in access to Outlook
Hi If you are wanting to paste the Pivot table directly from Access 2003 or below, into the body of a mail messageAnswered | 2 Replies | 5198 Views | Created by Michie23 - Friday, August 15, 2008 3:11 PM | Last reply by ADG - Saturday, August 16, 2008 3:02 PM -
0 Votes
Excel 2007 PIVOT as data source
Hi, We have a excel 2007 file with a Pivot Table in it. We would like to use the same as data source (But all ...Answered | 3 Replies | 5452 Views | Created by kart - Friday, January 18, 2008 11:16 PM | Last reply by jwelch - Tuesday, January 22, 2008 4:40 AM -
0 Votes
Migrating Ms Access VBA to VB.NET 2005
Is it possible to migrate Ms Access VBA to Visual Basic.NET using Visual studio 2005 Tools for Office? Tell me the solution ...Answered | 1 Replies | 3656 Views | Created by SanthoshK - Monday, April 16, 2007 11:07 AM | Last reply by Christin Boyd - Tuesday, May 1, 2007 11:26 PM -
0 Votes
Pivot Table VBA in SAS
Hello DRodNor1, Welcome to MSDN Forum. I have moved your thread to VBA forum as Rudedog2 suggested where you may get more ...Answered | 6 Replies | 6281 Views | Created by DRodNor1 - Tuesday, November 2, 2010 10:26 PM | Last reply by DRodNor1 - Friday, November 5, 2010 2:57 PM -
3 Votes
VBA to defer layout update for a PowerPivot Pivot Table
fields for a pivot table on a button click. I've got this working but it is slow as the pivot table seems to refresh after ...Answered | 2 Replies | 2235 Views | Created by VivDev - Monday, December 7, 2015 11:09 AM | Last reply by VivDev - Tuesday, December 8, 2015 11:11 AM -
0 Votes
Adding Access 2007 query as Pivot Table in Excel 2007
As a work-around, simply create a query table using the same Access Query. Place the resultset in a hidden worksheet. Then do your pivot from that worksheet with ...Answered | 1 Replies | 2427 Views | Created by SCP1234 - Wednesday, September 19, 2012 9:34 PM | Last reply by Syswizard - Thursday, September 20, 2012 5:20 PM -
0 Votes
Exporting Access Pivot table to Excel
If you have MS Access 2007 and Excel 2007 or greater, you can create the pivot table in an Access query, then export it using ...Answered | 7 Replies | 34976 Views | Created by Ankit.Rana - Saturday, July 23, 2011 7:04 AM | Last reply by Anuj1 - Thursday, August 15, 2013 11:25 AM -
0 Votes
Access query with function into Excel as pivot table
query with function into Excel as pivot table I'm trying to bring an Access query, which has a function ...Answered | 5 Replies | 7299 Views | Created by merlynsdad - Thursday, January 6, 2011 2:19 PM | Last reply by JonBuoy05 - Wednesday, March 6, 2013 11:39 AM -
0 Votes
Two pivot table fields lists - using access vba
Hi, I am create a pivot table from access since i have been unable to create a vba code to save the pivot table from ...Answered | 1 Replies | 279 Views | Created by Legzen34 - Wednesday, January 11, 2017 10:57 PM | Last reply by Deepak Saradkumar Panchal - Thursday, January 12, 2017 3:28 AM -
0 Votes
Access 2007 Pivot Chart View and Pivot Table View Unable
Hi Access Database People I have Access 2007 on my computer and as the view of Pivot Table and Pivot Chart are for no ...Answered | 4 Replies | 3778 Views | Created by Lavender23 - Thursday, March 22, 2012 11:56 PM | Last reply by Lavender23 - Thursday, April 19, 2012 3:56 AM -
2 Votes
Connecting to MS Access MDB as an external data source
That is a bad decision. MSFT has been trying to ditch Access for a long time. More because they want to make more money selling SQL Server. MS ...Answered | 8 Replies | 5930 Views | Created by Daniel Schunk - Thursday, August 4, 2011 1:27 PM | Last reply by Henry Wrage - Thursday, May 10, 2012 7:10 AM -
0 Votes
MTM Web Access Pivot Table
For a team of 15 testers, I would like to create a pivot table on the front-end UI -MTM web access test management. If I choose 'Tester' ...Answered | 1 Replies | 284 Views | Created by Pre12 - Tuesday, May 17, 2016 6:59 PM | Last reply by Starian chen - Wednesday, May 18, 2016 8:00 AM -
0 Votes
Pivot table for WPF
There is one Pivot Table - which is not in WPF but as an ASP .Net Web Control. Have a look here.Answered | 2 Replies | 7217 Views | Created by PivotWPF - Wednesday, March 4, 2009 5:44 PM | Last reply by jeganinfo - Wednesday, May 25, 2011 6:16 PM -
0 Votes
VBA create Pivot table by double click on existing Pivot table field
CreateAnotherPivotTable() 'Create the Pivot Table here End Sub For how to create Pivot Table with VBA code, please ...Answered | 2 Replies | 1563 Views | Created by Wilson Wu - Friday, November 21, 2014 5:43 AM | Last reply by Wilson Wu - Friday, November 28, 2014 6:34 AM -
1 Votes
Refresh Pivot Table Ranges with VBA
Hi Edward, Thank you for your advice. During recording a macro, it appeared that pivot table slicers didn't allow to run the ...Answered | 5 Replies | 3665 Views | Created by Iaroslav Rybchuk - Wednesday, July 13, 2016 6:35 AM | Last reply by Iaroslav Rybchuk - Tuesday, July 19, 2016 8:18 AM -
0 Votes
Append Query VBA MS Access
> I have a sql append query that I created using the query builder in > MS Access. I want to include the query in VBA ...Answered | 1 Replies | 3237 Views | Created by IshNish - Tuesday, July 3, 2012 8:05 PM | Last reply by Karl Donaubauer - Tuesday, July 3, 2012 9:41 PM
No announcements
