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" <[email protected]> wrote in message
news:[email protected]...
>I want to link these so that they can be edited in either programme.
> Whichever way, the link box is greyed out.