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

D

Deon Isis

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/com...dg=microsoft.public.excel.worksheet.functions
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top