TransferSpreadsheet and not updateable query

[Autoeng]

I have an Excel file that is linked to a table in another Access db across our intranet (first tried direct linking to the Access table in the other db but that locked either myself or the other db users out, depending who got in the other db first. I understand that this is an intranet issue with Access db table linking). When I went to the Excel file link we no longer had the lockouts. Now because the Excel spreadsheet is linked our db opens only in exclusive mode so that only one user at a time can use it.

I wanted to go to TransferSpreadsheet to hopefully eliminate this problem but on import of the spreadsheet (just using a macro right now to test) I get the error message that the "Query must be updateable". The problem is that I cannot get data that I can alter. Is there any way around this?