Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Name error messages...
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Name error messages...
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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Name error messages...
Thank you. I have read the help file and it does not seem to help because it
only happens when I first go in. I am not familar with the "clearing protocol". Will help files give me info on that. Thank you for your prompt repsonse. Thank you. "CLR" wrote: 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. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Name error messages...
"Clearing protocol" is just my feeble description of the manual process you
go through to fix the problem each time.......one other thought.....the file may be being left in a "manual caluclate" condition by some of the other users.........maybe a macro adjustment to insure that it recalcs before saving might help. Vaya con Dios, Chuck, CABGx3 "Corkey" wrote: Thank you. I have read the help file and it does not seem to help because it only happens when I first go in. I am not familar with the "clearing protocol". Will help files give me info on that. Thank you for your prompt repsonse. Thank you. "CLR" wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Error messages not printing | Excel Discussion (Misc queries) | |||
Error Messages | Excel Discussion (Misc queries) | |||
error messages | Excel Discussion (Misc queries) | |||
Error Messages | Excel Worksheet Functions | |||
Error Messages | Excel Worksheet Functions |