Custom excel function not updating

Rated 3.83/5 based on 874 customer reviews

To check the setting, click the Formulas tab on the Excel Ribbon, and click the Calculate Options drop down.Or, go to the Excel Options window, and click Formulas.Even if the Calculation option is set for Manual, you can use a Ribbon command or keyboard shortcut to force a calculation.Click the Formulas tab on the Excel Ribbon, and click Calculate Now or Calculate Sheet.During a recalculation if Excel does evaluate the UDF it determines which cell references are actually being used inside the function to affect the function result, and if those cells have not yet been finally calculated it will reschedule the Function for later calculation.This is required to make the UDF be finally calculated in the correct dependency sequence.

In this case, the workbook calculation was set to Automatic on all the machines – that’s the first thing we checked.In Part 1 and Part 2 of Writing Efficient VBA UDFs I looked at some simple ways of changing the VBA code you write to make it run massively faster.In this post I look at a bug in Excel that slows down your UDFs and show you how to avoid it.A few years back I was having trouble working out why VBA UDFs ran so much faster on my PC than on someone else’s system (I think it was Jan Karel Pieterse’s).Eventually I tracked it down to the fact that I had Fast Excel installed.

Leave a Reply