#NAME? - is there a way to stop this error message?

[m@cr0]

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

 

[Bob Phillips]

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]

tried that the #NAME? is still there even in manual calculation

 

[Bob Phillips]

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)