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.
- In Microsoft Excel, switch to the Data tab in the ribbon.
- Click the dropdown arrow on the Refresh All button.
- Select Refresh All (or press Ctrl + Alt + F5).
- 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.
- On the Data tab, click Queries & Connections to open the sidebar.
- Click on the Connections tab in the pane.
- Right-click your active data connection and select Properties….
- In the Connection Properties dialog, look for OLAP Server Timeout (or Command timeout).
- Increase the value from
60seconds to300or600seconds. - 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.
- Close Microsoft Excel completely.
- Press the Windows Key, type Credential Manager, and open it.
- Select Windows Credentials.
- Under Generic Credentials, find entries starting with
MicrosoftOffice16_Data:orMSShared. - Expand the entries and click Remove.
- 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.
- Navigate to File > Options > Advanced.
- Scroll down to the Formulas section.
- Uncheck Enable multi-threaded calculation.
- Click OK, restart Excel, and refresh the data. Once the data loads successfully, you can safely re-enable multi-threading.