Question for all you excel monkies...

[legoman666]

I have a custom function that populates a table of ampacity ratings. This is all well and good. However, when I make changes to the function, the table doesn't update unless I change/update the parameters of the function.

IE, "=currentFactor($A$2,35,1440)*$B4"
to get it to reflect the changes I just made to currentFactor, I have to change either A2, 35, 1440, or B4.

Is there a way to make Excel auto update after the function is changed?

 

[Mr Pickles]

Monkies?

 

[legoman666]

cucumbers?

 

[FoBoT]

wrong forum?

 

[loup garou]

hey hey we're the monkeeeees
:music:

 

[Linflas]

Originally posted by: legoman666
cucumbers?

Monkees are a rock group, monkeys are a group of primates, monkies are...?

 

[legoman666]

Originally posted by: Linflas

Originally posted by: legoman666
cucumbers?

Monkees are a rock group, monkeys are a group of primates, monkies are...?

the plural of monkey god dammit!
"Change the "Y" to an "I" and add an "E S" :music::music::music:

 

[kranky]

My understanding is that you can use VBA to force Excel to update. Or you can hit F9 which will recalc the entire workbook - that way you don't have to change any values to trigger the recalculation.

I assume that in Tools - Options - Calculation you already have it set for automatic.

 

[destrekor]

Originally posted by: legoman666

Originally posted by: Linflas

Originally posted by: legoman666
cucumbers?

Monkees are a rock group, monkeys are a group of primates, monkies are...?

the plural of monkey god dammit!
"Change the "Y" to an "I" and add an "E S" :music::music::music:

doesn't work like that for monkeys 😛

 

[BKLounger]

are you referring to automatic recalc?

tools > options > calculation > set it to automatic

*edit damn you kranky beat me by a minute.

 

[legoman666]

Originally posted by: kranky
My understanding is that you can use VBA to force Excel to update. Or you can hit F9 which will recalc the entire workbook - that way you don't have to change any values to trigger the recalculation.

I assume that in Tools - Options - Calculation you already have it set for automatic.

Hmmmm, pressing F9 doesn't force an update of my table. And yes, it's set to automatic.

Anyone know how to do this in VBA?

 

[Mr Pickles]

Originally posted by: legoman666
cucumbers?

Yeah see how that's spelled right and there's no overcompensation of grammar there?

 

[kranky]

Try adding this to your function.

 

[legoman666]

Originally posted by: MrLee

Originally posted by: legoman666
cucumbers?

Yeah see how that's spelled right and there's no overcompensation of grammar there?

pickles?

 

[prism]

it's spelled MONKEYS for the love of all that's holy!!

P.S. I shouldn't have said "holy" since I'm not in Oklahoma and I won't get a good grade now 🙁

 

[legoman666]

Originally posted by: kranky
Try adding this to your function.

Ahah! With that code in the function, now pressing F9 makes the table update. Thank you sir! Now is there anyway to make the table update without pressing F9 at all? Ideally, it would update the moment I save the changes to the function. If not, this is still 100x better than what I was doing.