Bloomberg DDE Functions in Excel - BLPH function specifically

[shady757]

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!

 

[zeb]

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