linked excel file doesn't update as form

[m001]

I linked an Excel file to a table.
Changing the data in the table works fine.

But when I use this linked table in a subform (or a simple form), the data isn't entered in the Excel sheet...why?
The subform behaves normally and I can even ad several records in the subform but they don't transfer to the Excel sheet.

The subform works correctly because when I enter related information directly in Excel it shows in the subform.

How do I solve this problem?

I use the Excel sheet because Excel performs a specific calculation with the data entered, so I need this sheet..


Thank you for reading and eventually answering this question.

 

[Pat Hartman]

You cannot update a linked spreadsheet but I thought you could append rows to one.

Rethink your process. Have your data stored in Access and have the spreadsheet get its data from the Access table.