Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Serach sequence for referenced files
Does anyone know the search sequence used by Excel to resolved referenced
files? Assume: C:\\my_dir\ref.xls C:\Documents and Settings\me\Application Data\Microsoft\Excel\XLSTART\ref.xls C:\\my_dir\sub_dir\ref.xls C:\my_dir\sub_dir\work.xls work.xls contains a reference to ref.xls. It seems that the file in XLSTART is the one loaded if it's there. But every now and then when opening work.xls, a long winded message to the effect the 'ref.xls. is already opened and another one cannot be opened etc... Sometimes not. I can't duplicate this at will, it just happens when it happens. If I quit Excel and try again, sometimes but not always, it goes away and things operate as expected. Sometimes moving the most recent version of ref.xls into position straightens it out. Could it be that if work.xls was last opened and saved loading a copy of ref.xls that was more recent than the copy Excel decided to load it would complain? This would be most inconvenient if it were the case. -- Terry "I said I never had much use for one, I never said I didn't know how to use one." M. Quigley |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Serach for multiple words in one cell | Excel Discussion (Misc queries) | |||
serach of dat | Excel Discussion (Misc queries) | |||
need value from referenced cell | Excel Worksheet Functions | |||
Please Help for a macro reading files not in sequence | Excel Discussion (Misc queries) | |||
Serach and Replace across multiple files | Excel Programming |