Introduction
With the SAC add-in, you have the capability to duplicate existing tables within a workbook. When you duplicate a table, you eliminate the need to retrace your steps for navigating to the data source after insertion. The SAC add-in also includes quick options to remove any unwanted tables from the worksheet or the workbook.
Copy/Paste Table
To copy an existing table and paste it in the same workbook:
1
Select a cell in the table you want to copy.
2
From the Table group within the SAP Analytics Cloud tab expand the Copy Table.
3
Select Copy Table.
Note
The Copy Table option will only be active if you have a cell selected within a table. Additionally, this option will only be active if the table has been refreshed and is not in the mass data entry mode utilized for planning.
4
Select an empty cell within the sheet that you want to paste the table to.
5
Expand the Copy Table button and choose Paste Table.
Note
If the table you copied and pasted is a table with variables, the variable prompt window will appear so that you are able to define variable values as needed.
Copy/Paste Dimensions
There are some limitations related to where you can paste a copied table, including the platform and application. Please refer to the table below for more information.
| Location | Paste? |
|---|---|
|
Same Worksheet |
|
|
Same Workbook |
|
|
Different Workbook |
|
|
A Different Platform (Excel Online or Desktop) |
|
|
A Different Application (PowerPoint or SAC Story) |
|
Delete a Table
To delete a table from a sheet:
1
Select a cell within the table you want to delete.
2
From the Table group within the SAP Analytics Cloud tab, click Remove Table.
3
Confirm that you want to remove the table.
