I've sucessfully set up an external data range in excel that points to an
access database query. It refreshes with no problem when making changes in
Access.

However I would like to be able to update cell values in excel & see the
changes reflected in the Access db. I've tried playing around with the
permissions but no matter what, any changes to data in excel get lost when
the refresh button is hit.

I'm sure I'm missing something . . .
Thanks in advance.