D A P I < G O > Help Page

Error Codes

#N/A Authorization

The #N/A Authorization error occurs because you or your Bloomberg terminal are not authorized to download the data using
the Bloomberg API.

Possible Cause Resolution

You are attempting to use a data field Confirm that the data field can be used in Bloomberg formulas by
that is not in the API. searching for the field on the Field Search (FLDS) function. In the Source
menu, ensure that API is selected, then search for the field.

For more information on searching for data fields on FLDS, see the FLDS
Help Page.

You are attempting to import real- To import real-time data, you must be enabled for the appropriate real-
time technical analysis data, but you time exchange entitlements for the securities in your formulas. To
are not enabled for real-time data for determine what subscriptions are required for a specific security, load the
the security. security in Bloomberg and enter EXC <GO> to access the Current
Exchange Subscription (EXC) function. After reviewing the required
subscriptions, you can subscribe to the appropriate exchange products on
the Exchange Information System (EIS) function.

For more information on EXC, see the EXC Help Page. For more
information on EIS, see the EIS Help Page.

You have a limited functionality You must change your Bloomberg subscription to download data.
terminal or login that is not allowed
to receive API data.

If the error persists, contact the Bloomberg Help Desk. For more information on receiving live help, see Getting Live Help.

#N/A Array Size Limit

The #N/A Array Size Limit error occurs because the size of the array imported to your spreadsheet exceeds Excel's displayable
limit. During array generation, data results are returned in a single string.

Possible Cause Resolution

2
 D A P I < G O > Help Page

Possible Cause Resolution

A formula (e.g, BDH/BDS with the Use parameters in the formula to limit the amount of imported data. The
parameter "Array=True", BQR, or maximum array output depends on the Excel version and formula type, but
BMatrixArray) has generated an array is generally limited to 32K characters.
that is too large for Excel to display.

Note: The output string also contains application marker data in addition
to the actual data result, so be aware that more counts toward the
character limit than just the data itself.

#N/A BQL Compute Capacity

Bloomberg allows a fixed amount of BQL compute runtime per month to each user via the Bloomberg Desktop API to ensure
resource optimization.

For capacity errors related to non-BQL queries: #N/A Review (Capacity).

Error Possible Cause Resolution

#N/A Query Timed Out Your BQL query has exceeded the Optimize your BQL query to take
BQL response time limit. less time to complete. For more:
Help on BQL for Excel.

#N/A BQL Compute Capacity You have exceeded your monthly Contact the Bloomberg Help Desk
BQL compute allocation for BQL by pressing the <Help> key twice.
requests to download Bloomberg For information on receiving live
data via the Desktop API. Your help while using Excel, see Getting
monthly BQL compute allocation Live Help.
resets at the beginning of each
month.

#N/A Calculating

For BInterpol formulas, the #N/A Calculating indicates the formula is calculating the value.

Possible Cause Resolution

3
 D A P I < G O > Help Page

Possible Cause Resolution

A BInterpol is calculating. Wait for the data to be imported.

If the error persists, run the Diagnostics tool. When diagnostics are
complete, click the Repair button.

Note: If a dialog box appears that says "API Diagnostics will now launch
the Bloomberg .NET diagnostics Tool," click the No button to skip.

For more information on using the Diagnostics tool, see Diagnostics.

If the error persists, contact the Bloomberg Help Desk. For more information on receiving live help, see Getting Live Help.

#N/A CNV

The #N/A CNV error message is a momentary error code that occurs when a sheet created in one API version is opened in a
different version (e.g. v2 API sheet opened in v3 API or vice-versa).

Possible Cause Resolution

Excel is in manual calculation mode. Ensure that calculations are set to automatic. From the Formula ribbon,
select Calculation Options and make sure this is set to Automatic.

Other Bloomberg Add-Ins are Ensure that no other secondary Bloomberg Add-Ins are selected (e.g.,
selected in the Add-Ins section. Bloomberg Data Functions, blp, blph, blplib, bloombergvbe, etc.). Click
the Microsoft Office button/File tab, then click the Excel Options button,
select Add-Ins, and click the Go button.

If secondary Add-Ins are selected, deselect them, then confirm that the
appropriate Add-in is selected ("Bloomberg Excel Tools" -
[Link]).

