How to Fix ‘#GETTING_DATA’ Stuck Error in Microsoft Excel

Opening an enterprise financial model, Power BI dataset, or linked stock/geography data sheet in Microsoft Excel only for multiple cells to become permanently stuck displaying “#GETTING_DATA” disrupts executive reporting. In Microsoft Excel’s data connectivity model, #GETTING_DATA is a temporary calculation state message. Excel displays this text while asynchronously querying external data providers, such as SQL Server Analysis Services (SSAS), Power BI semantic models, Power Query endpoints, or Microsoft Graph data types. When network connectivity drops, corporate proxy authentication fails, calculation engine deadlocks stall query threads, or OLAP cube queries exceed execution timeouts, Excel fails to receive the data stream and the cells remain permanently stuck in the loading state. This guide provides structured methods to clear query locks and restore live data in Excel.

Primary Triggers Behind Persistent #GETTING_DATA Errors

Because Excel fetches external data asynchronously across local network or cloud APIs, failures usually indicate connection roadblocks:

  • Network Authentication Timeouts: Expired OAuth2 bearer tokens or single sign-on (SSO) credentials when connecting to Microsoft Entra ID or Power BI workspaces.
  • Large or Unoptimised OLAP MDX/DAX Queries: Complex multidimensional queries that exceed Excel’s default 60-second connection timeout threshold.
  • Calculation Engine Multi-Threading Deadlocks: Thread collisions between Excel’s local calculation pipeline and background Data Model (VertiPaq) evaluation engines.
  • Proxy or Firewall Egress Blocking: Enterprise web filters blocking secure WebSockets or TLS connections to Microsoft 365 cloud endpoints.
  • Corrupted Office Identity Tokens: Stale credentials in the Windows Credential Manager preventing background service handshakes.

Method 1: Force Full Recalculation and Query Refresh

Forcing a complete data connection refresh purges obsolete query handles and triggers a clean query request.

  1. In Microsoft Excel, switch to the Data tab in the ribbon.
  2. Click the dropdown arrow on the Refresh All button.
  3. Select Refresh All (or press Ctrl + Alt + F5).
  4. If the cells remain stuck on #GETTING_DATA, force a full workbook calculation rebuild by pressing Ctrl + Alt + Shift + F9. This forces Excel to rebuild its internal dependency tree and re-query all external sources.

Method 2: Increase External Data Connection Timeouts

If querying large datasets or remote cloud models, extending the execution timeout allows heavy queries to complete.

  1. On the Data tab, click Queries & Connections to open the sidebar.
  2. Click on the Connections tab in the pane.
  3. Right-click your active data connection and select Properties….
  4. In the Connection Properties dialog, look for OLAP Server Timeout (or Command timeout).
  5. Increase the value from 60 seconds to 300 or 600 seconds.
  6. Click OK and click Refresh.

Method 3: Clear Microsoft Office Credentials in Windows

If your corporate password changed recently, background data services may be failing authentication silently.

  1. Close Microsoft Excel completely.
  2. Press the Windows Key, type Credential Manager, and open it.
  3. Select Windows Credentials.
  4. Under Generic Credentials, find entries starting with MicrosoftOffice16_Data: or MSShared.
  5. Expand the entries and click Remove.
  6. Restart Excel, open the workbook, and re-enter your Microsoft 365 credentials when prompted.

Method 4: Disable Multi-Threaded Calculation Temporarily

Thread deadlocks between external data providers and local formula trees can freeze the asynchronous loader.

  1. Navigate to File > Options > Advanced.
  2. Scroll down to the Formulas section.
  3. Uncheck Enable multi-threaded calculation.
  4. Click OK, restart Excel, and refresh the data. Once the data loads successfully, you can safely re-enable multi-threading.

Get the best tech tips delivered straight to your inbox.

Join thousands of readers mastering Apple, Google, Microsoft, and Linux.