You need:
1. A table in Excel workbook, where all data editing in Excel is made. Let it be ExcelEditTable. NB! This must not be a result table of query you read data from Access into Excel!;
2. In case you use an ODBC query to read data from Access into Excel at start, then you'll have a query result table. Let it be ExcelImportTable. From this table you must get data into ExcelEditTable - coping data manually, using script, etc. In case you use some Access procedure to write data directly into ExcelEditTable, then you don't have this one;
3. In Access, a table where you need to save edited data finally. It is the table, you are using in Access forms, procedures, etc. (except the procedure updating data from AccessLinkedTable). Let it be AccessTable;
4. In Access, the read-only link (ODBC query) to ExcelEditTable in Excel workbook. Let it be AccessLinkedTable. From Access side, this table is used only by single procedure to update data in AccessTable;

Now my question - which one is the one you are trying to update (i.e. 'live table'), and is giving you this message?