Under "Copy cell values, cell formats, or formulas only" the help "If you
don't get the results that you want, you can also change the references in
the original formulas to either relative or absolute cell references and then
recopy the cells." is so, so, so lame. When you have many sheets highlighted,
you can't easily go back and make absolute.

Eg. If you F2-F4 in any cell, then it dumbly sets all highlighted sheets'
cells to the one value (how dumb). On the Paste Special there needs to be an
option to change the target relativity. With any of the existing ways to
change, each highlighed sheet is corrrupted to the first sheet's answer.
[When the highlighted cells contain different cell references].

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...lic.excel.misc

I couldn't agree more!

Excel should allow the option to Paste Special without updating the
references and keeping the exact same formulas as the in the original
(without having to turn the original into absolute ones).

This is useful when replicating tables that use slightly different
information sources but in which the bulk of the references are the same as
in the original table.


"themantheworldlovesmorethannathan" wrote:

Under "Copy cell values, cell formats, or formulas only" the help "If you
don't get the results that you want, you can also change the references in
the original formulas to either relative or absolute cell references and then
recopy the cells." is so, so, so lame. When you have many sheets highlighted,
you can't easily go back and make absolute.

Eg. If you F2-F4 in any cell, then it dumbly sets all highlighted sheets'
cells to the one value (how dumb). On the Paste Special there needs to be an
option to change the target relativity. With any of the existing ways to
change, each highlighed sheet is corrrupted to the first sheet's answer.
[When the highlighted cells contain different cell references].

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...lic.excel.misc