Yup, linking the spreadsheet would be one way and I've done that. Can't recall if there were any issues around the Excel file being open at the time Access was trying to work on it.
Wondering why the data isn't presented in a form and the necessary entries made there. Forms are most useful for controlling data access and editing.
Also seems that calculated values will be stored in a table. Not sure about that...
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.