A technical error has occurred. Run the Diagnostics tool. When diagnostics are complete, click the Repair
button.

Note: If a dialog box appears that says "API Diagnostics will now launch
the Bloomberg .NET diagnostics Tool," click the No button to skip.

For more information on using the Diagnostics tool, see Diagnostics.

4
 D A P I < G O > Help Page

If the error persists, contact the Bloomberg Help Desk. For more information on receiving live help, see Getting Live Help.

#N/A Connection

The #N/A Connection error occurs because the connection between [Link] and the dotnet API data provider has been
interrupted.

Possible Cause Resolution

The Excel connection to the bbcom Run the Diagnostics tool. When diagnostics are complete, click the Repair
server has been interrupted. button.

Note: If a dialog box appears that says "API Diagnostics will now launch
the Bloomberg .NET diagnostics Tool," click the No button to skip.

For more information on using the Diagnostics tool, see Diagnostics.

If the repair completes and the BBCOM attribute is red, enter CONN
<GO>, then ensure that API settings follow terminal settings is selected.

If the error persists, contact the Bloomberg Help Desk. For more information on receiving live help, see Getting Live Help.

#N/A End Date

The #N/A End Date error occurs because there is a problem with the end date parameter that is specified in the formula.

Possible Cause Resolution

No end date was indicated within the Include a valid end date in the formula. For more information on the
end date parameter. appropriate syntax for each Bloomberg formula type, see Constructing
Formulas.

The format of the date (or time, if Confirm the date format used in the formula is appropriate to your PC
included) is invalid. settings. From the Start menu of your PC, select Control Panel > Regional
and Language Options. Click the Customize button, then select the Date
tab. Ensure that the format that appears on this tab is consistent with the
format used in the formula.

5
 D A P I < G O > Help Page

Possible Cause Resolution

A Microsoft formula was used as the Confirm that you have the Analysis ToolPak selected to ensure that these
end date, but is not being formulas are recognized. Click the Microsoft Office button/File tab, then
recognized. click the Excel Options button. Select Add-Ins, then click the Go button.
Select Analysis Toolpak, then click the OK button.

Save the spreadsheet, then close and reopen the spreadsheet.

If the error persists, contact the Bloomberg Help Desk. For more information on receiving live help, see Getting Live Help.

#N/A Error Setting Target Range

For BQR formulas, the #N/A Error Setting Target Range indicates Bloomberg is unable to create the array.

Possible Cause Resolution

For BQR formulas, indicates Contact the Bloomberg Help Desk. For more information on receiving live
Bloomberg is unable to create the help, see Getting Live Help.
array.

#N/A Field Not Applicable

The #N/A Field Not Applicable error occurs because the data field used in the formula is not applicable for the specified
security.

Possible Cause Resolution

The data field is not compatible with Confirm that the data field can be used with the security's market sector by
the security's market sector. searching for the field on the Field Search (FLDS) function. In the Filter
menu, ensure that the security's market sector is selected, then search for
the field. If the field does not appear, then the field is not compatible.

For more information on searching for data fields on FLDS, see the FLDS
Help Page.

6
 D A P I < G O > Help Page

Possible Cause Resolution

The requested field data is not Confirm that the data field's calculation is supported by the security by
supported by the security. checking the corresponding function on the terminal that mimics the data
from the field. For example, attempting to import total return for a security
that displays the "Dividends not continuous. Unable to calculate total
return" message on the Total Return Analysis (TRA) function results in this
error.

For more information on TRA, see the TRA Help Page.

If the error persists, contact the Bloomberg Help Desk. For more information on receiving live help, see Getting Live Help.

#N/A Invalid Field

The #N/A Invalid Field error occurs because the data field mnemonic was not recognized.

Possible Cause Resolution

The data field in the formula is Confirm the spelling of the data field.
misspelled.

The data field in the formula is not in Confirm that the data field can be used in Bloomberg formulas by
the Bloomberg API. searching for the field on the Field Search (FLDS) function. In the Source
menu, ensure that API is selected, then search for the field. if the field
does not appear, then the field cannot be used.

For more information on searching for data fields on FLDS, see the FLDS
Help Page.

For BDH formulas: historical data was Confirm that the data field can be used to import historical data by
requested for a non-historical data searching for the field on FLDS. Click the field to display its definition and
field. to ensure that the phrase "historical data available" appears.

