Excel 2000: Worksheet's Vlookups don't update until I save the file? 1

[flugh]

I have a workbook that has been working for the last year. There a little VBA code, but mostly dirty hacks using vlookups (I keep swearing it'll go into an Access db Real Soon Now ;-)).

The other day I modified an existing, working bit of code that did Application.ScreenUpdating=False, deletes old information from all the worksheets (one for each day of the week), then at the end does Application.ScreenUpdating=True. Now, for whatever reason, I have to save the file for my vlookups to be displayed/updated on the screen. They are being done, and I can work with this, but why??

The modifications I made to the code where just expanding a selection that gets some vlookup formulas pasted into it. There's nothing fancy. It's all code stored in the workbook (not stuff in PERSONAL.XLS). Any thoughts?

----
JBR

 

[bmoremu]

My only advice is in Excel to check "Options", "Calculations", and make sure it's automatic. Not sure if this will have any affect if your vlookups are in VB though.

 

[flugh]

Hey, that did it! Thanks a pile! I'm curious as to how that option got changed. Guess if it's something in my code (has to be a side effect of my ugly hacks ;-)) I'll track it down eventually.

Thanks again!

----
JBR