I'm working with a new spreadsheet project in my company and am having an
issue. When I press F9 to update the formulas, it replaces every single
formula cell with #NAME?. What is the issue and how do I fix it.