How to create an Excel copy of your OfficeConnect Excel file that does not contain linked cells
This article includes suggestions and workarounds. Content may not be accurate for all use cases or represent best practices for the latest release.
Question
How to create an Excel copy of your OfficeConnect Excel file that does not contain linked cells?
Answer
Users can remove the metadata and linked cells from the OfficeConnect file by using the native Excel move or copy' sheet function.
- Right click on the excel tab(s) that contains linked cells
- Select Move or Copy. Under Move selected sheets - To book:' select (new book) or another Excel file and check Create a Copy. Select OK. (Notice that the copied tab does not contain linked cells)