Moving sheets between workbooks
 

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

Is there some clever way of telling Excel that now everything
is right here, in this very workbook,

Edit, Links and Change Source, replacing links to other workbooks with the
active workbook itself.

--
Jim Rech
Excel MVP

If you have "My Documents" referenced in your formulas and you truly want to
just change the location where Excel looks for "My Documents", you may be
looking for this - right-click on your "My Documents" folder and in the
Target box type the new location, i.e. change "C:" to "E:".

Chris
Omaha

" wrote:

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

On Mon, 27 Dec 2004 07:41:02 -0800, ChrisJ wrote:

If you have "My Documents" referenced in your formulas and you truly want to
just change the location where Excel looks for "My Documents", you may be
looking for this - right-click on your "My Documents" folder and in the
Target box type the new location, i.e. change "C:" to "E:".

Well, it is mostly when I mail workbooks to colleagues and in
those workbooks there are references to cells in other
workbooks on my computer that the problems with absolute
references really mess things up.

It also gives me problems locally when I move or rename
a worksheet between workbooks on my own computers.
Sometimes I build a nice sheet and first copy it and then
rename it to be specific for a particular object that formulas
are replaced with #Ref or whatever, and I don't really get
much of a chance to update it nicely.



Lars
Stockholm