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

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

"Daniel Utsch" wrote:

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

Yes, I checked this, it is automatic.

Thanks

"slarbie" escreveu:

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

"Daniel Utsch" wrote:

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

Yes, I checked this, it is automatic.

Thanks

"slarbie" escreveu:

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

"Daniel Utsch" wrote:

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