An old question about Office 97 to Office XP upgrades and Bloomberg

[Echo]

I haven't been able to work this out myself, and I've searched the
groups and the web and haven't managed to come across an answer, so I'm
just going to ask. I'm really hoping that somebody here will have come
across this problem before!

In our office, we have a certain report that we run each day that
depends on values from Bloomberg. At the moment, we do the majority of
the report on our own computers, and once we get it to a certain point,
we go over to the old PC in the corner that has windows 2000 and Office
97, and Bloomberg to continue. We run a few spreadsheets on it, then
when we have the figures we need we go back to our own computers and
finish the report.

These old spreadsheets were made by someone who's since left the
company - the problem is that we can't get them to work on any of the
Windows XP bloomberg PCs. I've tried a few things but I can't work out
why it isn't working - it works fine on the old Win2000 machine, but
Excel simply refuses to properly update the values on the WinXP
machines, even though the plugins seem to be working fine.

I'll post more specific information about the problematic formulas
later if nessicary. Any suggestions or help at all would be very much
appriciated.

(BTW, hi, I'm new here )

 

[Echo]

Don't all answer at once now, heh.

 

[Echo]

Don't all answer at once now, heh.

 

[Echo]

Don't all answer at once now, heh.

 

[Tim Williams]

Need more details. Can you provide [the smallest possible piece of] code which works on 2K but not on XP?

Otherwise it's going to be very difficult to make any suggestions.

 

[Echo]

Unfortunately, part of the problem is that once you type a formula into
excel that uses the BLP function, the formula is "converted" in the
spreadsheet into a formula that is not very human readable. The exact
code that's causing a problem is:

=BLP(O3,$X$1:$AC$1,$R3:$W3,,"CH0010970793
Corp|CV_MODEL_BOND_VAL,CV_MODEL_OAS,CV_MODEL_CALC_TYP=3,CV_MODEL_STOCK_VOL,CV_MODEL_BORROW_COST=4,CV_MODEL_FIXED_INC_VAL!1428235970437"),

where O3 contains our ISIN - in this case, CH0010970793 Corp, and the
range X1 to AC1 are the headers:

CV_MODEL_BOND_VAL CV_MODEL_OAS CV_MODEL_CALC_TYP CV_MODEL_STOCK_VOL CV_MODEL_BORROW_COST CV_MODEL_FIXED_INC_VAL

R3 to W3 is the corresponding data to the headers:

Price Spread Calc Type Implied Borrow Fixed Income Value,

which we get from another process.

This all works fine on windows 2000; unfortunately, it's only on
Windows XP that we have a problem.

Need more details. Can you provide [the smallest possible piece of] code which works on 2K but not on XP?

Otherwise it's going to be very difficult to make any suggestions.

--
Tim Williams
Palo Alto, CA

I haven't been able to work this out myself, and I've searched the
groups and the web and haven't managed to come across an answer, so I'm
just going to ask. I'm really hoping that somebody here will have come
across this problem before!

In our office, we have a certain report that we run each day that
depends on values from Bloomberg. At the moment, we do the majority of
the report on our own computers, and once we get it to a certain point,
we go over to the old PC in the corner that has windows 2000 and Office
97, and Bloomberg to continue. We run a few spreadsheets on it, then
when we have the figures we need we go back to our own computers and
finish the report.

These old spreadsheets were made by someone who's since left the
company - the problem is that we can't get them to work on any of the
Windows XP bloomberg PCs. I've tried a few things but I can't work out
why it isn't working - it works fine on the old Win2000 machine, but
Excel simply refuses to properly update the values on the WinXP
machines, even though the plugins seem to be working fine.

I'll post more specific information about the problematic formulas
later if nessicary. Any suggestions or help at all would be very much
appriciated.

(BTW, hi, I'm new here )