Operation must use an updateable query

[kristie ann]

Error when exporting data from access
Hey all,
I have exported data from an access table to excel using a macro, which is working perfect. The data in the access table is being gathered from a web front end.

However, when I have my excel worksheet open, and at the same time try to make changes to the underlying database I keep getting the error
Operation must use an updateable query

Is there any way to solve this problem so that I won't get this error in the web front end

Thanks
Kristie ann