Home

Excel function to be executed only once

Highlighted
Paul Smets
Occasional Visitor

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

1 Reply

Re: Excel function to be executed only once

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.

Related Conversations
Cost estimator for small scale catering
Louisa Dira in Excel on
12 Replies
How to add the dates using the time criteria ?
Aditya Jadhav in Excel on
7 Replies
This calculation format driving me nuts
jjdrake in Excel on
6 Replies
Having an Issue with Excel hour/time formatting
Mike Button in Excel on
13 Replies
Need help with a conditional formatting equation
Daniel Desmarais in Excel on
7 Replies