this is all in Word 2013 Pro + [15.0.4569.1504] under Win7 [6.1.7601].
legacy DOC (XLS) format documents.
have LINK fields with the following format:
{ LINK Excel.Sheet.8 "c:\\test\\test.xls" "Sheet19!A1:D11" /a /p }
Excel spreadsheet is in the same folder.
copying the two files to a different folder (test2) and updating the links causes the path to the spreadsheet to be updated automatically.
{ LINK Excel.Sheet.8 "c:\\test2\\test.xls" "Sheet19!A1:D11" /a /p }
saving the same files as DOCX (XLSM) format causes this updating to stop working.
{ LINK Excel.SheetBinaryMacroEnabled.12 "c:\\test\\test.xlsm" "Sheet19!A1:D11" /a /p }
using "Edit links to files" to update the links causes the range parameter to be lost
this is unacceptable for obvious reasons.
what am i misunderstanding?
how can i get this to work as it did?
mtia,
e. <;)
- Edited by exotericist 20 hours 9 minutes ago hmm