In Excel: Paste Special should have a "Link Value" Selection
 

It would be handy in Microsoft Excel if there was a selection under Paste
Special that allowed you to paste the value of a link without pasting the
value for other formulas.

For example: I have a spreadsheet that pulls data from another database
file and performs numerous calculations on it. I have to e-mail this file to
others (who do not have the database so I have to remove the links).
Currently, I have to paste the values for everything, destroying the "base"
formulas. If I change any of the other values those formulas run on, it will
not change in this section.

----------------
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...et.f unctions