---
title: "\"Your stored defined name is not found in the workbook\" in Drafts Excel"
description: Drafts Excel says your stored defined name is not found or has lost its tag setup? Learn how to reconnect the tags or clean them up and re-tag.
---

[Skip to content](https://wrepit.net/help-center/defined-name-not-found-drafts-excel#main-content)

English - United States

Show submenu for translations

![Wrepit logo bla](https://wrepit.net/hs-fs/hubfs/Wrepit%20logo%20bla.png?width=150&height=43&name=Wrepit%20logo%20bla.png)

Open main navigation

Close main navigation

- English - United States
  
  Show submenu for translations
- Contact us

 Contact us

 Hi, how can we help you?

- There are no suggestions because the search field is empty.

1. [Help Center](https://wrepit.net/help-center?hsLang=en-us)
2. [Troubleshooting](https://wrepit.net/help-center/troubleshooting?hsLang=en-us)
3. [Drafts Excel](https://wrepit.net/help-center/troubleshooting?hsLang=en-us#drafts-excel)

# "Your stored defined name is not found in the workbook" in Drafts Excel

## What to do when a tagged table's defined name has been deleted, renamed or broken.

### What you see

In the workbook overview, a table has a red X and one of these messages:

- *Your stored defined name "{name}" is not found in the workbook.*
- *Your stored defined name "{name}" has lost its tag setup.*

### Why this happens

Drafts Excel ties each tagged table to a defined name (named range) in Excel.

- "…is not found in the workbook" means the defined name has been deleted or renamed in Excel, so the tags no longer know which cells they belong to.
- "…has lost its tag setup" means the table's setup (which row and column hold the tags and timeframes) is missing. This usually happens if the title row or title column of the table has been deleted.

 

### How to fix it

Click the row with the red X to open the resolution dialog.

 

**If the defined name is not found:**

- If you renamed it, choose Rename the defined name and pick the new name. The tags are reconnected
- If you deleted it on purpose, choose Delete related tags to clean up.
- If you deleted it by accident, undo the deletion in Excel (or restore an earlier version of the file) before you choose anything.

 

**If the tag setup is lost:**

The setup can't be restored. Delete the related tags and set up the table again with the table wizard.

 

 

### Related articles

[How to update defined names (named ranges) in Excel](https://wrepit.net/help-center/how-to-update-defined-names-named-ranges-in-excel?hsLang=en-us)

 

[How to delete defined names (named ranges) in Excel](https://wrepit.net/help-center/how-to-delete-defined-names-named-ranges-in-excel?hsLang=en-us)

- [General](https://wrepit.net/help-center/general?hsLang=en-us#main-content)

    - [Excel](https://wrepit.net/help-center/general?hsLang=en-us#excel)
    - [PDF](https://wrepit.net/help-center/general?hsLang=en-us#pdf)
    - [Word](https://wrepit.net/help-center/general?hsLang=en-us#word)
- [Reports](https://wrepit.net/help-center/reports?hsLang=en-us#main-content)

    - [Document Setup](https://wrepit.net/help-center/reports?hsLang=en-us#document-setup)
    - [Tables](https://wrepit.net/help-center/reports?hsLang=en-us#tables)
    - [Publishing](https://wrepit.net/help-center/reports?hsLang=en-us#publishing)
    - [Design Elements](https://wrepit.net/help-center/reports?hsLang=en-us#design-elements)
    - [Export](https://wrepit.net/help-center/reports?hsLang=en-us#export)
- [XBRL](https://wrepit.net/help-center/xbrl?hsLang=en-us#main-content)

    - [Setting up your taxonomy](https://wrepit.net/help-center/xbrl?hsLang=en-us#setting-up-your-taxonomy)
    - [Tagging your report](https://wrepit.net/help-center/xbrl?hsLang=en-us#tagging-your-report)
    - [Reference and troubleshooting](https://wrepit.net/help-center/xbrl?hsLang=en-us#reference-and-troubleshooting)
- [Account](https://wrepit.net/help-center/account?hsLang=en-us#main-content)

    - [Access](https://wrepit.net/help-center/account?hsLang=en-us#access)
    - [Users and Roles](https://wrepit.net/help-center/account?hsLang=en-us#users-and-roles)
- [Integrations and Add-ins](https://wrepit.net/help-center/integrations-and-add-ins?hsLang=en-us#main-content)

    - [Excel2Word (Word add-in)](https://wrepit.net/help-center/integrations-and-add-ins?hsLang=en-us#excel2word-word-add-in)
    - [Drafts (Word add-in)](https://wrepit.net/help-center/integrations-and-add-ins?hsLang=en-us#drafts-word-add-in)
- [Troubleshooting](https://wrepit.net/help-center/troubleshooting?hsLang=en-us#main-content)

    - [Word](https://wrepit.net/help-center/troubleshooting?hsLang=en-us#word)
    - [Drafts Word](https://wrepit.net/help-center/troubleshooting?hsLang=en-us#drafts-word)
    - [Sign-in and access](https://wrepit.net/help-center/troubleshooting?hsLang=en-us#sign-in-and-access)
    - [Drafts Excel](https://wrepit.net/help-center/troubleshooting?hsLang=en-us#drafts-excel)
- [Getting started](https://wrepit.net/help-center/getting-started?hsLang=en-us#main-content)

    - [Getting started for new users](https://wrepit.net/help-center/getting-started?hsLang=en-us#getting-started-for-new-users)

<https://www.facebook.com/> <https://www.twitter.com/> <https://www.instagram.com/> <https://podcasts.apple.com/> [mailto:email@email.com](mailto:email@email.com)

Copyright © 2025, Wrepit