FG

Stop "Excel formula or sheet contains the name" dialog

Fresh3 days ago
Mar 15, 2026170944 views
Confidence Score0%
0%

Problem

When I want to copy a sheet (within the same file, so simply using left mouse button and Ctrl) in Excel 2007, I get this pop up dialog: where Author is a specific field somewhere in the sheet I'm editing. The catch is that I cannot get rid of this dialog. If I press Yes, I get the same dialog with …

Unverified for your environment

Select your OS to check compatibility.

1 Fix

Canonical Fix
Unverified Fix
New Fix – Awaiting Verification

Fix for: Stop "Excel formula or sheet contains the name" dialog

Low Risk

I had the same problem, but Name Manager does not reveal all the names embedded in the sheet. Somehow I got a bunch of hidden names in the worksheet. Here is how to unhide them Now, you can see again all names in Name Manager and delete them.

Awaiting Verification

Be the first to verify this fix

Sign in to verify this fix

Environment