Skip to main content
Documentation
Documentation
Workday User Guide
Last Updated: 2023-06-23
Merge Workbooks

Merge Workbooks

You can add the sheets from another workbook into an opened workbook if you're the owner or you have edit permission.
When merging workbooks:
  • Worksheets doesn't save the original, nonmerged workbook before adding sheets from the second workbook. If you want to keep your original workbook, copy it before merging.
  • If updatable data, such as from an entry area, exists in the workbook you're selecting to merge content from, Worksheets copies the values from that area but the data is no longer considered updatable data. This is the same as using a conventional spreadsheet
    paste as values
     action.
  1. Open the workbook that you want to contain all the content from both workbooks, then select
    File
    Merge Workbook
    .
  2. Navigate to the workbook that you want to merge into the open workbook and click
    Merge
    .

This content is not part of the Workday Administrator Guide.