I posted this in another forum, and I don't think I will get an answer there.

I have an xls (2003) excel spread sheet that calls data from another
application (DDE) like this:
=RSLINX|'PC2'!'ANA[201]'

and like this
=Rslinx|'EC2'!'ACT01'

This is standard DDE, and in 2003 and earlier it works. The application I am
calling is RSLINX, the topic(s) are PC2 and EC2, and th eitem names inside
those topics containing the values I want are ANA[201] and ACT01. The content
of both item names are 'REAL' numbers.

The problem is that when I save the spreadsheet as a macro enaabled file in
2007 it replaces
=Rslinx|'EC2'!ACT01

with
=Rslinx|'EC2'!_xlbgnm.ACT01

And it only does it for my topics that contain the letters/word "ACT", none
of the others.

Anyone know what is going on here? Is there a way to get Excel to stop
concatenating the "_xlbgnm." into my call?. If I delete the "_xlbgnm." from
the call, save, and reopen it comes back.

In the interim I plan on writing some code to replace the content of the
rewritten cells after opening. I'd really like to know what is going on
though.