No announcements
Found 1440062 threads
-
2 VotesAutomatically copy Pivot table info into excel table
Hi siddiqali, What do you mean with "automatically"?Answered | 2 Replies | 1489 Views | Created by SP Assest - Friday, June 20, 2014 10:57 AM | Last reply by Gerhard Brueckl - Tuesday, June 24, 2014 7:51 AM
-
4 Votes
Download power pivot table INTO excel
Hi Alex, If you're using Excel 2013 or later, you can try using the Linkback table feature.Answered | 3 Replies | 1499 Views | Created by AlexMartini - Thursday, October 20, 2016 5:36 PM | Last reply by Michael Amadi - Thursday, November 24, 2016 2:17 PM -
0 Votes
Excel table (non-pivot) based on PowerPivot table
Hi, There is a feature called linked tables in power pivot for excel.Answered | 5 Replies | 9265 Views | Created by roto-tom - Thursday, February 2, 2012 8:44 PM | Last reply by Javier Guillen - Saturday, February 4, 2012 10:41 PM -
0 Votes
Convert a Pivot Table to a Table?
> Paste Values, when copy pasting the Pivot table into a new sheet.Answered | 3 Replies | 12281 Views | Created by JoshUSCB - Thursday, June 30, 2011 2:49 PM | Last reply by Prasanna Adavi - Thursday, June 30, 2011 8:31 PM -
0 Votes
excel Pivot table querying 2 sql tables (1 temp table)
The stores procedure is- various details are imported to sql server from Excel then executes various code- then refreshs a pivot table.Answered | 6 Replies | 773 Views | Created by David_1234 - Thursday, September 22, 2016 12:20 PM | Last reply by Felipe Costa Gualberto - Saturday, September 24, 2016 4:12 PM -
0 Votes
PIvot tables in excel
I want to save this excel generated report to the server and then make the client inport this file as an attachment.Answered | 6 Replies | 4580 Views | Created by akhilesh_daprofessional - Tuesday, April 28, 2009 5:56 AM | Last reply by akhilesh_daprofessional - Monday, May 4, 2009 10:45 AM -
0 Votes
Pivot Table in Excel Services
For complex authoring and ad-hoc data analysis, the best tool is still the desktop version of Excel.Answered | 2 Replies | 11140 Views | Created by pryank rohilla - Tuesday, April 27, 2010 3:01 PM | Last reply by Anthony Valey - MSFT - Wednesday, April 28, 2010 6:34 PM -
0 Votes
Excel Chart Updating with Pivot table
Hi Grant I have done following steps to resolve the issue, hope it will work for you as well: 1) I have a Pivot Table and Pivot ...Answered | 7 Replies | 18147 Views | Created by GS80 - Tuesday, March 6, 2007 9:29 AM | Last reply by Hussain Ali - Thursday, October 1, 2009 10:23 AM -
0 Votes
Prefilter dimension for Excel pivot table
Join the dimension with the fact table and mark these dimension members as fact members in the ETL process.Answered | 1 Replies | 1960 Views | Created by OndrasZMoravy - Wednesday, January 22, 2014 10:53 AM | Last reply by Thomas Ivarsson - Wednesday, January 22, 2014 6:03 PM -
0 Votes
More info on pivot table events?
Is there a good reference for how exactly to trap pivot-table events and what triggers them?Answered | 7 Replies | 7432 Views | Created by TOWiz - Friday, June 17, 2011 9:31 PM | Last reply by JeffreyWeir - Thursday, July 10, 2014 1:07 PM -
0 Votes
Pivot Table
I created a VBA procedure to copy all of the properties of a PivotTable along with the fields.Answered | 6 Replies | 606 Views | Created by Syswizard - Monday, May 8, 2017 4:18 PM | Last reply by Deepak Saradkumar Panchal - Monday, May 15, 2017 2:07 AM -
0 Votes
Pivot Table Report in Excel Services 2010
You can not edit a spreadsheet from Excel Services, you can however pass values in and re-execute the data sources that the pivot tables point too, but you cannot save once ...Answered | 1 Replies | 12586 Views | Created by K V B Gururaaja - Tuesday, February 16, 2010 7:27 AM | Last reply by Chris Givens - Tuesday, March 2, 2010 4:39 AM -
2 Votes
Pivots based on linked table parameters are not refreshed in Excel
The results are displayed in Excel pivot tables and pivot charts.Answered | 6 Replies | 2319 Views | Created by Hraskó Gábor - Wednesday, June 22, 2016 7:00 AM | Last reply by Hraskó Gábor - Wednesday, November 2, 2016 8:50 AM -
7 Votes
How to view perspectives on pivot table with excel 2013?
Here is the one of the bullet I copied of from that link theredpea posted.Answered | 12 Replies | 10631 Views | Created by the_txeriff - Friday, September 6, 2013 8:36 AM | Last reply by sharmila29 - Tuesday, March 29, 2016 2:18 PM -
0 Votes
Pivot Table - Excel Available Resources
When trying to refresh my pivot tables (after adding data) quite often - but not always - I get the following excel message: "Excel cannot ...Answered | 2 Replies | 8765 Views | Created by Chloe and Winston - Tuesday, November 30, 2010 3:41 PM | Last reply by Bruce Song - Thursday, December 2, 2010 8:33 AM -
0 Votes
Excel Pivot Table Calculated Field
Microsoft Office Forums > Microsoft Office Excel Forums > Using Pivot Tables, Charts, and other ways to Display Information located ...Answered | 1 Replies | 8035 Views | Created by Fatih_Turkey - Friday, July 30, 2010 7:04 AM | Last reply by Dinesh Kattameda - Friday, July 30, 2010 9:29 AM -
0 Votes
Create a PowerPivot table based on an existing pivot table
The only way to go is to import the data into Power Pivot in a new Excel file, and create new pivot tables.Answered | 2 Replies | 3706 Views | Created by jdmarks3 - Friday, June 3, 2016 12:57 PM | Last reply by jdmarks3 - Friday, June 3, 2016 1:45 PM -
0 Votes
Preserving Named Tables as Pivot Table data sources after copying to new workbook (Excel 2010)
Have 2010 Excel Workbook with Named Tables and child Pivot Tables and several other support sheets.Answered | 1 Replies | 416 Views | Created by Jon K Jr - Tuesday, January 13, 2015 1:59 AM | Last reply by Starian chen - Wednesday, January 14, 2015 6:48 AM -
0 Votes
Create Excel Pivot Table With External Datasource
http://openxmldeveloper.org/blog/b/openxmldeveloper/archive/2011/12/05/creating-pivot-tables-part-1.aspx ...Answered | 1 Replies | 1685 Views | Created by GertVe - Wednesday, July 29, 2015 8:09 AM | Last reply by David_JunFeng - Thursday, July 30, 2015 8:46 AM -
0 Votes
Excel Pivot Table
Where is the forum for Microsoft Excel 2007 pivot table using SSAS cube as datasource.Answered | 1 Replies | 7889 Views | Created by Rohit Kapoor - India - Thursday, September 10, 2009 10:07 AM | Last reply by Kiran Polimetla - Thursday, September 10, 2009 12:00 PM - Items 1 to 20 of 1440062 Next ›
No announcements
