Hi everyone,

In Excel, how would I go about linking one cell to another cell in a
different workbook? I understand I can type = then point it to the cell in
the other workbook, however my problem is everytime the location of the file
changes, the links mess up.

For example, I have this command to link to a file called grid:
=[grid.xlsx]Sheet1!$A$1

But when I want to move both the original file and the grid file to a
different location (for example on a memory stick), the link fails and tries
to point back to where the file was originally stored. Is it possible to use
an apsolute refrerence for the link - like I would do with cells, so it
always looks for the file 'grid.xlsx' in the folder?

I really need your help on this one, I'm sure it's easy enough it's just I
can't figure it out myself.

Thanks,

Tom :)