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, while 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.