•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Calculated cells are not displayed when in protected mode
I'm generating an Excel file from software I'm writing. The spreadsheet contains numbers and some cells with formulas. This works fine.
But when users download these files, all the cells that contain formulas are not displayed. They are simply blank. Not until the user hits the Enable Editing button do the calculated values appear.
I understand this is some sort of protection. But I don't understand how hiding these cells protects anything. Is there any way to get these cells to appear when the spreadsheet is first downloaded and displayed.
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#formula generator