See the following situation, I have a Workbook called “MÊS CORRENTE.xlsm” with the following values ​​in C3 and C4

I use these two values ​​in several other Workbooks, in each of them I created a Sheet called VBA which is in the same format as the image above, the only difference is that in C3 and C4 I have formulas that reference the C3 and C4 values ​​of “MÊS CORRENTE.xlsm”. However, I have a problem, when the Workbooks that use the C3 and C4 values ​​of “MÊS CORRENTE.xlsm” are open, if I update cell C3 or C4 in “MÊS CORRENTE.xlsm” save and close it, the cell does not update in Workbooks that contain the reference formula. How do I resolve this? If possible, it could be a line of VBA code, since the values ​​I already use in code, or an update to my formula.

Formula: ='\000.000.0.000PublicDOCSHualleyVBA[MÊS CORRENTE.xlsm]VBA'!C3

I already tried updating using CRTL+ALT+F9 but it still didn’t update, the two ways that worked were:

1 – Saving the changes made to “MÊS CORRENTE.xlsm” then closing, and then closing and reopening the spreadsheet that contains the reference formula

2 – Saving the changes made to “MÊS CORRENTE.xlsm” then closing, and accessing the cell that contains the formula, pressing F2 and then Enter

I know that when you open the Workbook containing the source of the formula it already updates, but in this case it is a shared Workbook, hence the problem of editing the source with more than one Workbook using it at same time.