Why Is Tableau Not Updating Data from Excel?

You’ve built a powerful, insightful dashboard in Tableau using data from an Excel file, and it looks great. But when you add new rows of data to your spreadsheet, you hit the refresh button in Tableau, and... nothing happens. This frustrating scenario is more common than you think, but the fixes are usually straightforward. This article walks you through the main reasons your Tableau dashboard isn't updating from your Excel file and gives you clear, step-by-step instructions on how to solve the problem for good.

Graphed

Your AI Data Analyst to Create Live Dashboards

Connect your data sources and let AI build beautiful, real-time dashboards for you in seconds.

Build Your First Dashboard

Understanding How Tableau Connects to Excel: Live vs. Extract

The very first thing to understand is the nature of the connection between Tableau and your Excel file. When you first connect to your data, Tableau gives you two choices in the top right corner of the Data Source screen: Live and Extract. This choice is the root cause of most refresh issues.

What is a Live Connection?

A Live connection means Tableau queries your Excel file directly every time you view or interact with a dashboard. Think of it like a live video feed. Any changes you make in the Excel file should immediately be reflected in your Tableau dashboard once you refresh it.

• Pros: Data is as close to real-time as possible. When you open the workbook, it pulls the very latest information from the source file.
• Cons: Performance can be slow, especially with large or complex Excel files. Every filter you click and every chart that loads requires Tableau to re-read the spreadsheet, which can take time.

AI for Data Analysis

Crash Course

Graphed

Free PDF Guide

AI for Data Analysis Crash Course

Learn how to get AI to do data analysis for you — the best tools, prompts, and workflows to go from raw data to insights without writing a single line of code.

Download Free Guide

What is an Extract?

An Extract, on the other hand, is a snapshot of your data that is imported and stored within Tableau itself as a highly compressed, optimized .hyper file. Think of this like taking a photograph. The photograph won’t change even if the original scene does. To see the changes, you need to take a new picture - or in Tableau’s terms, you need to refresh the extract.

• Pros: Much faster performance. Since the data is in Tableau's optimized format, dashboards load quickly and interactions are snappy.
• Cons: The data can become stale. It is only as current as the last time the extract was refreshed. You need a deliberate process to update it.

