Solved

Recovering value linked to no longer existent workbook

Posted on 2013-02-06
3
155 Views
Last Modified: 2013-03-20
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.
0
Comment
Question by:PavelTMN
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 43

Expert Comment

by:Saqib Husain, Syed
ID: 38862842
Copy and paste-special with values in the same place.
0
 
LVL 1

Author Comment

by:PavelTMN
ID: 38866926
It substitutes the whole formula with the final value and I want to only recover the referenced part.
0
 
LVL 43

Accepted Solution

by:
Saqib Husain, Syed earned 500 total points
ID: 38866986
I think that the only way to do that is to get the result of the formula and then back calculate it.

Excel stores, for each cell,
 - the formula and
 - the last calculated result

It does not store results of all components. So to get a part of the formula it needs recalculation which involves retrieving values of the variables and that is only possible if the source is available.
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction While answering a recent question (http:/Q_27311462.html), I created an alternative function to the Excel Concatenate() function that you might find useful.  I tested several solutions and share the results in this article as well as t…
Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

735 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question