when you link to a close file you use

='C:\myfolder[MyFiles.xls]Sheet1'!A1

so I suspect the

='C:\myfolder[My]Files.xls]Sheet1'!A1

would be problematic.

--
Regards,
Tom Ogilvy



wrote in message
oups.com...
Hi,

Why does microsoft office not allow certain chars in the file name?

i.e. '[', ']' is not allowed to be part of a file name.

I was just curious because i have a labelling format that uses '[' and
']'.

Maybe an excel guru could shed some light on this subject?