•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Formulas are returning #NAME? errors on opening workbook in Excel 365.
If I click on one of the cells, click in the formula bar, and press enter without changing a single thing, it works. The workbook has thousands of rows, and I am not doing that for every single one of them. Ctrl+Alt+Shift+F9 to refresh does not fix the problem. Is there a fast automatic way to force the calculations to work?
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#rows.com
#Excel alternatives for data analysis
#Excel compatibility
#Excel alternatives
#natural language processing for spreadsheets
#AI formula generation techniques
#generative AI for data analysis
#formula generator
#Excel
#formulas
#workbook
##NAME?
#calculation
#formula bar
#refresh
#cells
#Ctrl+Alt+Shift+F9
#errors
#rows
#automatic