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," "," "," ")