Hi
I have a spreadhseet that extracts data from Bloomberg via DDE. I have
another spreadsheet with a macro that copies and pastes the original
spreadsheet. In Office 2000, the Bloomberg spreadsheet would ask if we
wanted to update the links. We would say no and the stale data would be
available. In Excel 2003, it asks us if we want to update the links. We say
no and the DDE formula turns to an error rather than staying as the stale
data.
Is there a way around this?
The DDE formula is:
='C:\blp\API\dde\Blp.xla'!BLP($A2,B$1:C$1,,,BLP|M! 'GNSF 4.50 Mtge,[PX
LAST,LAST UPDATE]')