DDE links to embedded spreadsheet fail when file reopened

Writing a book, Automating Document Production - Discuss your special needs here

DDE links to embedded spreadsheet fail when file reopened

Postby david.corley1 » Thu Mar 28, 2019 4:04 pm

Inserted a small calc spreadsheet (.ods) into a writer document. Insert/Object/OLE Object-Create from file.
Copied a cell and pasted it into the writer document Edit/Paste Special/DDE Link. Creates a 1x1 table.

This works perfectly. When the spreadsheet changes, the linked tables are updated.
Save the document (ODT format) and close.

Reopen the document.
Links no longer work. Paste special no longer works.

I have searched and browsed but could not find anything quite like this.

Can this be fixed? Is there another way to accomplish this? Any advice appreciated.
OpenOffice 4.1.6 on Windows 10 Home
david.corley1
 
Posts: 2
Joined: Thu Mar 28, 2019 3:46 pm

Re: DDE links to embedded spreadsheet fail when file reopene

Postby david.corley1 » Thu Mar 28, 2019 10:50 pm

PS. There is a popup asking to update links. Replying Yes or No does not seem to make a difference.
OpenOffice 4.1.6 on Windows 10 Home
david.corley1
 
Posts: 2
Joined: Thu Mar 28, 2019 3:46 pm


Return to Advanced Uses

Who is online

Users browsing this forum: No registered users and 0 guests