If Book1 references Book2 in a formula and both books are open then the
formula takes a form such as =[Book2.xls]Sheet1!A1 The path to the file
does not display
Clearly this would not work with two files of the same name.

Why not adopt a naming convention such as April_Rev_2009 and April-Exp_2009
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email


"SPORTSFLT" wrote in message
...
Why doea EXCEL not allow two files with same names but in different
FOLDERS
to be opened at same time?

For example:

AAA\revenue\April-2009
AAA\expense\April-2209

Obviously, these are not the same files. And for me, it is much easier to
have my files, in different folder, have same name. Why can't EXCEL make
this
work. It is driving me crazy because I need to "link" most of my files and
I
cannot do so without renaming.

Please-please
--
BOB