Pivot Table Issues

Fix MSOLAP LocalCube Event ID 25 Errors in Excel Pivot Tables

Adam Davis Oct 8, 2026 869 views

Question details

The user is encountering repeated MSOLAP$LocalCube Event ID 25 errors when attempting to create or open Pivot Tables.

Resolving MSOLAP LocalCube Event ID 25 Errors in Excel Pivot Tables

Product: Microsoft Excel
Device & OS: not provided
Scenario: Opening an existing workbook or creating a new PivotTable from an Excel table.
Observed behavior: The Windows Event Viewer records MSOLAP$LocalCube Event ID 25 errors during PivotTable generation or loading.

Before you start

Before proceeding, ensure your Windows OS and Microsoft Office are fully updated, and create a backup copy of your Excel workbook to prevent accidental data loss.

Solution 1Recommended

Gather Logs and Consult the Microsoft Q&A Forum

Because MSOLAP LocalCube errors involve the advanced Data Model and Analysis Services engines, resolving them often requires expert investigation in specialized forums.

Event ID 25 is a specific failure in the Microsoft Analysis Services local cube engine. Since this issue requires in-depth diagnostics of your Power Query and Excel Data Model configuration, the most effective route is to engage with advanced community experts.

Extract Event Logs

Open the Windows Event Viewer, navigate to Windows Logs > Application, and save the detailed text of the MSOLAP$LocalCube Event ID 25 error.

Document Application Details

Open Excel, go to File > Account, and note down your exact Excel version and build number.

Prepare a Sanitized Workbook

Create a copy of your problematic workbook and remove all sensitive, confidential, or proprietary data.

Post to Microsoft Q&A

Navigate to the Microsoft Q&A forum or the Excel Tech Community, and post your sanitized workbook alongside the specific event logs and symptoms.

Gather Logs and Consult the Microsoft Q&A Forum

Protect Your Data: Never upload workbooks containing personal identifiable information (PII) or confidential company data to public forums.

Solution 2

Perform an Online Repair of Microsoft Office

Corrupted Office installations or outdated MSOLAP providers can trigger local cube failures. Repairing Office can restore the integrity of the Data Model engine.

Free Microsoft Office alternative

Try WPS Office for Stable and Lightweight Pivot Tables

If complex MSOLAP dependencies in Microsoft Excel are causing persistent Event ID 25 crashes, WPS Office offers a highly compatible, free, and lightweight alternative. Experience seamless PivotTable creation without the heavy overhead of Microsoft's local cube engine.

1. Download and Install: Download WPS Office Free from the official website and complete the quick installation.
2. Open Your Workbook: Launch WPS Spreadsheet and open your existing .xlsx file.
3. Create a Pivot Table: Navigate to the Insert tab and click 'PivotTable' to analyze your data seamlessly without local cube errors.

Free, lightweight, and fast installation process.Excellent compatibility with Microsoft Excel (.xlsx) formats and standard Pivot Tables.Familiar spreadsheet interface ensuring a zero learning curve.No complex LocalCube or Analysis Services overhead for everyday data analysis.

microsoft office alternative - wps office

Frequently Asked Questions

What is MSOLAP$LocalCube in Excel?

MSOLAP$LocalCube is a component of Microsoft Analysis Services. It is used by Excel's Data Model (Power Pivot) to process and query multidimensional data efficiently on your local machine.

Why do I get Event ID 25 when creating a simple Pivot Table?

Event ID 25 indicates a failure or misconfiguration in the local Analysis Services engine. Excel can trigger this if the Pivot Table inadvertently relies on the Data Model, or if the underlying MSOLAP provider files are corrupted on your system.

Can I create Pivot Tables without triggering the LocalCube engine?

Yes. When inserting a Pivot Table in Excel, ensure the 'Add this data to the Data Model' checkbox is unchecked. This forces Excel to use the standard Pivot Table cache instead of invoking the MSOLAP local cube engine.

Excel & Data Problems