Can formulas stay as they are when copied to MemoryStick?
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?
For my edification, could you or someone else please
explain (by example) what you mean by "links in formulas
and directories" that could affect a workbook when it is moved.
I am not aware of any feature of Excel that stores references
to files external to the xls file being processed. If such a
feature exists: (a) it should come as no surprise that it would
not work if the workbook is moved; and (b) such a failure would
not be limited to moving the workbook to a memory stick.
Such a feature would seem to make the workbook non-portable
-- incapable of transfering (in any usuable form) to any other
computer and perhaps to any other media (second disk, for
example).
|