Importing Metadata into Copied Worksheets

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

Note:

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. 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.
4. From the list, select the worksheet that contains the metadata that you want to import to the destination worksheet.
5. Click OK.
6. Click Refresh.