Copy requests and worksheets between workbooks
- You have until August 12, 2026 to migrate your workbooks from the legacy Report Builder to the new Report Builder. See convert your legacy workbooks for detailed information.
- With the end of life of the Adobe Analytics 1.4 API’s, the legacy Report Builder add-in will no longer be available for download.
- After August 12, 2026, customers with workbooks requiring migration will need to contact customer support to obtain the orignial workbooks. These workbooks will need to be migrated as documented in convert your legacy workbooks.
Copy an entire spreadsheet in a source workbook to a spreadsheet in one or more target workbooks. To do this, you must have at least two workbooks opened in the same instance of Excel:
-
The first source workbook contains a spreadsheet (worksheet) with requests mapped to cells.
-
The additional target workbooks are the destinations. For each new target workbook, you should log in to the same report suite as the source workbook before you can paste spreadsheets containing requests.
-
Right-click the spreadsheet in the source workbook and select Copy Worksheet w/Requests.
-
In the destination workbook, right-click the spreadsheet and select Paste Worksheet w/Requests.
The same instance of Excel means that only a single Excel process ( excel.exe) is running on your computer at a time. If you launch two instances of Excel and attempt to copy a worksheet from a workbook in the first instance of Excel to a workbook in the second instance of Excel, Report Builder does not present the option to paste a worksheet in the shortcut menu of the second instance of Excel.
If you log in to the source and target workbooks using different report suites, the only results you see from the paste operation are those affecting the formatting of the target workbook. Report Builder displays a message stating that the information for the requests derived from a specified report suite (in the source workbook) is not available in the target workbook. To reveal the requests pasted to the target workbook, you must log in to the target workbook using the same report suite as the source workbook.
You can copy and paste one or more requests from a spreadsheet in one workbook to a spreadsheet in another workbook, as long as the second workbook is open as another document in the same instance of Excel. The requests in both workbooks must be created using the same report suite login.