FILES IN excel
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 |
FILES IN excel
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 |
All times are GMT +1. The time now is 08:13 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com