I understand that I can query it, but can I modify the underlying data
from Excel?


ilia wrote:
You can use MS Query to get into an Access database, in which case you
can query it in any way you want.