Worksheet names are based on the Interactive Reporting BQY filename. Before exporting a section, consider the following limitations that apply to worksheet names:
The name of the exported BQY file cannot exceed thirty-one characters.
Duplicate worksheet names are appended with a number to ensure the uniqueness of each worksheet.
A worksheet name can include space symbols. When such a worksheet name is used in formulas, it should be surrounded with single quotation marks.
Generated range names that correspond to Interactive Reporting document table columns are based on a respective column name. The following restrictions apply to generated range names:
The worksheet name is added to the beginning of the range name to ensure its uniqueness within the whole workbook.
The symbols ~!@#$%^&*()_+|{}:”<>?`-=\[];’,./ are not allowed and are removed.
Duplicate range names are appended with a number to ensure the uniqueness of each range name.
Columns must have appropriate identifiers in JavaScript, for instance, an Order Date column can be referred to as Order_Date in a computed item expression. This identifier is used as the main part of a generated range name.
Excel has a limitation on the length of the expression used as a named range. The total length of the references (not including worksheet names) cannot be more than 255 characters. When a named range is generated, its content is broken into smaller chunks, each comprising a smaller named range. The final range is a union of these smaller ranges.