Error message refers to Name that can't be found

R

RealGomer

I have a spreadsheet that another person created. When I go to save the
spreadsheet I get this message:

"The name, CLE1, either conflicts with a valid range reference or is invalid
for Excel. The name has been replaced with _CLE1.
You may still need to manually update any references to this name used in
VBA code or as text arguments in functions. You must close and reopen the
workbook before these changes take effect."

I've looked all through the spreadsheet and find nothing even remotely
related to this name. I check macros (none), VBA code, and hidden rows /
columns. Nothing.

How can I find this bugger?
 
×

מיכ×ל (מיקי) ×בידן

The "another person" probably created the WB in Excel prior to "2007".
I allow myself to guess that U R using 2007/2010 - and therefor CLE1 is a
valid CELL ADDRESS and therefor CANNOT be used as a name for a range
Micky
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top