Save changes source - weird !!
 

Hi,

I have a master version of a file which is saved in a directory. In the
same directory I have a database of machines, speeds etc. For ref the master
file and database are stored in J:\Planification secteur
Precision\UP1\Production journaliere\Production journaliere.

Each month a copy is taken of the master file and saved into a sub directory
based on the year and month, (same address as above with\2010\01 on the end
for example). Production data is then filled in and the database is used to
reference the machine speeds etc. The formula to reference the speeds etc is

=IF($D7="";"";INDEX('J:\Planification secteur Precision\UP1\Production
journaliere\Production journaliere\[Base de
données.xls]Données'!$J$5:$J$25;MATCH($D7;'J:\Planification secteur
Precision\UP1\Production journaliere\Production journaliere\[Base de
données.xls]Données'!$I$5:$I$25;0)))

However when I copy the file from the directory to the desktop it changes
the address to look for the database - BUT there is no database in this
location AND it still returns a result!

=IF($D7="";"";INDEX('C:\Documents and Settings\duncali001\Desktop\[Base de
données.xls]Données'!$J$5:$J$25;MATCH($D7;'C:\Documents and
Settings\duncali001\Desktop\[Base de données.xls]Données'!$I$5:$I$25;0)))

All I have done is save the file to a different location.

Does anyone know how this can happen or how i can stop it?

Thanks
LiAD