The field parameter in the formula is Confirm that the formula is constructed using the proper syntax. For more
not being referenced correctly. information on the syntax for each Bloomberg formula type, see
Constructing Formulas.

If the error persists, contact the Bloomberg Help Desk. For more information on receiving live help, see Getting Live Help.

#N/A Invalid Hash

For BQR formulas, #N/A Invalid Hash indicates Bloomberg detected a tampered/invalid hash.

7
 D A P I < G O > Help Page

Possible Cause Resolution

For BQR formulas, indicates Contact the Bloomberg Help Desk. For more information on receiving live
Bloomberg detected a help, see Getting Live Help.
tampered/invalid hash.

#N/A Invalid Input

For BQR formulas, #N/A Invalid Input indicates invalid parameters are included in the BQR formula.

Possible Cause Resolution

For BQR formulas, indicates invalid Confirm that all parameters are spelled correctly. For more information on
parameters are included in the BQR the valid BQR parameters, see BQR (Quote Recap).
formula.

If the error persists, contact the Bloomberg Help Desk. For more information on receiving live help, see Getting Live Help.

#N/A Invalid Parameter

The #N/A Invalid Parameter error occurs because there is a problem with one or more of the parameters in the formula.

Possible Cause Resolution

An unrecognized parameter appears Confirm that all optional parameters are spelled correctly.
in the formula (for example, "BS"
instead of "BarSz").

An invalid value is supplied with an Confirm that valid values are supplied for each optional parameter. For
optional parameter (for example, more information on the valid values for each optional parameter of each
"FX=HORIZONTAL" instead of a Bloomberg formula type, see Constructing Formulas.
currency code like USD).

For BDH formulas: if using the FX Confirm that the currency code is correct. For more information on valid
parameter, the currency code is currency codes, see the CURR Help Page.
invalid and cannot be parsed.

For BDH intraday formulas: a non- Adjust the formula to use a valid intraday data field. For more information
supported data field is used in the on supported data fields in intraday bar formulas, see Intraday Bar Fields.
formula. For more information on supported data fields in intraday tick formulas,
see Intraday Tick Fields.

8
 D A P I < G O > Help Page

Possible Cause Resolution

