Skip to main content

logoCorrectSize.png

Workday Adaptive Planning KB

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. 

  1. Right click on the excel tab(s) that contains linked cells

  2. 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) 

  • Was this article helpful?