Feb 06 2018
06:35 AM
- last edited on
Jul 25 2018
10:58 AM
by
TechCommunityAP
Feb 06 2018
06:35 AM
- last edited on
Jul 25 2018
10:58 AM
by
TechCommunityAP
Hi, I'm using a simple search function "vert.zoeken" to retrieve a value from a second excel worksheet. If this value (in the second worksheet) is changed afterwards this must not be recalculated in the original sheet.
Is there a solution for this?
thanks
Paul
Feb 06 2018 06:54 AM
Hi Paul,
If you want the values you've retrieved don't change if the original values have changed, then you have to get rid of the formulas and keep the values of these formulas!
To do that, select the values in the original sheet, copy them, and paste them as values only!
Please read this article to learn how.