#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
|