Multi-sheet editing is only available in ESG, FERC, and select SEC solutions. Reach out to your Customer Success Manager with any inquiries regarding this add-on.
Multi-sheet editing allows you to perform the same edit across multiple sheets in your spreadsheet. In the event that your edit action is not completed successfully, you can use the guide below to address these error messages.
|Table of contents|
|Unable to edit a locked section
|Unable to edit while in input mode
|Changes not applied to locked cells
|Couldn’t paste content
Restricted, locked, or View Only sheets
If any of the selected sheets are restricted, locked, or View Only, you may encounter the error messages below when attempting to make edits.
|Permissions denied||To request access, contact a spreadsheet Owner. To see a list of Owners, check out the Permissions on the File toolbar. Once an Owner has granted you permission of the section(s), you can continue editing.|
|Unable to edit a locked section||A file Owner or section Owner can select the locked sheet(s) in the outline and unlock them to allow editing to continue. Alternatively, you can remove the locked sheet(s) from your outline selection before using multi-sheet editing.|
Input cells in input mode
When a sheet is in input mode, changes can only be made to input cells. The following error can occur in multi-sheet editing when attempting to edit non-input cells with input mode enabled.
|Unable to edit while in input mode||You can’t perform this action on non-input cells for sheets with input mode enabled. Ensure that the input cells across all selected sheets have the same cell range before editing.|
Locked cells and incoming connections
The following errors occur in multi-sheet editing when certain edits are applied to locked or connected cells.
|Changes not applied to locked cells||One or more cells in your selection are locked. Unlock the cell(s) or make a new cell selection before editing. To view the locked cells, click Show Overlay on the View toolbar.|
|Changes not applied to locked cells||Your selection includes connected cells. The content in these cells in derived from another source, causing these cells to be locked in the sheet. To view the locked cells, click Show Overlay on the View toolbar.|
Cutting and pasting
The following error occurs in multi-sheet editing when attempting to cut content from one sheet and paste it into another sheet while multiple sheets are selected.
|Couldn’t paste content||While multiple sheets are selected, content must be pasted within the same sheet it was cut from. To paste content to a different sheet than it was cut from, select a single sheet in the outline before pasting.|