On May 10, 2:29 pm, "Ron de Bruin" wrote:
Can't you open the file in 2003 on another machine and change the name ?

If this is working I can help you with a macro to chnage the names in all workbooks

--

Regards Ron de Bruinhttp://www.rondebruin.nl/tips.htm

"Reeza" wrote in ooglegroups.com...
On May 10, 1:24 pm, "Ron de Bruin" wrote:
Hi Reeza

You can change the name in all workbooks in Excel 2003 with a macro maybe ?.
If you want me to take a look at one of the files on my system
send the file to me private.

--

Regards Ron de Bruinhttp://www.rondebruin.nl/tips.htm

"Reeza" wrote in oglegroups.com...
Hi All,

I have about 800+ excel workbooks, with an apparent problem. If I
open one of the files in excel 07 it gives me an error message, Name
Conflict
Name cannot be the same as a built-in name
Old name=print_area
new name=

Problem is i don't want to manually go and change all 800 files, any
way around this?

Thanks,
Reeza

Catch 22..Confidential data, but can't open the file to clear the data
without first fixing the problem :)

Reeza

Excel prompts you to change the name, can't open the file without
changing the name first actually.

It appears to be a range named print_area which conflicts with a built
in variable in excel. We upgraded all our computers this morning, but
I'll do one on my personal computer tonight and send it over. Thanks
Ron.

Reeza