Problem - hidden cell names in worksheet

B

Bigger

i all
I am having a strange issue with my excell file since a while. This is the
second year I am using it without problem. I start a workday with a new sheet
so every morning I just copy (Edit/Move or Copy Sheet) the latest sheet,
rename it and use it.
All of a suddent when I perform this operation I have a prompt that says "a
formula or sheet you want to move or copy contains the name 'aaa', which
exists in the destination worksheet. Do you want to use this version of the
name?"
I would hit yes to proceed, then I would get over 50 other prompts with
different names, and finally a new sheet.
My file contains a macro who basically inserts the current time in the
active cell. Apart from that there is no named cell.
Has anyone ever experienced such problem? How was it resolved?
Thanks you very much for your help.
 
A

Arvi Laanemets

Hi

Probably you accidentelly named some range - it may happen easily (you
activated Name field (the one where usually active cell address is
displayed, typed 'aaa', and hit Enter)

In Excel 2000 or like, select Insert>Name>Define (in Excel2007 it is in
different location, search help for 'Named Range'.
You see a list of defined names - delete all names 'aaa' (you see probably
one - for active sheet. When you delete it, the next one is displayed, etc.
delete until none is left.


Arvi Laanemets
 
B

Bigger

Arvi,
Thank you fr your response and sorry for not having replied soonner. I had
travelled for the ween-end.
I followed tthe path Insert>Name>Define, the Define name box is empty. no
name shows up.
I am using MS Office Excel 2003 and Windows XP Professional
Don't know what to do.
 

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