Forum Discussion

Paul Smets's avatar
Paul Smets
Copper Contributor
Feb 06, 2018

Excel function to be executed only once

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

Excel Desktop
Formulas & Functions

1 Reply

  • Haytham Amairah's avatar
    Haytham Amairah
    Silver Contributor
    Feb 06, 2018

    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 https://support.office.com/en-us/article/paste-values-not-formulas-12687b4d-c79f-4137-b0cc-947c229c55b9 to learn how.

Resources