What is causing the “Data source reference is not valid” Error in Excel? We investigated this particular error message by looking at various user reports and the ...

Some Excel users have reported experiencing the Data source reference is not valid error while creating a pivot table in Excel. We will learn why this error occurs ...

Up-to-date information can be critical; these 4 tips will add flexibility and increase efficiency when refreshing pivot tables. Image: Getty Images/iStockphoto PivotTable objects are only as good as ...

Back in 2016 I wrote the following blog post about changes to the way Excel 365 generated MDX queries for PivotTables connected to Analysis Services, Power Pivot/the ...

Export data to an Excel PivotTable to better see patterns and trends. Learn how to run this process and get tips for working with the table after export. [!INCLUDE applies-to-unified-interface] Export ...

Liam Bastick looks at the new PivotTable enhancements and updates in Office 2019. PivotTables were enhanced beyond recognition with the advent of Excel 2010 and Excel 2013, and the introduction of ...

How to display the top n records in an Excel PivotTable using built-in options Your email has been sent In a previous TechRepublic article, How to highlight the top n values in a Microsoft Excel sheet ...