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