| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I stop excel from recalculating sheet every time I open one | Excel Discussion (Misc queries) | |||
| Can you stop a formula from recalculating the second time | Excel Discussion (Misc queries) | |||
| Stop Recalculating? | Excel Discussion (Misc queries) | |||
| time formatting and time categorizing (vlookup or data validation) | Excel Worksheet Functions | |||
| time formatting and time categorizing (vlookup or data validation) | Excel Worksheet Functions | |||
Linear Mode
