M
myname
Hello,
I discovered something quite disturbing about the way
Excel handles paths in formulas.
I have a few directories/sub-directories with Excel
files in them, with external links in formulas between them.
If I move them to another place :
- the "external links" remain correct for the formulas
containing paths that go "down" (= pointing to sub-directories)
- all external links pointing "up" (to the directory above the file)
are broken !!!
How can I fix that ?!?
Thanks !
I discovered something quite disturbing about the way
Excel handles paths in formulas.
I have a few directories/sub-directories with Excel
files in them, with external links in formulas between them.
If I move them to another place :
- the "external links" remain correct for the formulas
containing paths that go "down" (= pointing to sub-directories)
- all external links pointing "up" (to the directory above the file)
are broken !!!
How can I fix that ?!?
Thanks !