We will be migrating from Ask to Discourse on the first week of August, read the details here

Ask Your Question

Calc Paste Special Source: Unknown source - how to get data?

asked 2021-06-11 18:34:54 +0200

msc6575 gravatar image

updated 2021-06-12 15:36:29 +0200

I am trying to use the DDE function in Calc (on Windows 10), but when I try to use the Edit/Paste Special dialog, I see Source: Unknown source, and am only offered selections of Unformatted text and Use text import dialog (and not an option of link). Then, when I continue to the text import dialog, the cells contain =DDE calls, but the data is #N/A . So, does anyone have suggestions on how to cause data to appear in the cells?

edit retag flag offensive close merge delete


Do you have a clipboard manager? They often reduce the options available for pasting.

Earnest Al gravatar imageEarnest Al ( 2021-06-12 01:05:54 +0200 )edit

@Earnest Al, thanks for the reply. Today I encountered a helpful error message, "Automatic updating of external links has been disabled," and enabling links has resulted in data appearing in the cells. I've revised the question to more accurately describe my objective, to have data updates appear in the pasted cells.

msc6575 gravatar imagemsc6575 ( 2021-06-12 15:34:38 +0200 )edit

1 Answer

Sort by » oldest newest most voted

answered 2021-06-12 15:44:09 +0200

msc6575 gravatar image

I was able to see data in the cells by pasting in text containing =DDE calls from the clipboard, and then using the Edit/Links to External Files dialog box to set cells to automatically update.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2021-06-11 18:34:54 +0200

Seen: 29 times

Last updated: Jun 12