We have excel files sitting on a network where a cell in one spreadsheet
refers to a cell in another spreadsheet all on the same network drive("F").
However, the references keep switching from the "F" drive to the "C" drive
temp files as follows:

='C:\Documents and Settings\tmccorma\Application
Data\Microsoft\Excel\XLSTART\MAY-05\FINANCIALS\[MAY05 PRODUCTION.xls]LOS
ANGELES'!$S$13

We do have more than one person accessing the spreadsheet, but I wouldn't
think that would be a problem as the common drive is "F" on each computer.
Any ideas????