For BDH intraday bar formulas: the Adjust the BarSz parameter to a number greater than 0.
Intraday bar size is zero or less than
zero (for example, "BarSz=0".

If the error persists, contact the Bloomberg Help Desk. For more information on receiving live help, see Getting Live Help.

#N/A Invalid Query

For BQR formulas, #N/A Invalid Query indicates the generated sql is not recognized by sqlite.

Possible Cause Resolution

For BQR formulas, indicates the Contact the Bloomberg Help Desk. For more information on receiving live
generated sql is not recognized by help, see Getting Live Help.
sqlite.

#N/A Invalid Request

For BQR formulas, #N/A Invalid Request indicates the request to API for historical data failed.

Possible Cause Resolution

For BQR formulas, indicates the Contact the Bloomberg Help Desk. For more information on receiving live
request to API for historical data help, see Getting Live Help.
failed.

#N/A Invalid Screen Name

#N/A Invalid Screen Name indicates the screen name is not valid.

Possible Cause Resolution

The screen name is not valid. Contact the Bloomberg Help Desk. For more information on receiving live
help, see Getting Live Help.

#N/A Invalid Security

The #N/A Invalid Security error occurs because the security in the formula was not recognized as a valid Bloomberg security.

Possible Cause Resolution

9
 D A P I < G O > Help Page

Possible Cause Resolution

The security is misspelled or the

Confirm the spelling of the security.
market sector is missing.

Confirm the referenced market sector/yellow key is correct.

Confirm the market sector/yellow key was spelled correctly (i.e.,

"Curncy" and "Comdty" are spelled differently in Bloomberg formulas
than they are on the Bloomberg keyboard).

Confirm that the correct security syntax was used. For more
information on security syntax, see Security Syntax.

The identifier type is not specified in Include the identifier type in the formula (e.g., "459200101 equity cusip").
the formula. For more information on identifier types, see Security Syntax.

The security identifier in the formula Confirm that the identifier loads a single unique security by attempting to
does not load a unique security on load the security on Bloomberg. If it is not unique, use a unique identifier:
Bloomberg.

Specify a default exchange on the Equity Exchange Defaults (CNDF)

function; or

Include the exchange code in the security identifier in the formula

(e.g., "459200101 US equity cusip").

If the error persists, contact the Bloomberg Help Desk. For more information on receiving live help, see Getting Live Help.

#N/A Missing Value

For BInterpol formulas, #N/A Missing Value indicates that there are missing X or Y values in the formula.

Possible Cause Resolution

For BInterpol formulas, indicates that Insert the missing values or use the Skip parameter to skip missing values.
there are missing X or Y values in the For more information on the BInterpol syntax and parameters, see
formula. BInterpol (Interpolation).

If the error persists, contact the Bloomberg Help Desk. For more information on receiving live help, see Getting Live Help.

#N/A N/A

The #N/A N/A error occurs because data is not available for the data field or date specified in the formula.

Possible Cause Resolution

10
 D A P I < G O > Help Page

Possible Cause Resolution

The data being requested is not Check the corresponding functionality on the Bloomberg terminal to
currently available on Bloomberg. ensure that the data you are attempting to import is available.

A pricing source was specified for a

If you specified the pricing source in the ticker (for example,
fixed income security for which you
are not authorized to download data. "EC527035 @CMAN Corp"), remove the pricing source from the
ticker. When no pricing source is specified, the formula attempts to
import data from the default pricing source selected for this security
on the Pricing Source Selection (PCS) function.

If you did not specify a pricing source in the ticker:

Choose another default pricing source for the security on PCS

<GO>.

Access the All Quotes (ALLQ) function for the security and select
a listed pricing source, then specify that pricing source in ticker
(for example, "EC527035 @CBBT Corp").

For more information on PCS, see the PCS Help Page. For more
information on ALLQ, see the ALLQ Help Page.

For BDH formulas: no historical or Verify that data is available historically:

intraday data is available for the
date(s) specified.
On the terminal, use such functions as Historical Price (HP) and Quote
Recap (QR) to check for historical data during the same time range.

In Excel, adjust the date and time range in the formula to check if
historical data is available.

For BDH formulas: you have selected No action is necessary.

this string as an explicit filler value for
non-trading periods e.g. "Fill=Error".

For BDP formulas: you are not To import real-time data, you must be enabled for the appropriate real-
enabled for real-time data for the time exchange entitlements for the securities in your formulas. To
security. determine what subscriptions are required for a specific security, load the
security in Bloomberg and enter EXC <GO> to access the Current
Exchange Subscription (EXC) function. After reviewing the required
subscriptions, you can subscribe to the appropriate exchange products on
the Exchange Information System (EIS) function.

For more information on EXC, see the EXC Help Page. For more
information on EIS, see the EIS Help Page.

11
 D A P I < G O > Help Page

If the error persists, contact the Bloomberg Help Desk. For more information on receiving live help, see Getting Live Help.

#N/A No Data

For BQR formulas, #N/A No Data indicates there is no data available for the security.

Possible Cause Resolution

For BQR formulas, indicates there is Use a different security.

no data available for the security.

If the error persists, contact the Bloomberg Help Desk. For more information on receiving live help, see Getting Live Help.

#N/A Out of Bounds

For BInterpol formulas, #N/A Out of Bounds indicates the interpolation point is outside the boundaries of the set of X values
and the Extrapolate parameter is not included in the formula.

Possible Cause Resolution

For BInterpol formulas, indicates the Use the Extrapolate parameter to set the extrapolation method to Flat or
interpolation point is outside the Linear. For more information on the BInterpol syntax and parameters, see
boundaries of the set of X values and BInterpol (Interpolation).
the Extrapolate parameter is not
included in the formula.

If the error persists, contact the Bloomberg Help Desk. For more information on receiving live help, see Getting Live Help.

#N/A QSP Privilege

The #N/A QSP Privilege occurs because you do not have permission to download certain data.

Possible Cause Resolution

You do not have privilege to Contact the Bloomberg Help Desk. For more information on receiving live
download CUSIP, CINS, and CGS ISIN help, see Getting Live Help.
securities identification data ("CGS
Data").

#N/A Real Time

The #N/A Real Time error occurs because realtime data is not available for the selected security.

Possible Cause Resolution

12
 D A P I < G O > Help Page

Possible Cause Resolution

The security has not been traded in Confirm that the security has had intraday pricing within the last thirty days
the last thirty days. using the Quote Recap (QR) function.

For more information on QR, see the QR Help Page.

The security is not priced in real time.

Confirm that the security has intraday pricing using QR.

Search on the Field Search (FLDS) function for equivalent static data
fields that can be used instead of real-time data fields (e.g., PX LAST
instead of LAST PRICE).
For more information on searching for data fields on FLDS, see the
FLDS Help Page.

If the error persists, contact the Bloomberg Help Desk. For more information on receiving live help, see Getting Live Help.

#N/A Refresh Failed

#N/A Refresh Failed indicates the data field used in a formula is a static field that is supposed to automatically refresh and the
refresh did not occur.

Possible Cause Resolution

The data field is a static field that is Refresh the data manually. On the Bloomberg ribbon, click Refresh
supposed to automatically refresh Workbooks.
and the refresh did not occur.

If the error persists, contact the Bloomberg Help Desk. For more information on receiving live help, see Getting Live Help.

#N/A Refresh Pending

#N/A Refresh Pending indicates the data field is a static field that is supposed to automatically refresh. If the Bloomberg server
does not have data, this error message appears and the field will attempt an automatic refresh a few seconds later.

Possible Cause Resolution

The data field is a static field that is Wait for the data to be refreshed.
supposed to automatically refresh. If
the Bloomberg server does not have
data, this error message appears and
the field will attempt an automatic
refresh a few seconds later.

13
 D A P I < G O > Help Page

If the error persists, contact the Bloomberg Help Desk. For more information on receiving live help, see Getting Live Help.

#N/A Repeat

For BInterpol formulas, #N/A Repeat indicates there are repeated X values within the formula.

Possible Cause Resolution

For BInterpol formulas, indicates Adjust the BInterpol formula to remove the repeating X values and their
there are repeated X values within the corresponding Y values or use the MultiX parameter to aggregate the
formula. repeated X values and create a new corresponding Y value. For more
information on the BInterpol syntax and parameters, see BInterpol
(Interpolation).

If the error persists, contact the Bloomberg Help Desk. For more information on receiving live help, see Getting Live Help.

#N/A Requesting Data

The #N/A Requesting Data message is the initial value that is placed in a cell when the formula (BDP, BDH, and BDS) first
attempts to import data. This message may remain if no value is returned by the dotnet API data provider or if there is a
problem with placing the data value into the Excel cell.

Possible Cause Resolution

This is a transient condition in Excel. On the Bloomberg ribbon, click Refresh Workbooks.

Excel is not calculating or refreshing Ensure that calculations are set to automatic. From the Formula ribbon,
the formula. select Calculation Options and make sure this is set to Automatic.

A technical error has occurred. Run the Diagnostics tool. When diagnostics are complete, click the Repair
button.

Note: If a dialog box appears that says "API Diagnostics will now launch
the Bloomberg .NET diagnostics Tool," click the No button to skip.

For more information on using the Diagnostics tool, see Diagnostics.

If the error persists, contact the Bloomberg Help Desk. For more information on receiving live help, see Getting Live Help.

#N/A Review (Capacity)

Bloomberg caps data requested via the API to prevent strain on the system. The following error messages appear in Microsoft®
Excel when your usage exceeds daily or real-time thresholds or otherwise requires review.

14
 D A P I < G O > Help Page

For capacity errors related to BQL queries: #N/A BQL Compute Capacity.

Error Message Possible Cause Resolution

#N/A Daily Capacity You have exceeded the daily capacity for See Daily Capacity Best Practices.
requests to download Bloomberg data via
the Desktop API.

The daily capacity resets at the beginning

of each day.

#N/A Review Your workflow requires a review by Contact the Bloomberg Help Desk by
Bloomberg. pressing the <Help> key twice. For
information on receiving live help while
using Excel, see Getting Live Help.

#N/A Limit: Real- You have exceeded the limit of 3,500

time concurrent real-time security If you have multiple workbooks
subscriptions/hits. open, close the additional
workbooks.

Reduce the number of formulas in

your workbook that use real-time
data fields.

Daily Capacity Best Practices

You can manage or avoid the #N/A Daily Capacity error by following these recommendations for reducing your data usage.

The Desktop API is designed to support custom analysis on your individual workstation. The daily capacity threshold exists to
maintain system stability for Bloomberg's network users and to ensure that Bloomberg clients are using the appropriate
product for their data needs.

For more: #N/A Review (Capacity).

The daily download capacity is 500,000 hits. A hit is defined as a security and field combination. For example, the query
=BDP("AAPL US Equity","PX_LAST") constitutes one hit. Every time the sheet is refreshed counts as an additional hit.

Spreadsheet Optimization
Reduce the number of fields and unique securities called in your spreadsheet.
Disable automatic calculation refreshing. For more: Refresh.
Disable Update on File Open for some or all functions. For more: Functions.
Avoid refreshing sheets unnecessarily.
Close sheets when they are not in use. Data requested by background tabs counts towards the daily capacity.

15
 D A P I < G O > Help Page

BQL
Bloomberg Query Language lets you screen, aggregate, backtest, and run statistical analysis on a large security list with a
single query. For example, instead of downloading 1,000 prices and then averaging them in your spreadsheet, you can use
BQL to download just the average, saving you 999 hits. For more: Help on BQL for Excel.

Note: You can request training by entering TRAI <GO>.

Terminal Solutions
The Bloomberg Terminal is continually enhanced with features that may reduce the need to download data. Contact your
Bloomberg Representative to discuss your current workflow and on-Terminal solutions that may be available.

For immediate assistance, press the <Help> key twice to start a chat with Bloomberg's live 24-hour Help Desk, who can
determine if you are eligible for a courtesy extension. The daily capacity resets at the beginning of each day.

#N/A Sort

For BInterpol formulas, #N/A Sort indicates the X values in the formula are not sorted.

Possible Cause Resolution

For BInterpol formulas, indicates the Sort the values manually within the BInterpol formula or use the Sort
X values in the formula are not parameter to sort the values automatically. For more information on the
sorted. BInterpol syntax and parameters, see BInterpol (Interpolation).

If the error persists, contact the Bloomberg Help Desk. For more information on receiving live help, see Getting Live Help.

#N/A Start Date

The #N/A Start Date error occurs because there is a problem with the start date parameter that is specified in the formula.

Possible Cause Resolution

No start date was indicated within the Include a valid start date in the formula. For more information on the
start date parameter. appropriate syntax for each Bloomberg formula type, see Constructing
Formulas.

The format of the date (or time, if Confirm the date format used in the formula is appropriate to your PC
included) is invalid. settings. From the Start menu of your PC, select Control Panel > Regional
and Language Options. Click the Customize button, then select the Date
tab. Ensure that the format that appears on this tab is consistent with the
format used in the formula.

16
 D A P I < G O > Help Page

Possible Cause Resolution

A Microsoft formula was used as the Confirm that you have the Analysis ToolPak selected to ensure that these
start date, but is not being formulas are recognized. Click the Microsoft Office button, then click the
recognized. Excel Options button. Select Add-Ins, then click the Go button. Select
Analysis Toolpak, then click the OK button.

Save the spreadsheet, then close and reopen the spreadsheet.

If the error persists, contact the Bloomberg Help Desk. For more information on receiving live help, see Getting Live Help.

#N/A Syntax Not Supported

#N/A Syntax Not Supported indicates the use of a Bloomberg formula as an embedded argument in a formula may not be
supported - for example, using a BDH formula (which would return a multi-cell result) as an argument in an "IF" formula
statement for comparison purposes.

Possible Cause Resolution

The use of a Bloomberg formula as Adjust the BDH formula within the IF() statement to contain a single date
an embedded argument in a formula reference so only one cell is being populated. This will allow the nested
may not be supported - for example, IF() statement to be evaluated. For more information on the BDH syntax,
using a BDH formula (which would see BDH (Historical Data).
return a multi-cell result) as an
argument in an "IF" formula
statement for comparison purposes.

If the error persists, contact the Bloomberg Help Desk. For more information on receiving live help, see Getting Live Help.

#N/A Terminated

#N/A Terminated indicates the subscription has been terminated by the BDP, BPGE, BTP, or BRB formula.

Possible Cause Resolution

The subscription has been terminated Contact the Bloomberg Help Desk. For more information on receiving live
by the BDP, BPGE, BTP, or BRB help, see Getting Live Help.
formula.

#N/A Time Out

The #N/A Time Out error occurs because a subscription request for a data field has timed out.

Possible Cause Resolution

17
 D A P I < G O > Help Page

Possible Cause Resolution

The Excel connection to the bbcom Run the Diagnostics tool. When diagnostics are complete, click the Repair
server has been interrupted. button.

Note: If a dialog box appears that says "API Diagnostics will now launch
the Bloomberg .NET diagnostics Tool," click the No button to skip.

For more information on using the Diagnostics tool, see Diagnostics.

If the repair completes and the BBCOM attribute is red, enter CONN
<GO>, then ensure that API settings follow terminal settings is selected.

Your request has timed out during Reduce the number of data fields or calculations within the formula.
processing. This typically occurs due
to the intensive nature of the
necessary calculations or too many
data fields within one request.

If the error persists, contact the Bloomberg Help Desk. For more information on receiving live help, see Getting Live Help.

#N/A Unclassified

#N/A Unclassified indicates an error with no known Excel classification has occurred.

Possible Cause Resolution

An error with no known Excel Contact the Bloomberg Help Desk. For more information on receiving live
classification has occurred. help, see Getting Live Help.

#N/A Unknown

The #N/A Unknown error occurs because data retrieval has failed and no other errors apply. The data provider has received a
new Bloomberg error code that it is not able to process correctly. A fatal error has occurred in the RTD data infrastructure
during data subscription or when a data tick is processed.

Possible Cause Resolution

18
 D A P I < G O > Help Page

Possible Cause Resolution

For BDH or BDS formulas: Excel has

Refresh the selected cells. Highlight the cells containing the error,
rejected the BDH/BDS updates
because it is in a busy state. then, from the Bloomberg ribbon, select Refresh Workbooks >
Refresh Selection.

Locate the formulas =TODAY() or =NOW() on your spreadsheet and

replace them with BTODAY() and BNOW(), respectively. You can use
the Excel Find & Replace tool to locate and replace.

If the error persists, contact the Bloomberg Help Desk. For more information on receiving live help, see Getting Live Help.

#N/A Unknown Error

For BQR formulas, #N/A Unknown Error indicates an unrecoverable error has occurred.

Possible Cause Resolution

For BQR formulas, indicates an Contact the Bloomberg Help Desk. For more information on receiving live
unrecoverable error has occurred. help, see Getting Live Help.

#N/A Unsupported Excel Version

For BQR formulas, #N/A Unsupported Excel Version indicates an unsupported version of Excel is being used.

Possible Cause Resolution

For BQR formulas, indicates an Use a supported version of Excel.

unsupported version of Excel is being
used.

If the error persists, contact the Bloomberg Help Desk. For more information on receiving live help, see Getting Live Help.

#NAME?

The #NAME? error occurs because Excel does not recognize the specified formula.

Possible Cause Resolution

19
 D A P I < G O > Help Page

Possible Cause Resolution

There is a known Microsoft issue with Use the Excel Find & Replace tool to locate and replace "=" with "=" (i.e.,
the automatic file converter. Opening replace the equal sign with itself). Click the Replace All button.
Excel 2007 files (xlsx or xlsm) in Excel
2003 will result in this error. There is
no fix anticipated from Microsoft.

For details, see

[Link]
id=945828.

Secondary Add-Ins are selected.

Ensure that no other secondary Bloomberg Add-Ins are selected
(e.g., Bloomberg Data Functions, blp, blph, blplib, bloombergvbe,
etc.). Click the Microsoft Office button/File tab, then click the Excel
Options button, select Add-Ins, and click the Go button.
If secondary add-ins are selected, deselect them, then confirm that
the appropriate add-in is selected ("Bloomberg Excel Tools" -
[Link]).

Run the Diagnostics tool. When diagnostics are complete, click the
Repair button.

Note: If a dialog box appears that says "API Diagnostics will now
launch the Bloomberg .NET diagnostics Tool," click the No button to
skip.

For more information on using the Diagnostics tool, see Diagnostics.

If the repair completes and the BBCOM attribute is red, enter CONN
<GO>, then ensure that API settings follow terminal settings is
selected.

20
 D A P I < G O > Help Page

Possible Cause Resolution

The spreadsheet was opened on a PC Use the Excel Find & Replace tool to locate and replace "=" with "=" (i.e.,
that does not have the Bloomberg replace the equal sign with itself). Click the Replace All button.
Add-In (or by a user who does not
have the add-in registered) and was
saved in this state.

If the user saves the sheet in this state

(i.e., with the #NAME? error), it will
remain in this state even when the file
is opened on another PC that has the
add-in present (e.g. file opened from
a shared drive).

Add-Ins need to be registered or re- Run the Diagnostics tool. When diagnostics are complete, click the Repair
registered. button.

Note: If a dialog box appears that says "API Diagnostics will now launch
the Bloomberg .NET diagnostics Tool," click the No button to skip.

For more information on using the Diagnostics tool, see Diagnostics.

If the error persists, contact the Bloomberg Help Desk. For more information on receiving live help, see Getting Live Help.

#REF!

#REF indicates an invalid link is referenced in the formula.

Possible Cause Resolution

An invalid link is referenced in the Confirm that the links are correctly referenced in the formula.
formula.

If the error persists, contact the Bloomberg Help Desk. For more information on receiving live help, see Getting Live Help.

BPUB/BPUBA & BPUP Codes

The following are possible codes that may appear when you enter new BPUB/BPUBA or BPUP formulas onto your spreadsheet
or refresh existing ones.

For additional codes that may appear, see Error Codes.

Error Code Description

21
 D A P I < G O > Help Page

Error Code Description

#N/A Published Data - N Succeeded, Publish event succeeded, with a count of how many specific fields
N Failed succeeded and how many failed. At least one field must have succeeded.

#N/A Publishing Data The resolution completed and a new event is published.

#N/A Publish Failed The publish event failed.

#N/A Resolving... The topic string was sent to be resolved. Resolving is the process of
normalizing your topic to a common identifier known by the rest of the
Bloomberg Platform architecture. Usually locally published topics are not
resolved (assumed to be already in normalized form), but still go through
the resolution step.

#N/A Resolution Succeeded The topic resolution succeeded.

#N/A Creating Topic... Topic in the process of creation.

#N/A Topic Creation Failed Topic creation failed due to an incorrectly passed value within one/several
parameters of the BPUB formula.

VBA Errors

You may receive a pop-up window with a VBA error message.

Possible Cause Resolution

An error has occurred that can be Run the Diagnostics tool. When diagnostics are complete, click the Repair
fixed by the Diagnostics tool. button.

Note: If a dialog box appears that says "API Diagnostics will now launch
the Bloomberg .NET diagnostics Tool," click the No button to skip.

For more information on using the Diagnostics tool, see Diagnostics.

22
 D A P I < G O > Help Page

Possible Cause Resolution

An error has occurred with a pre- Contact the Bloomberg Help Desk. For more information, see Getting Live
built Bloomberg spreadsheet such as Help.
those found on the Excel Template
Library (XLTP) or Bloomberg
Documents (DOCS) function.

For more information on XLTP, see

XLTP <Help>. For more information
on DOCS, see DOCS <Help>.

An error has occurred with a custom Confirm that the code is correct using the examples on the Bloomberg API
built spreadsheet that contains code Developer's Site (WAPI) function.
or macros.

For more information on WAPI, see the WAPI Help Page.

You refresh the spreadsheet during a Due to the nature of Microsoft Excel, Bloomberg formula static links do not
macro, but the data does not appear update while the VBA macro is running. Therefore, a refresh macro will not
until after it has finished. This may immediately return results. For a workaround, enter WAPI <GO> and
cause errors on a sheet using search for "Excel Topics" > "How can I programmatically update static RTD
calculations. links in Excel VBA?"

An error has occurred with a custom Confirm that the error is occurring due to the Bloomberg Add-In by
built spreadsheet that does not disabling the add-in. Click the Microsoft Office button/File tab, then click
contain code or macros. the Excel Options button, select Add-Ins, click the Go button, and deselect
the Bloomberg Excel Tools, then click the OK button.

If the error persists, this is not an issue with the Bloomberg Add-In.
Contact your internal IT department. If the error does not persist, contact
the Bloomberg Help Desk.

If the error persists, contact the Bloomberg Help Desk. For more information on receiving live help, see Getting Live Help.

23