Data source types: Planning, Planning Modules, Financial Consolidation and Close, Tax Reporting
When you place ranges on a multiple-grid worksheet, Excel assigns each range a name by default. The strings used in the name ranges may not be particularly user friendly. For example, a range based on the Vision Plan1 cube might look like this:
A more user-friendly name would be helpful for all users of the workbook, but changing the name using the Excel Name Manager could cause a loss of metadata in Oracle Smart View for Office.
Use the Rename Range command in the Smart View Document Contents pane to change the name to a more descriptive or user-friendly name.
Note:To change range names in multiple-grid worksheets, you must use the Rename Range command in the Document Contents pane.
To rename ranges on a multiple-grid worksheet:
If not already displayed, open the Document Contents pane.
For instructions on displaying the Document Contents pane, see step 1 in Changing Connections in EPM Cloud Multiple-Grid Worksheets.
In the Document Contents pane, highlight the range to rename in the tree, and then click Select.
In the following example,
Vision | Plan 1is highlighted in the tree.
Use the Select command to verify that you are working with the correct grid on the sheet. For example, after highlighting
Vision | Plan1and clicking Select, the Vision Plan1 grid on the worksheet is highlighted.
In the Action Panel, click More, and then select Rename Range.
The Rename Range dialog box is displayed, showing the default name that was assigned to the range by Excel.
In Rename Range, type a new range name, and then click OK.
We're renaming the range
Verify that the range name is changed in the Name Manager in Excel.
Here is an example Name Manager, accessed from the Formula ribbon in Excel:
You can also view the changed range name in the Excel Name Box drop-down list.