Range Names changing by themselves

[holysoul]

I everyone,

my problem is that I have many sheets (1 for each week of the year) an
in each i have like 550 defined range.

I need to acces these range for data compilation and everything seeme
to be working fine until 4-5 weeks ago...

now, the range names of the cells of one line is set to the line afte
and the cells where the range name should be is set to nothing (well..
g55 for exemple... back to normal state)

Exemple :
(range1) = "g55 "
(range2) = "what range1 sould be"
(range3) = "is OK"

and this problem appears to be random and append 1 or 2 times by shee
and only 1 or 2 sheet.

could it be releated to the performance of the computer running th
program?

Please try to Enlight me!

Holysou

 

[Dave Peterson]

I can't enlighten you--I've never used 550 names times 52 worksheets = 28,600
names!

And this won't help with your immediate problem, but will help in general:

Download Jan Karel Pieterse's (with Charles Williams and Matthew Henson) Name
Manager.

You can find it at:
NameManager.Zip from http://www.bmsltd.ie/mvp

====
You may want to post a little of your methodology. Maybe someone can look at it
and say: Just do this, this, and that. And your naming problems could go away.

(or maybe not!)