|
|
#4
01-13-2021, 09:12 PM
|
||||
|
||||
It's not clear whether you mean 'edit' the Excel file or reference a different one. Either should be possible.
If editing is liable to result in a change in cell addresses, it'd be best to name each cell and refer to the range name in the Word link. That way, the link will follow wherever the range name in Excel points to. To use a different Excel file, you'd need to use Word's Edit Links function, which isn't normally visible. You can add its button to the QAT, or access it via File|Info.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Exporting data to an excel template | Stevie23 | Excel Programming | 3 | 04-05-2018 12:12 AM |
 Macro for exporting Word data to an excel register
|
Seb | Word VBA | 12 | 03-30-2017 07:30 PM |
| Exporting multiple data sets from a single Word Form into Excel | Tom Saylor | Word VBA | 6 | 09-11-2016 05:22 AM |
|
Exporting specific data fields from MS Word 2013 to a MS Excel 2013 spreadsheet
|
Labyrinth | Word | 7 | 07-19-2016 01:35 PM |
|
* Exporting Access Data to Excel
|
djreyrey | Excel Programming | 1 | 03-23-2012 10:03 PM |
Windows 10 
Office 2016
Threaded Mode