To Update ComboBox

[Daniel Utsch]

How to do that a comboBox, update automatically? I have a comboBox, with the
ListFillRange be an interval of cells that name is "Fornecedor", in this
interval has the function (=OFFSET('Base Fornec'!$B$2;0;0;CONTA('Base
Fornec'!$B:$B)), but when these cells suffer modification or has add other
value in this interval, this comboBox doesn't update. The comboBox only
updates after me save the spreadsheet.

Thanks

 

[slarbie]

Have you checked whether the issue might be manual vs automatic calculation?

 

[Daniel Utsch]

Yes, I checked this, it is automatic.

Thanks

"slarbie" escreveu:

 

[Daniel Utsch]

Yes, I checked this, it is automatic.

Thanks

"slarbie" escreveu: