Change in "paste link" from Excel source in Word 2007?

Tech-Archive recommends: Fix windows errors by optimizing your registry

I have a number of documents that contain pasted links to lengthy text
strings in Excel. First I'll give a thumbnail of the overall process, then
explain my issue.

We conduct a lot of surveys and keep the master data files in SPSS. I have
created processes that aggregate the data in SPSS and then dump the results
out into Excel. Since the save to Excel (at least at the time I wrote it)
always overwrites the existing file, I have a second spread*** read the raw
data from the first and perform certain corrections, resulting in a document
I can mailmerge into a template to automatically create tables. I have been
using Windows 2003 compatibility mode for these files because then I can use
DDE, and I am using DDE because then the source formatting I apply in Excel
is carried over to Word.

For open-ended comments, I bring those into Excel, then append them one
after the other with a hard return (char 13) in-between. The result used to
be that I could paste a link to a single cell in the Excel spread***, and
when it updated all of the comments would appear as a single, bulleted list.

All of the links that I put in place using Word 2003 continue to work in
this fashion. I attempted to add another link for a new field now after I
have updated to Word 2007, and it's not working the same. The link now is
pasted within a set of quotation marks. When I apply bullet formatting, it
will only apply the bullet to the first line of text; even though each item
appears on a separate line as before, something about the way it's pasted
doesn't allow me to apply formatting to it, even though it was inserted as
Paste Special>Unformatted Text.

I've played around with the Word options. I turned off smart quotes, I
turned off smart cursoring, I've turned off separate paragraph and page
breaks. Nevertheless, it keeps pasting in quotes.

I've read about a "paste text only" option, but even though I have "show
paste options buttons" turned on, I have never seen this option come up.

How can I get the link to work the way it did in Word 2003?

.

Quantcast