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