The problem is as follows:

I linked an Access table to a complex Excel spreadsheet (.xls). I also
built a custom Access form to browse and modify the data in that
table. Works fine, however the worksheet also has numerous calculated
cells (with formulas), and these formulas have no effect while I am
using the form. The only way to correctly update these cells is to
close my Access application, open the spreadsheet in Excel and save
it, which is a hardly acceptable process.

Is there a way for those formulas to update the corresponding cells
automatically, without having to close Access and open the sheet?

Thanks in advance!