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 Friday, March 20, 2015 11:16 AM hmm