Pivot Table Issues

Fix Excel Timeline and Pivot Table Fields Disappearing in Shared Workbooks

Natalie Taylor Sep 28, 2026 870 views

Question details

The user needs to fix an issue where Excel Timelines and Pivot Table row fields disappear after colleagues close and reopen a shared workbook on SharePoint.

Fix Excel Timeline and Pivot Table Fields Disappearing in Shared Workbooks

Product: Microsoft Excel
Device & OS: not provided
Scenario: Collaborating on a shared SharePoint workbook that utilizes Power Query, Pivot Tables, and Timelines.
Observed behavior: The timeline and pivot table row fields vanish when the file is closed and reopened by colleagues, causing the pivot table to count all dates and forcing the user to manually recreate the formatting.

Before you start

Before troubleshooting, save a local backup copy of your workbook to ensure you do not lose any underlying data or Power Query configurations during testing.

Solution 1Recommended

Isolate the Issue in Excel Desktop vs. Web

Determine if the formatting loss is caused by Excel for the Web limitations or a specific desktop app build by testing a local copy.

Opening complex files with Power Query and Timelines in Excel for the Web can sometimes strip advanced formatting. Testing the file strictly in the desktop application helps identify if the web environment is the culprit.

Download a local copy

Navigate to your SharePoint library, right-click the affected workbook, and select 'Download' to save a copy to your local drive.

Open exclusively in Desktop App

Launch the local Microsoft Excel desktop application, then open the downloaded file.

Recreate and refresh

Recreate the missing timeline and pivot table fields. Go to the 'Data' tab and click 'Refresh All' to trigger Power Query.

Save and verify

Save the file, close Excel entirely, and reopen the document locally to see if the timeline and pivot table fields remain intact.

Isolate the Issue in Excel Desktop vs. Web

Verify Excel Version: If the issue persists locally, go to File > Account in Excel to check your exact version and build number. Ensure all colleagues are using the same updated version.

Solution 2

Test for Co-authoring Conflicts

Temporarily disable co-authoring to check if simultaneous editing is causing the timeline and pivot table fields to drop.

Free Microsoft Office alternative

Try WPS Office for Stable Spreadsheet Management

If complex shared workbooks in Microsoft Excel frequently lose formatting or encounter co-authoring bugs, WPS Office provides a lightweight, highly compatible alternative for managing robust spreadsheets and pivot tables.

1. Download WPS Office: Visit the official WPS website to download and install the free WPS Office suite.
2. Open Your Spreadsheet: Launch WPS Spreadsheet and open your existing .xlsx file directly without losing your raw data.
3. Manage Pivot Tables: Navigate to the Insert tab to seamlessly create and manage your Pivot Tables locally.

Highly compatible with Microsoft Excel (.xlsx) formats.Stable Pivot Table creation, formatting, and data management.Free and lightweight alternative to heavy Microsoft Office subscriptions.Familiar user interface for a seamless and quick transition.

microsoft office alternative - wps office

Frequently Asked Questions

Why do pivot table timelines disappear when sharing an Excel file?

This often occurs due to feature limitations in Excel for the Web, synchronization conflicts during co-authoring on SharePoint, or compatibility issues between different desktop Excel versions used by your colleagues.

Does Power Query work seamlessly in Excel for the Web?

Excel for the Web has limited support for Power Query. While you can refresh some background queries, full editing and seamless data refreshing usually require the full Excel desktop application.

How can I prevent my pivot tables from losing their fields in SharePoint?

To prevent data loss, try checking out the document on SharePoint for exclusive editing, ensure all users are on the identical Excel desktop build, and avoid editing complex Pivot Tables with Timelines directly in the web browser.

Excel & Data Problems