Roger Govier wrote:
dorter wrote:
I copy my excel worksheet into a Mem. Stick. Then I work
mith my workbook in Memory Stick and save. When I copy
it back to my original computer, links in formulas and directories
change. What can I do to prevent this?

It is always safest to do any work with the file on your
local hard disk, rather than on a removable device.

Please explain how your cautionary suggestion relates to the
problem observed by the OP.

I wonder if you are referring to the risk of removing the media
without first allowing MS Win to complete the write to the media.
Yes, there is a risk of human error. Yes, your suggestion works
around that. To the end, it is not a bad suggestion. Of course,
the alternative is for people to be diligent about using the Eject
or Safely Remove Hardware feature or to disable the buffering
feature altogether (sigh, I forgot how).

But if that is what you are referring to, please explain how you
believe it is related to the OP's complaint that when the xls file
is worked on directly from the memory stick, then copied "back
to the original computer", "links in formulas ... change". Do
you think the OP is simply misinterpreting what happened?
That is, do you think the OP meant to write: the "links in
formulas" failed to retain their latest changes?

And what do think the OP means by "directories" (or "links in
directories"?) that changes in the xls file for whatever reason?
Honestly, I have no idea what "directories" (or "links in
directories"?) in an xls file could be affected even by the failure
to write buffered data to removable media.