The Sheet is not working?
The most common issue is that the user has pasted data into cells in a manner that has broken the script on the sheet.
Or, you have tried to make a copy of the sheet and are working on a copied sheet (this does not work for security reasons).
Since we are working in a google sheets environment if a user copy's and paste incorrectly it can break the function of the sheet without the user realizing.
The Correct Method is to copy and paste just the values in the selected cells.
- Ctrl+Shift+V (Windows/Chrome OS) or Cmd+Shift+V (macOS): Paste only the values of the Clipboard.
Incorrect Method is copy and pasting
- Ctrl+V (Windows/Chrome OS) or Cmd+V (macOS): Paste the contents of the Clipboard to the sheet.
Note: The wrong way will cause the script in the sheet to break and you will have to reproduce your sheet for the software to work.