For Tom
The tip didn't work out couse the range name has this reference in an
external file.
" '[worksheet in presentation ]#ref!#ref "

If the worrkbook was small i will build it from the beginning
but i am working on it 3 months and i don't want to lose all the my job .

Actually Jan Karel Pieterse was the person I was quoting and he has
responded in the original thread as well - although you say the method did
not work. I also provided a URL to his name manager utility which you might
try downloading and trying.

--
Regards,
Tom Ogilvy

"gus" wrote in message
...
For Tom
The tip didn't work out couse the range name has this reference in an
external file.
" '[worksheet in presentation ]#ref!#ref "

If the worrkbook was small i will build it from the beginning
but i am working on it 3 months and i don't want to lose all the my job .

guru gus..

stick to your original thread pls?
and DONT USE CAPITALS which in every NG is considered yelling/screaming


keepITcool

< email : keepitcool chello nl (with @ and .)
< homepage: http://members.chello.nl/keepitcool


"gus" wrote:

Hi gus,

If the worrkbook was small i will build it from the beginning
but i am working on it 3 months and i don't want to lose all the my job .

ZIP it and send it to me, I'll have a look.

Regards,

Jan Karel Pieterse
Excel MVP