The HELP file gives a list of things that might give you a clue as to why you
are getting the #NAME? error in the first place.........but if the trouble
persists, your "clearing" protocol, could be automated with a macro to save
some time.

Vaya con Dios,
Chuck, CABGx3



"Corkey" wrote:

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.