Select all search results in pivot table filters. Excel 2016 for Mac offers the ability to perform a search within a pivot table filter. However, it does not offer an option to select all search results, so they must be selected individually. Note that this feature is available in standard filters; it is only missing from pivot table filters. Instead of a download it’s actually already installed when you install Office 16, it’s just disabled. Let’s go ahead and enable it. Open Excel, Go to File – Options – Add-Ins; Select “COM Add-ins” from the “Manage” dropdown and click Go. Check the “Microsoft Power Pivot for Excel” checkbox and click OK.
First look Microsoft has released a self-destructing preview of Office 2016 for Mac – Word, Excel, PowerPoint, Outlook and OneNote – but it still is not the equal of its PC counterpart.
Should Office work as well on OS X as on Windows? You can imagine the question being debated on Microsoft's Redmond campus. Is it better to keep users hooked on Office and Exchange whatever computer or device they use, or to preserve a key selling point for Windows, given that many business users live in Excel, Outlook, Word, and PowerPoint?
The appearance of decent-though-cut-down versions of Office for iOS and Android suggests that opinion has tilted towards making Office work well everywhere. But a first look at the new Office 2016 preview suggests that Mac Office, while improving, has yet to catch up with Office 2013, let alone with whatever may be in the new Windows Office that's expected later in 2015.
Office 2016 preview is a substantial 2.66GB download but it's easy to install, provided you have the 10.10 'Yosemite' flavour of OS X. Earlier versions are not supported. Another possible compatibility headache is that Outlook 2016 only supports Exchange 2010 or higher. The preview can work alongside Office 2011 and will run for up to 60 days.
Microsoft does seem to be bringing the visual design of Office on the Mac more closely into line with Office on Windows and on devices. The curvy app icons in Office 2011 were unique, while the Office 2016 icons are the same as those on Windows. The ribbon in Excel 2016 looks more like Excel 2013 than Excel 2011 for Mac, complete with the washed-out effect that was part of Microsoft's 'content-first' strategy. There are still obvious differences, though; for example, menu headings are in all caps only in Office 2013.
The ribbon toolbar in Excel 2011, Excel 2016, and Excel 2013
A big change, appearance aside, is that Office 2016 now ties in properly with Microsoft's cloud services. Opening documents from and saving them to either the consumer or business versions of OneDrive is built-in, and the 'Open Recent' feature now shows you recent files across all your computers – presuming you have signed into a Microsoft account.
Considering the five-year gap between Office 2011 and Office 2016, the official list of what's new is surprisingly short, though it only covers major features. In summary:
- Throughout Office, Microsoft promises full Retina Display support as well as Full Screen view (click the green icon at top left to enter or exit full screen view), and the redesigned Ribbon mentioned above.
- There are new themes, styles, and templates in Word, Excel, and PowerPoint.
- Word and PowerPoint support threaded comments.
Threaded comment in Word 2016. OK, I am talking to myself.
- Excel has added support for the Analysis Toolpak (a collection of data analysis wizards), PivotTable slicers (buttons for filtering data in a PivotTable report), a Recommended Charts wizard, and an Equation Editor (replacing Office 2011's ancient and separate Microsoft Equation Editor). Most Excel 2013 functions are now supported. The formula builder has been improved, and print to PDF has been added.
- Word gets a new Design tab for applying themes and styles, and an improved navigation pane (replacing Document Map).
- PowerPoint gets an improved Presenter View, support for PowerPoint 2013 transitions, and an enhanced animation pane for managing animations. Saving to a QuickTime movie has been chopped.
- Outlook has support for Message Preview (seeing the first line of an email in the list of messages), and Online Archive, a feature of Office 365 Enterprise or Exchange.
- OneNote is now bundled with Office, though since Spring 2014 this app has been free on all platforms.
The above might make it sound as if not much is new. But in fact the look, feel, and performance of Office 2016 are all substantial advances from Office 2011, and there are many small changes I haven't mentioned.
Moreover, while Outlook 2011 was hardly usable on my Core i5 Mac Mini, Outlook 2016 works well even with my unreasonably large Exchange 2010 mailbox. If you use Office 365 or personal OneDrive, Office 2016 works smoothly, where with the the previous version it was a struggle.
Microsoft has also struck a good balance between preserving a common user interface across all versions of Office and fitting in with the Mac user interface. It will not please everyone, but for those who use Office both on Windows PCs and on Macs, the transition is much easier.
That said, Office 2016 does nothing to change my opinion that serious Office users should stick with Windows. Even though it is a couple of years on from Office 2013, there is hardly anything here that is not already in the Windows edition; this is a partial catch-up.
For one thing, the current preview is 32-bit only, whereas 64-bit Office has been available on Windows for many years (although Microsoft recommends the 32-bit version for most users, for compatibility reasons). And while Excel for Mac now has PivotTable slicers, what about PowerPivot, which has been available on Windows since Excel 2010?
There is evidence, though, that Microsoft is working to divide Office into two different variants: full Office on Windows and Mac, and a cut-down version for tablets and phones. There is hope that in time Mac uses will not have to suffer an inferior Office. Then again, perhaps Microsoft does not mind if there is at least one strong business reason to run Windows. ®
Applies to: SQL Server Analysis Services Azure Analysis Services Power BI Premium
Power Pivot for SharePoint 2013 is a collection of application server components and back-end services that provide Power Pivot data access in a SharePoint Server 2016 farm. The Power Pivot for SharePoint add-in (spPowerpivot16.msi) is an installer package used to install the application server components.
Note: This topic describes installing the Power Pivot solution files and Power Pivot for SharePoint 2016 Configuration tool. After the installation, see the following topic for information on the configuration tool and additional features, Configure Power Pivot and Deploy Solutions (SharePoint 2013).
For information on how to download spPowerPivot16.msi, see Microsoft® SQL Server® 2016 Power Pivot® for Microsoft SharePoint®.
Application Server: Power Pivot functionality in SharePoint 2016 includes using workbooks as a data source, scheduled data refresh, and the Power Pivot Management Dashboard.
Power Pivot for SharePoint 2016 is a Microsoft Windows Installer package (spPowerpivot16.msi) that deploys Analysis Services client libraries and copies Power Pivot for SharePoint 2013 installation files to the computer. The installer does not deploy or configure Power Pivot features in SharePoint. The following components install by default:
Power Pivot for SharePoint 2016. This component includes PowerShell scripts (.ps1 files), SharePoint solution packages (.wsp), and the Power Pivot for SharePoint 2016 configuration tool to deploy Power Pivot in a SharePoint 2016 farm.
Microsoft OLE DB Provider for Analysis Services (MSOLAP).
ADOMD.NET data provider.
Disk drill for mac. SQL Server Analysis Management Objects.
Backend services: If you use Power Pivot for Excel to create workbooks that contain analytical data, you must have Office Online Server configured with a BI server running Analysis Services in Power Pivot mode to access that data in a server environment. You can run SQL Server Setup on a computer that has SharePoint Server 2016 installed, or on a different computer that has no SharePoint software. Analysis Services does not have any dependencies on SharePoint.
For more information on installing, uninstalling, and configuring the backend services, see the following:
Where to Install spPowerPivot16.msi?
A recommended best practice is to install spPowerPivot16.msi on all servers in the SharePoint farm for configuration consistency, including application servers and web-front end servers. The installer package includes the Analysis Services data providers as well as the Power Pivot for SharePoint 2016 configuration tool. When you install spPowerPivot16.msi you can customize the installation by excluding individual components.
Data providers: Several SharePoint and SQL Server technologies use the Analysis Services data providers including PerformancePoint Services and Power View. Installing spPowerPivot16.msi on all SharePoint servers ensures the full set of Analysis Services data providers and Power Pivot connectivity is consistently available across the farm.
You must install the Analysis Services data providers on a SharePoint 2016 server using spPowerPivot16.msi. Other installer packages available in the SQL Server 2017 Feature Pack are not supported because these packages do not include the SharePoint 2016 support files that the data providers require in this environment.
Configuration Tool: The Power Pivot for SharePoint 2016 configuration tool is required on only one of the SharePoint servers. However a recommended best practice in multi-server farms is to install the configuration tool on at least two servers so you have access to the configuration tool if one of the two servers is offline.
Requirements and Prerequisites
Microsoft SharePoint Server 2016.
spPowerPivot16.msi is 64-bit only, in accordance with the requirements of SharePoint products and technologies.
A server in Power Pivot mode. Office Online Server will use the SQL Server Analysis Services instance as a Power Pivot server. Analysis Services can run on the local SharePoint server or a remote computer. It cannot be installed on the Office Online Server.
Permissions: To install Power Pivot for SharePoint 2016, the current user is required to be an administrator on the computer and in the SharePoint Farm Administrators group.
For more information on Power Pivot for SharePoint requirements and pre-requisites, go to Hardware and Software Requirements for Analysis Services Server in SharePoint Mode.
To Install Power Pivot for SharePoint
The spPowerpivot16.msi installer package supports both a graphical user interface and a command-line mode. Both methods of installation require that you run the .msi with administrator privileges. After the installation, see the following topic for information on the configuration tool and additional features, Configure Power Pivot and Deploy Solutions (SharePoint 2013).
User interface installation
To install Power Pivot for SharePoint 2016 with the graphical user interface, complete the following steps:
Select Next on the Welcome page.
Review and accept the license agreement, then select Next.
On the Feature Selection page, all of the features are selected by default.
Select Install to install to finish the installation.
Command Line Installation
For a command-line installation, open a command prompt with administrative permissions, and then run the spPowerPivot16.msi. For example:
Msiexec.exe /i spPowerPivot16.msi.
To create an installation log, use the standard MsiExec logging switches. The following example creates the log file 'Install_Log.txt' using the 'v' verbose logging switch.
Quiet Command Line Installation for scripting
You can use the /q or /quiet switches for a 'quiet' installation that will not display any dialogs or warnings. The quiet installation is useful if you want to script the installation of the add-in.
If you use the /q switch for a silent command line installation, the end-user license agreement will not be displayed. Regardless of the installation method, the use of this software is governed by a license agreement and you are responsible for complying with the license agreement.
To perform a quiet installation:
Open a command prompt with administrator permissions.
Run the following command:
Command Line Installation to include specific components
The Power Pivot for SharePoint 2016 Configuration tool is not required on every SharePoint server, however it is recommended to install it on at least two servers so the configuration tool is available when you need it.
When you install the spPowerPivot16.msi, you can use the command line options to install specific items, such as the data providers and not the Power Pivot for SharePoint 2016 Configuration tool. The following command line is an example of installing all components except the configuration tool:
|Analysis_Server_SP_addin16||Power Pivot for SharePoint 2016 Configuration|
|SQL_OLAPDM||Analysis Services OLE DB Provider for SQL Server 2016|
|SQL_AMO||SQL Server 2016 Analysis Management Objects (AMO) provider|
|SQLAS_SP16_Common||Analysis Services common components for SharePoint 2016|
Deploy the SharePoint Solution Files with the Power Pivot for SharePoint 2016 Configuration Tool
Three of the files copied to the hard drive by spPowerPivot16.msi are SharePoint solution files. The scope of one solution file is the Web application level while the scope of the other files is the farm level. The files are the following:
The solution files are copied to the following folder:
Following the .msi installation, run the Power Pivot for SharePoint 2016 Configuration Tool to configure and deploy the solutions in the SharePoint farm.
To start the configuration tool:
From the Windows Start screen type 'power' and in the Apps search results, select Power Pivot for SharePoint 2016 Configuration. Note that the search results may include two links because SQL Server setup installs separate Power Pivot configuration tools for SharePoint 2013 and SharePoint 2016. Make sure you start the Power Pivot for SharePoint 2016 Configuration tool.
Go to Start, All Programs.
Select Microsoft SQL Server 2017.
Select Configuration Tools.
Select Power Pivot for SharePoint 2016 Configuration.
For more information on the configuration tool, see Power Pivot Configuration Tools.
Uninstall or repair the add-in
If you uninstall spPowerPivot16.msi the data providers and the configuration tool are uninstalled. Uninstalling the data providers will cause the server to be unable to connect to Power Pivot.
Install Powerpivot For Excel 2016
You can uninstall or repair Power Pivot for SharePoint 2016 using one of the following methods:
Windows control panel: Select Microsoft SQL Server 2017Power Pivot for SharePoint 2016. Select either Uninstall or Repair.
Run the spPowerPivot16.msi and select the Remove option or the Repair option.
Command Line: To repair or uninstall Power Pivot for SharePoint 2016 using the command line, open a command prompt with administrator permissions and run one of the following commands:
To Repair, run the following command:
Enable Powerpivot In Excel 2016
To uninstall, run the following command: