Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel (xls) files spontaneously converting to text files | Excel Discussion (Misc queries) | |||
Excel 2007 tmp files filling up drive with XLSM files | Excel Worksheet Functions | |||
How to change default Open/Files of Type to "Microsoft Excel Files | Excel Discussion (Misc queries) | |||
Opening Quattro Pro for Windows files (*.WB1 Files) using Excel 20 | Excel Discussion (Misc queries) | |||
Drive Erased, got Files back but only excel files scrambled, help. | Excel Discussion (Misc queries) |