Forum Discussion
Divide By Zero Error pop-up on web-based Excel
Thank you for your response. Unfortunately, nobody maintains these spreadsheets. They're simply copied with dates updated year after year. This has been going on since before I came to work here ten years ago. The original author is long gone.
Other than myself, I know of nobody here with the skill set to correct this. Given that we have 5,000+ employees, I'm certain there are people in other departments that do have such skills but this is not their responsibility either. Sadly, the desktop version of Excel, which we used up until two years ago, doesn't have this issue. I don't know why they introduced this pop-up in the web based version but since it wasn't needed before, they certainly should have given us an option to shut it off.
Once again, thanks for your assistance.
Some workaround could be to select entire sheet, or any range you wish (range shall include at least one error), from right click menu select Ignore Errors.