How to Delete Data Model in Excel

Ever opened an Excel file that took forever to load, only to find it's a 50 MB behemoth with just a few tabs of data? The culprit is often a hidden Data Model, a feature that stores vast amounts of data behind the scenes. This guide will show you exactly how to find and delete that data model to drastically reduce your file size and improve performance.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

What is an Excel Data Model (and Why Should You Care)?

An Excel Data Model is a powerful feature that allows you to integrate data from multiple tables, building complex relationships between them much like a database. It's the engine behind Power Pivot and drives more advanced PivotTables, PivotCharts, and Power BI reports. When you load data using Power Query and choose "Add this data to the Data Model," you are sending a copy of that data into this internal storage.

While incredibly useful, the Data Model itself can be a source of frustration for three key reasons:

• Bloated File Size: This is the number one issue. The Data Model stores a compressed copy of your data inside the Excel file. Even if you delete the source data from your worksheets, the copy in the model remains, keeping your file size enormous. A simple summary report file can easily balloon to 50, 100, or even 200MB.
• Slow Performance: Larger data models require more memory and processing power. This can make the workbook sluggish to open, save, or even just interact with, leading to that dreaded "Excel is not responding" message.
• Cleanup and Housekeeping: You might inherit a workbook from a colleague, or maybe your analysis has evolved, and the original data model is no longer needed. Deleting it allows you to start fresh, get rid of unnecessary data, and simplify your workbook.

If you're dealing with a large and laggy Excel file, learning how to remove the data model is a crucial skill for getting things back under control.

A Quick Safety Check Before You Delete Anything

Before you start deleting, it's important to understand what will happen and to protect your work. Think of this as your pre-flight checklist.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

1. Create a Backup Copy

This is non-negotiable. Deleting the Data Model is an irreversible action. Before you do anything else, save a copy of your workbook. Go to File > Save As and rename it something like "MyReport_Backup_Version.xlsx". If something goes wrong, you can always revert to this saved copy.

2. Understand the Consequences

When you delete the Data Model, you are removing the data source for anything connected to it. This means:

• PivotTables and PivotCharts: These connected to the model will break. They’ll stop working and display an error message.
• Power View: Sheets and reports will be deleted entirely.
• **Any formulas that use CUBE functions (like CUBEMEMBER or CUBEVALUE) to pull data from the model will return #N/A errors.

Be sure you don't need these elements anymore or are prepared to rebuild them using a different data source.

How to Delete the Data Model in Excel (The Official Method)

The correct and safest way to delete the Data Model is by using the Power Pivot add-in. For some users, this tab might already be visible on the ribbon. If not, don't worry - enabling it takes less than a minute.

Step 1: Enable the Power Pivot Add-in

If you don't see a "Power Pivot" tab in your Excel ribbon, follow these steps to turn it on:

1. Click on File in the top-left corner.
2. Go to Options at the very bottom of the left-hand menu.
3. In the Excel Options window, select Add-ins.
4. At the bottom of the window, you'll see a dropdown menu next to "Manage". Make sure it says COM Add-ins and click the Go… button.
5. In the new dialog box, check the box next to Microsoft Power Pivot for Excel.
6. Click OK.

You should now see a brand new "Power Pivot" tab appear in the Excel ribbon.

Note: Power Pivot is not available in every version of Excel. It's typically included in Office 365, Office Professional Plus, and standalone versions of Excel. If you don't see the option, your Excel license may not include it. In that case, jump to the Alternative Methods section below.

Step 2: Open the Power Pivot Window

With the add-in enabled, this part is simple.

1. Click on the new Power Pivot tab in the ribbon.
2. In the "Data Model" section, click the green Manage button.

This will open a separate Power Pivot for Excel window, which is the management hub for your Data Model. You'll see your data organized into different tables, visible as tabs at the bottom of this window.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

Step 3: Delete Each Table from the Model

This is the most critical step. There's no single "Delete Data Model" button. Instead, you need to remove every table that makes up the model.

1. In the Power Pivot window, look at the tabs at the bottom. Each tab represents a table in your Data Model.
2. Right-click on the first table tab.
3. Select Delete from the context menu.
4. A warning prompt will appear, reminding you that this action cannot be undone. Click OK to confirm.
5. Repeat this process for every single table tab in the Power Pivot window.

Once all the tables are deleted, the Power Pivot window will be empty. You have now successfully cleared out the data model.

Step 4: Save and Check Your File Size

Now for the satisfying part! Close the Power Pivot window to return to your main Excel workbook.

1. Go to File > Save to save your changes.
2. Close the Excel file and navigate to it in Windows Explorer or Finder.
3. Check the file size. You should see a dramatic reduction. It's not uncommon for a file that was 50 MB to shrink down to under 500 KB after the model is removed.

When you reopen the workbook, your old PivotTables that were once connected to the model will now show errors, confirming that their source is well and truly gone.

Alternative Methods and Workarounds

What if you can't use the Power Pivot add-in? Maybe your Excel version doesn't support it, or the file is too corrupt to open the manage window. Here are a couple of workarounds.

Workaround 1: Move Your Worksheets to a New Workbook

This is the safest and easiest alternative. A data model lives within a specific workbook and does not travel with copied sheets.

1. Open your oversized Excel file and a new, blank workbook side-by-side.
2. In your original file, right-click on a worksheet tab that you want to keep.
3. Select Move or Copy....
4. In the "To book:" dropdown, select your new, blank workbook.
5. Important: Check the "Create a copy" box at the bottom.
6. Click OK.
7. Repeat this for all the visible worksheets you need to save. Do not copy any Power View sheets or PivotTables connected to the model.

Once you've copied over all the necessary data, save the new workbook. It will contain all of your worksheet data without carrying over the bulky data model.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Workaround 2: The "Rename to .zip" Trick (Use with Caution)

This method is more advanced and should be considered a last resort, typically used for corrupted files where the Power Pivot window won't open. Always work on a backup copy when trying this.

1. Create a backup of your file. Seriously.
2. In Windows File Explorer, make sure you can see file extensions. You can do this by going to the View tab and checking the "File name extensions" box.
3. Right-click on your Excel file and rename it, changing the extension from .xlsx to .zip. For example, MyReport.xlsx becomes MyReport.zip. Press Enter and confirm the change.
4. Double-click the new .zip file to open it like a regular folder.
5. Navigate into the xl folder. Inside, you should find another folder named model.
6. Delete the entire model folder.
7. Close the zip archive window.
8. Rename the file back from .zip to .xlsx.

Now, try to open the Excel file. Excel may present you with a message saying it found a problem with some content and ask if you want to try and recover the workbook. Click "Yes." This is usually Excel just cleaning up the links to the model you just forcibly removed. If it works, you'll have your workbook back without the data model.

Final Thoughts

Managing the size and performance of Excel workbooks is a common challenge, and ghost data models are often the hidden cause of unnecessary bloat. By using the Power Pivot add-in to remove unwanted tables, you can quickly reclaim control, shrink your files, and make your reports much faster and easier to work with.

While mastering the nuances of Excel is a powerful skill, we know that the time spent wrangling data models could be better used on strategy and analysis. That's why we created Graphed. Our platform automates the tedious parts of data reporting by allowing you to simply connect your data sources — like Google Analytics, HubSpot, or Shopify — and create live, interactive dashboards just by asking questions in plain English. This lets you and your team get immediate answers without getting bogged down in the technical minutiae, turning hours of data cleanup into seconds of insight.