Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
#NAME? - is there a way to stop this error message?
one of the main functions that I use excel for is creating dsadduser sheets
for creating new activedirectory groups each semester with the change to excel 2007 though about 5 of the columns in a worksheet to create a dssaduser script show #NAME? for every cell. The data is still there if I click on any particular cell but it wont display unless I do click on it - this makes checking entered data a real pain obviously if I am creating a dssaduser script there will be 100's of names involved and I dont want to use the name function for each one. can anyone tell me a way to get the sheet just show column data instead of this #NAME? error code otherwise its back to excel 2003 -- Macr0 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
#NAME? - is there a way to stop this error message?
Is the spreadsheet in manual calculation mode?
-- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "m@cr0" wrote in message ... one of the main functions that I use excel for is creating dsadduser sheets for creating new activedirectory groups each semester with the change to excel 2007 though about 5 of the columns in a worksheet to create a dssaduser script show #NAME? for every cell. The data is still there if I click on any particular cell but it wont display unless I do click on it - this makes checking entered data a real pain obviously if I am creating a dssaduser script there will be 100's of names involved and I dont want to use the name function for each one. can anyone tell me a way to get the sheet just show column data instead of this #NAME? error code otherwise its back to excel 2003 -- Macr0 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
#NAME? - is there a way to stop this error message?
tried that the #NAME? is still there even in manual calculation
-- Macr0 "Bob Phillips" wrote: Is the spreadsheet in manual calculation mode? -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "m@cr0" wrote in message ... one of the main functions that I use excel for is creating dsadduser sheets for creating new activedirectory groups each semester with the change to excel 2007 though about 5 of the columns in a worksheet to create a dssaduser script show #NAME? for every cell. The data is still there if I click on any particular cell but it wont display unless I do click on it - this makes checking entered data a real pain obviously if I am creating a dssaduser script there will be 100's of names involved and I dont want to use the name function for each one. can anyone tell me a way to get the sheet just show column data instead of this #NAME? error code otherwise its back to excel 2003 -- Macr0 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
#NAME? - is there a way to stop this error message?
No, I mean it shouldn't be. When you F2 and it disappears suggests it might
be in manual mode, so switch to automatic. -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "m@cr0" wrote in message ... tried that the #NAME? is still there even in manual calculation -- Macr0 "Bob Phillips" wrote: Is the spreadsheet in manual calculation mode? -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "m@cr0" wrote in message ... one of the main functions that I use excel for is creating dsadduser sheets for creating new activedirectory groups each semester with the change to excel 2007 though about 5 of the columns in a worksheet to create a dssaduser script show #NAME? for every cell. The data is still there if I click on any particular cell but it wont display unless I do click on it - this makes checking entered data a real pain obviously if I am creating a dssaduser script there will be 100's of names involved and I dont want to use the name function for each one. can anyone tell me a way to get the sheet just show column data instead of this #NAME? error code otherwise its back to excel 2003 -- Macr0 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to stop a recurrent circular reference error message ? | Excel Discussion (Misc queries) | |||
How to stop the circular reference message from reappearing | Excel Discussion (Misc queries) | |||
Stop error message | Excel Discussion (Misc queries) | |||
changing the message in an error message | Excel Worksheet Functions | |||
How do I get rid of "Compile error in hidden module" error message | Excel Discussion (Misc queries) |