Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have a workbook that contains a Bloomberg formula (BLPH) which has to be opened and allowed to calculate on a Bloomberg terminal, saved, and then the user can select the saved file to import the results back at their own PC.

This has always worked fine within Excel 03 as the formula does not attempt to update so stores the returned values which are then imported into a database. However, now we need to use this on Excel 07 machines I am finding the formula result cannot be imported back at the user's PC because the result is automatically converted to a #NAME? error.

Is there a way around this without having to get the user to copy/paste values as this will interfere with some other functionality?

The formula in question is stated as:

='C:\blp\API\dde\blph.xla'!BLPH($A2,$B2,$C2,$C2,0,FALSE,"D"," "," ",FALSE,1,1,TRUE," "," "," ")
share|improve this question

migrated from Feb 27 '13 at 14:35

This question came from our site for professional and enthusiast programmers.

You may be running into Excel's safety first approach to changes in the calculation engine: when a workbook that was last calculated and saved in a previous version is opened in a later version it automatically does a full calculate.
The only way I know of to bypass this is via a registry change: see

share|improve this answer
Thanks, that sounds like exactly what the issue is. I can't enforce the version of Excel on the Bloomberg terminals but exporting the workbook in manual calc mode does get round this. I'll just have to train the users to hit F9 now! Thanks again – CrazyHorse Feb 27 '13 at 11:00

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.