When linking an excel spreadsheet to and Access database, is there anyway to
have the formulas that are set up to calculate in Excel transfer to Access.
The only way I can get them to update in Access is closing the Access
database and opening the Excel file. Is there an easier way?