K Zox wrote ...

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?

Well, I don't see that you'd have to close MS Access, just release
your connection/locks to the workbook. But, yes, the only way to
recalculate the formulas is to open the workbook in the Excel app and
trigger calculation from there. You could do this in an invisible
instance of Excel using automation from your MS Access app.

Jamie.

--