If Excel has the worksheet open at the same time that Access is displaying a linked spreadsheet file's data you must close the table in Access before closing the worksheet in Excel; otherwise Access will display error values in the linked file.

Question

Quizplus · Accepted Answer

This is because Access locks the linked Excel file while it is displaying the data, and if the file is closed in Excel without first closing the table in Access, Access is unable to save any changes made to the Excel file, resulting in error values being displayed.

If Excel Has the Worksheet Open at the Same Time