Importing Metadata into Copied Worksheets

Before you begin, be sure to review the content in About Importing Metadata in Smart View.

Note:

Once the metadata from a source sheet is imported in a destination sheet, this operation cannot be undone.

To import metadata to a copied worksheet:

1. Back up your work.
2. Use Excel to copy a worksheet.

   This operation copies the visible contents of the source worksheet but not the metadata (connection information, POV selections, alias tables, and such items) to the destination worksheet.

3. Open the destination sheet.
4. With the destination worksheet active, from the Smart View ribbon, select More and then Import Metadata to display a list of all open workbooks and their corresponding open worksheets.
5. From the list, select the worksheet that contains the metadata that you want to import to the destination worksheet.
6. Click OK.
   A warning message appears informing that the metadata in the destination or the active sheet will be overwritten with the metadata from the source sheet. This operation cannot be undone.
7. Click Yes in the warning message.
8. Click Refresh.