VLookup Recalculating Every Time - Help
 

Is there a way to turn off the recalc on a vlookup function in a Spreadsheet.
I have turned off the Tools, Options and set Calc to Manual but that does
not seem to work.

Lajos

VLookup Recalculating Every Time - Help
 

Hi
normally this should do. What does exactly not work for you

--
Regards
Frank Kabel
Frankfurt, Germany

"Lajos Guta" schrieb im
Newsbeitrag ...
Is there a way to turn off the recalc on a vlookup function in a
Spreadsheet.
I have turned off the Tools, Options and set Calc to Manual but that
does
not seem to work.

Lajos

VLookup Recalculating Every Time - Help
 

Doing anything with this spreadsheet takes forever!! If I do a sort or even a
file save it recalculates and takes far too long...

Lajos

"Frank Kabel" wrote:

Hi
normally this should do. What does exactly not work for you

--
Regards
Frank Kabel
Frankfurt, Germany

"Lajos Guta" schrieb im
Newsbeitrag ...
Is there a way to turn off the recalc on a vlookup function in a
Spreadsheet.
I have turned off the Tools, Options and set Calc to Manual but that
does
not seem to work.

Lajos

VLookup Recalculating Every Time - Help
 

Hi
then you save Excel re-calculates automatically

--
Regards
Frank Kabel
Frankfurt, Germany

"Lajos Guta" schrieb im
Newsbeitrag ...
Doing anything with this spreadsheet takes forever!! If I do a sort
or even a
file save it recalculates and takes far too long...

Lajos

"Frank Kabel" wrote:

Hi
normally this should do. What does exactly not work for you

--
Regards
Frank Kabel
Frankfurt, Germany

"Lajos Guta" schrieb im
Newsbeitrag
...
Is there a way to turn off the recalc on a vlookup function in a
Spreadsheet.
I have turned off the Tools, Options and set Calc to Manual but
that
does
not seem to work.

Lajos