Hi group,

More often than I like to admit I find that I have to
move a chart into another workbook, maybe even onto
another computer, with a slightly different file tree.

Then all links get messed up, of course.

Is there some clever way of telling Excel that now everything
is righ here, in this very workbook, or such?
Like "My Documents" are on E:, not C:!

And what about macros. I have quite simple macros that
are *in the workbook* where they will be used. Is there some
way to tell Excel to "Look no further, forget about that other
computer and that other file tree, everything you need is right
here. If you need a click somewhere let me know." ?



Lars
Stockholm