Excel Error Codes

How to Fix MSOLAP$LocalCube Event ID 25 Errors in Excel

Emma Brown Oct 10, 2026 868 views

Question details

Users are encountering MSOLAP$LocalCube Event ID 25 errors in the Windows Event Viewer when working with data and PivotTables.

How to Fix MSOLAP$LocalCube Event ID 25 Errors in Excel

Product: Microsoft Excel
Device & OS: not provided
Scenario: Inserting a PivotTable in Excel, particularly after loading data into a worksheet table via Power Query.
Observed behavior: The Event Viewer repeatedly logs MSOLAP$LocalCube Event ID 25 errors, pointing to issues with the Excel OLAP component.

Before you start

Save your current Excel workbook and check the Windows Event Viewer to confirm the exact Event ID and source before attempting to repair Office or modify your data loading methods.

Solution 1Recommended

Load Data Directly to PivotTable via Power Query

Bypass the error entirely by loading data directly into a PivotTable from Power Query instead of inserting it manually from a worksheet table.

Many users have identified that the MSOLAP$LocalCube error specifically triggers during the manual insertion of a PivotTable from an existing table. Loading data directly from Power Query into a PivotTable report acts as an effective workaround.

Open Power Query

In your Excel workbook, navigate to the Data tab, select 'Get Data', and choose your data source to open the Power Query Editor.

Change Load Destination

After transforming your data, click the drop-down arrow under 'Close & Load' in the Home tab and select 'Close & Load To...'.

Select PivotTable Report

In the Import Data dialog box, select 'PivotTable Report' instead of 'Table' and choose where you want the PivotTable to be placed. Click OK.

Load Data Directly to PivotTable via Power Query

Effective Workaround: This method prevents the MSOLAP component from triggering Event ID 25 by avoiding the manual PivotTable generation process on an existing worksheet table.

Solution 2

Repair Microsoft Office Installation

Use the built-in Microsoft Office repair tool to fix potential corruption within the Excel OLAP component.

Solution 3

Test Excel in Safe Mode and Disable Add-ins

Determine if a third-party add-in is conflicting with the Excel OLAP component and causing the Event ID 25 errors.

Free Microsoft Office alternative

Create PivotTables Seamlessly with WPS Office

Tired of encountering complex MSOLAP component errors and Event ID 25 logs? WPS Office provides a lightweight, highly compatible spreadsheet tool that makes data analysis and PivotTable creation hassle-free.

Fully compatible with Microsoft Excel (.xlsx, .xls, .csv) file formats.Create, manage, and analyze PivotTables without triggering complex OLAP component errors.Free, lightweight, and consumes minimal system resources.Familiar user interface allowing for a zero-learning-curve transition.

microsoft office alternative - wps office

Frequently Asked Questions

What causes the MSOLAP$LocalCube Event ID 25 error in Excel?

This error is typically triggered by a bug or conflict within the Excel OLAP (Online Analytical Processing) component when manually inserting a PivotTable from data that was previously loaded into a standard worksheet table.

Will reinstalling Microsoft 365 permanently fix Event ID 25?

Not always. Many users report that standard repairs or completely reinstalling Microsoft 365 does not permanently resolve the issue. Loading data directly to a PivotTable via Power Query is currently the most reliable workaround.

Does Event ID 25 affect my Excel data or crash my computer?

Event ID 25 is primarily an application warning logged in the Windows Event Viewer. While it indicates an issue with local cube generation, it typically does not cause file corruption, data loss, or system-wide crashes.

Can I use WPS Office to open files with PivotTables created in Excel?

Yes, WPS Spreadsheet is highly compatible with Excel files and supports viewing, creating, and modifying PivotTables seamlessly, without relying on the specific Microsoft OLAP components that trigger this error.

Microsoft Office Error Codes