Link Access table to Excel worksheet

I want to link these so that they can be edited in either programme.
Whichever way, the link box is greyed out.

You can make a linked table in Access. It's File - Get External Data -
Link. The data lives in the Excel workbook, I think (I don't think Access
keeps a copy of it). But you can change data in either Excel or Access.

--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"dalesrunner" <dalesrunner@discussions.microsoft.com> wrote in message
news:A165D6C6-D173-45F7-94D5-352E3AA5121E@microsoft.com...
>I want to link these so that they can be edited in either programme.
> Whichever way, the link box is greyed out.