So, which one are you using? A huge number of "my data isn't updating" problems happen because a user has created an extract but assumes their connection is live. They update the Excel file but never tell Tableau to take a new "snapshot." In Tableau Desktop, you can right-click your data source in the Data pane and you'll see an option to "Use Extract" (if you're on a Live connection) or information about when the extract was last updated (if you're using an Extract).

Where Is Your Excel File Saved? Local vs. Shared Drives

The next likely culprit is the physical location of your Excel file. This becomes especially important when you publish your dashboard to Tableau Server or Tableau Cloud (formerly Tableau Online).

The Problem with Local Files

If your Excel file is saved on your computer - for instance, in "My Documents" or on your Desktop - only you can access it. When you publish a workbook to Tableau Server or Cloud, those platforms exist on completely separate computers. They have absolutely no way to access the file path C:\Users\YourName\Documents\SalesData.xlsx.

This means:

• A Live connection will simply fail when anyone else tries to open the dashboard from the server. They will see an error message.
• An Extract can be published with the data included, but it can never be automatically refreshed. Tableau Server/Cloud can't find the original Excel file to pull new data from.

Graphed

Your AI Data Analyst to Create Live Dashboards

Connect your data sources and let AI build beautiful, real-time dashboards for you in seconds.

Build Your First Dashboard

The Solution: Shared Network and Cloud Drives

To enable automatic updates, your Excel file must be stored in a location that both you and the Tableau Server/Cloud can access. This means using:

1. A Shared Network Drive: This is a folder on your company's internal network. To make this work, you need to connect to the file using its full Universal Naming Convention (UNC) path, not just a mapped drive letter like Z:\. A UNC path looks something like this: \\servername\sharename\path\to\your\file.xlsx This absolute path ensures Tableau Server knows exactly where to look for the file on the network.
2. A Cloud Storage Service: Storing your file in a service like SharePoint, OneDrive, or Google Drive is often the easiest solution. Tableau Cloud has built-in connectors for these services, allowing for a more seamless and reliable refresh process.

Changing your data source path from a local drive to a shared network path can solve many refresh failures instantly. In Tableau Desktop, you can right-click your data source, select "Edit Connection," and then browse to the file’s new location on the shared or cloud drive.

Common Failure Scenarios and How to Fix Them

Let's get into the specific troubleshooting steps for the most common issues based on your connection type and setup.

Scenario 1: You Have a Live Connection, but Data Isn't Updating

If you're using a confirmed Live connection on Tableau Desktop and the data still isn't showing the latest changes from Excel, the problem is often simpler.

• Simple Refresh Needed: In Tableau Desktop, pressing F5 or clicking the "Refresh" button on the toolbar should update the view. Sometimes, a full refresh is needed by clicking the datasource and selecting 'Refresh.'
• File Was Moved or Renamed: Did you or a colleague rename the Excel file or move it to a different folder? This breaks the connection path. You’ll typically see an error icon next to your data source. Right-click the data source, choose "Edit Connection," and point Tableau to the file's new location.
• Someone Has the Excel File Open: When an Excel file is open and being edited, it's often locked by Windows, preventing other applications like Tableau from reading it properly. Close the Excel file on all machines and try refreshing Tableau again.

Scenario 2: Your Published Extract Never Refreshes on a Schedule

This is the most common and complex challenge. You've published a workbook with an extract to Tableau Server or Cloud, set up a refresh schedule, but the data is always out of date. Here's your checklist.

1. Check the File Path: As discussed, this is the #1 culprit. If your original workbook was connected to C:\My Documents\data.xlsx, the server has no way to find it. You must edit the workbook in Tableau Desktop, change the connection to a full UNC path or cloud source, and republish. When republishing, ensure the 'Include external files' checkbox is unchecked if you want the server to grab the updates from the shared path directly.
2. Run a Manual Refresh: From the Tableau Server/Cloud UI, navigate to the data source, and try to run a manual refresh by clicking "Run Now." If it fails, Tableau will usually provide an error message that gives you a clue. Common errors refer to "access denied" or "file not found," which both point to path or permissions issues.
3. Check Permissions: The Tableau Server "Run As" user account needs explicit "read" permissions for the network folder where your Excel file lives. Your IT department may need to grant this access. If the server can't access the file, it can't refresh it.
4. Using Tableau Cloud? Configure Tableau Bridge: Tableau Cloud is on the public internet and cannot access your private, internal network drives. To bridge this gap, you need a free application from Tableau called Tableau Bridge. This tool must be installed on a computer within your network that is always on. Bridge acts as a secure tunnel, fetching the data from your internal network drive on a schedule and pushing it up to Tableau Cloud. If your refreshes are failing, check that the Bridge client is running, connected, and properly configured for your data source.

AI for Data Analysis

Crash Course

Graphed

Free PDF Guide

AI for Data Analysis Crash Course

Learn how to get AI to do data analysis for you — the best tools, prompts, and workflows to go from raw data to insights without writing a single line of code.

Download Free Guide

Scenario 3: Refresh Fails After You Change the Excel File's Structure

Tableau remembers the exact structure (columns, data types, tab names) of your Excel file when the connection is first made.

If you make changes like:

• Renaming a column header (e.g., from "Sales" to "Revenue")
• Deleting a column that a chart depends on
• Adding new columns in the middle
• Changing the name of the Excel sheet/tab that Tableau is connected to

Your connection will break. Fields may show up with a red exclamation mark in Tableau. To fix this, open the workbook in Tableau Desktop, go to the Data Source tab, and you should see an alert. You can click on ‘Refresh Data source’ to let Tableau rescan the file structure and recognize the changes. Once you adapt your visualizations to the new structure, you’ll need to republish the workbook to the server.

Final Thoughts

Solving why Tableau isn't updating from your Excel file nearly always comes down to pinpointing a disconnect in the data chain. The first steps are always to confirm your connection type (Live vs. Extract), ensure your file is on a shared network or cloud location with a proper path, and verify that scheduled refreshes are set up correctly on your Tableau Server or Cloud platform.

It's clear that manual file management and connection troubleshooting can consume hours that are better spent on analysis. At Graphed, we decided to eliminate this friction entirely. We built a platform that connects directly to your live data sources like Google Analytics, Shopify, Facebook Ads, and Salesforce. Your dashboards are always up-to-date with real-time information, so you never have to worry about UNC paths, extract schedules, or broken connections again. It’s a smarter way to stay on top of your data, without the tedious manual work.