Regarding the #NAME-errors you’re encountering: ensure that the cell ranges containing formulas are only locked (protected) for editing but not completely restricted from read access. Sometimes, read-only settings can interfere with the software’s compilation process.
If it still does not work, we would have to know one or more formulas that you are using.(you can post them in a Private Message for privacy reasons).