<div>
Copy and paste-special with values in the same place.
</div>


Copy and paste-special with values in the same place.

<div>
It substitutes the whole formula with the final value and I want to only recover the referenced part.
</div>


It substitutes the whole formula with the final value and I want to only recover the referenced part.

<div>
<div class="content wysiwyg-content">
Suppose I have a formula a part of which is a reference to another workbook that doesn't exist anymore. I know that despite the referenced workbook being absent the linked value is stored somewhere because if I change other parts of the formula it gets calculated properly. How do I replace the reference with the stored value?<br />
I tried F2 -&gt; F9 but it requires the linked workbook to exist.<br />
Thank you.
</div>
</div>


Suppose I have a formula a part of which is a reference to another workbook that doesn't exist anymore. I know that despite the referenced workbook being absent the linked value is stored somewhere because if I change other parts of the formula it gets calculated properly. How do I replace the reference with the stored value?
I tried F2 -> F9 but it requires the linked workbook to exist.
Thank you.

Recovering value linked to no longer existent workbook

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.