Hi,
I have a formula (i.e. =BDP("DE000A169G15 ISIN"; "YAS_BOND_YLD")) in a cell which retrieves data from an underlying data source (i.e. Bloomberg). When the Excel file is used on a computer on which Bloomberg is available, everything works well. However, I also want to use this Excel file on a computer on which no Bloomberg is available. In this case, the formula updates and gives me the value "#NAME?" due to lacking connection to Bloomberg.
Does anyone has an idea how it is possible that (a) the formula updates when the Excel file is on a computer with Bloomberg and (b) the formula takes the last available value (when it was refreshed on a computer with Bloomberg) when it is on a computer without Bloomberg, i.e. currently without connection to the underlying data source?
Many thanks in advance.