Link FROM word table into excel table and have it update

The "Paste Link" option is grayed out, so I can't click that option. Help?

Linking Word Cell to Excel Cell: Prepare Your Excel File:

Open your Excel file and locate the cell you want to link to. Copy its address from the formula bar, e.g., A1. Inserting a Table or Text in Word:

Open your Word document. Place the cursor where you want to insert the text or table. Type the text or insert a small table containing the cell you want to link from. Select the Specific Word Cell:

Click on the specific cell in Word that you want to link from. Create the Link:

Go to the Insert tab in Word. Click on Hyperlink in the Links group. In the Insert Hyperlink dialog box: On the left, select Existing File or Web Page. In the Address field at the bottom, paste the Excel cell address you copied earlier, e.g., A1. Click OK to create the link. Steps in Detail: Prepare Your Excel File:

Open your Excel file. Select the cell you want to link to. Copy the cell address from the formula bar, e.g., A1. Inserting a Table or Text in Word:

Open your Word document. Place the cursor where you want to insert the text or table. Type the text or go to the Insert tab and select Table to insert a small table containing the cell you want to link from. Select the Specific Word Cell:

Click on the specific cell in Word that you want to link from. Create the Link:

Go to the Insert tab in Word. Click on Hyperlink in the Links group. In the Insert Hyperlink dialog box: On the left, select Existing File or Web Page. In the Address field at the bottom, paste the Excel cell address you copied earlier, e.g., A1. Click OK to create the link.

What about that?

Just select the cell content in the Word table then right-click the target cell in Excel & select the Paste Special> Paste Link command.

Reverse the process to link from Excel to Word, but you'd need to either:

• use the Paste Options button. or
• use the ▼ on the right edge off the Paste tool, or
• use Edit> Paste Special in the main menu & choose the Paste Link option..

Hi, appreciate your help! I'm running into an issue though.

I need to selectively select a cell within word and have it link to a different cell in Excel. I believe in the instructions you provided, you have to have the table in word match the table in excel? If not, need more help. I tried to link the excel to a single cell in word and it inserted the whole file. Any ideas?

Hi, thank you for reaching out. My name is Deeksha and I'm a Microsoft user like yourself and I will try to help you as best as I can today.

Link a Word Table to Excel on Mac: Open the Word document containing the table you want to link to Excel. If you haven’t inserted the table yet, go to the Insert tab and select Table to insert a table. Click on the table to select it. Link to Excel: Go to the Insert tab in Word. Click on Object in the Text group. Select From File. Navigate to and select the Excel file you want to link to. Check the box for Link to file. Click Insert. Adjust Linking: After inserting the Excel file, you can resize the embedded Excel object to show the specific range or cells you want to link to in Excel.

Update Excel Data from Word: To update the linked Excel data from Word, click on the linked table in Word and then click Update Link in the notification bar that appears. Update Specific Cells in Both Word and Excel: In Word: Click on the linked table. Make the desired changes to the table.

In Excel: Open the Excel workbook linked to the Word table. You will see the linked cells or range highlighted. The changes made in Word will be reflected in these cells in Excel.

Check: Update Link: Anytime you update the Word table, you will need to update the link in Excel to reflect the changes. Locked Cells: Make sure the cells in Excel that are linked to the Word table are not locked. If they are locked, you will not be able to update them.

Try these steps and hopefully, it resolves your issue. In case you need further help or assistance, please let us know. You can also contact Microsoft Support if the problem persists.

Best regards Deeksha