Question: how to ignore all formula errors in excel?
Answer: Select the top-left first cell in the sheet that has the green triangle indicating the error. Scroll to the last bottom-right cell that has the error. ...  Go back to that first cell, there will be a clickable icon to do something about the error. Click on it and then click "Ignore Error"