Vlookup Help

brettvba · Feb 28th, 2002, 06:56 PM

I have a spreadsheet with vlookups on it when i update the replace the data the vlookup formulas change to #refs is there a way to not update the vlookups till after the update? Any Ideas?

NateO · Feb 28th, 2002, 07:53 PM

Try switching your calculation mode to manual. (tools->options->calculation, etc...)

Cheers, Nate

[ This Message was edited by: NateO on 2002-02-28 18:59 ]

brettvba · Feb 28th, 2002, 08:01 PM

Have tried that Didn't work so now I just have a macro to re do the vlookups just nasty.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Feb 28th, 2002, 06:56 PM	#1
brettvba MrExcel MVP Join Date: Feb 2002 Location: Christchurch New Zealand Posts: 1,030	I have a spreadsheet with vlookups on it when i update the replace the data the vlookup formulas change to #refs is there a way to not update the vlookups till after the update? Any Ideas?

Feb 28th, 2002, 07:53 PM	#2
NateO Legend Join Date: Feb 2002 Location: Minneapolis, Mn, USA Posts: 9,704	Try switching your calculation mode to manual. (tools->options->calculation, etc...) Cheers, Nate [ This Message was edited by: NateO on 2002-02-28 18:59 ]

Feb 28th, 2002, 08:01 PM	#3
brettvba MrExcel MVP Join Date: Feb 2002 Location: Christchurch New Zealand Posts: 1,030	Have tried that Didn't work so now I just have a macro to re do the vlookups just nasty.