Could someone please tell me why I get the #name? error when I open the
spreadsheet? I run macros for comments and I have the workbook shared and
protected. But sometimes when I go into excel (not always) I get the #name?
error and have to unprotect, unshare and then click in a cell and hit enter
and then all the info shows up. It is very time consuming for me. Any
suggestions or ideas would be greatly appreciated.