Bloomberg API Functions in Excel

[shady757]

Hi -

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

I am using a BLPH statement to download historical data for a bunch o
indices. I update all the data on our bloomberg term, then go back t
my desk to work on it. When I open the file I am prompted to updat
the links, and I say no. But the cells that contain the BLP
statements (my most recent data row) try to update anyway and end u
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. I
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

 

[Bob Buckland ?:-\)]

Hi Shady,

You may want to also post this in the MS Excel newsgroups
(link below).

=======

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! >>
--
LLet us know if this has helped you,

Bob Buckland ?
MS Office System Products MVP
*courtesy is not expensive and can pay big dividends8

A. Specific newsgroup/discussion group mentioned in this message:
news://msnews.microsoft.com/microsoft.public.excel
or via browser:
http://microsoft.com/communities/newsgroups/en-us/?dg=microsoft.public.excel

B. MS Office Community discussion/newsgroups via Web Browser
http://microsoft.com/office/community/en-us/default.mspx
or
Microsoft hosted newsgroups via Outlook Express/newsreader
news://msnews.microsoft.com