Forum Discussion
Divide By Zero Error pop-up on web-based Excel
Quite frankly, what you describe sounds like its ripe for total redesign. I'm attaching a slightly dated article on design.....among other things, you will notice a strong emphasis on separate sections, if not separate tabs, for (a) input (b) logic or processing, and (c) output or reports or summaries. It sounds very much as if you're mixing all those.in on each sheet.
Other than that, to answer your question of what you can do about all those Division by Zero error messages: talk with the person who IS responsible for maintaining it.
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.
- SergeiBaklanAug 21, 2023Diamond Contributor
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.