View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Frank Kabel Frank Kabel is offline
external usenet poster
 
Posts: 3,885
Default 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