Bloomberg DDE Functions in Excel - BLPH function specifically

[Guest]

Hi -

I could use a little pointer for an issue I am having using Bloombergs DDE
functions in Excel... The external links to bloomberg wont stop updating no
matter what....

I am using a BLPH statement to download historical data for a bunch on
indices. I update all the data on our bloomberg term, then go back to my desk
to work on it. When I open the file I am prompted to update the links, and I
say no. But the cells that contain the BLPH statements (my most recent data
row) try to update anyway and end up with "#NAME?" in them.

I am using excel 2000

I have tried everything. I have tried going to "Tools> Options>
Calculations> " and unchecking the "Update remote references" box. It just
re-checks itself each time I open the file again.

I have also written a small snippet to try and override this

"Sub ChangePref()
ActiveWorkbook.UpdateRemoteReferences = False
End Sub"

Didnt work....

Anyone have any ideas how to maybe manually override this?

Thanks!

 

[Guest]

I'm having the same issue, have you found a solution? Thanks.

 

[wdgann]

First, open a new Excel file and set the spreadsheet to manual calculation (the default setting is autocalculate). Next, close the new file after saving. Finally, open the file with DDE link. You will notice the file will not auto-update.