cells full of #####

  • Thread starter Thread starter Joe Schmoe
  • Start date Start date
J

Joe Schmoe

I sent an Excel-2k spreadsheet to a friend and when she opens it up
a column of cells with calculated values has #name? in it. The cells
contain vlookup functions. I looked in the help for possible solutions
but none of them solved this. I remember fixing this once a while ago
and I just can't remember what it was - some obscure setting maybe?

Help!

Joe
 
Post a formula that returns an error

--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)
 
Try making the column wider.

Or, try increasing the Zoom (View Zoom) - the screen resolution may
differ between her computer and yours.

Pointer
 
Joe said:
I sent an Excel-2k spreadsheet to a friend and when she opens it up
a column of cells with calculated values has #name? in it. The cells
contain vlookup functions. I looked in the help for possible solutions
but none of them solved this. I remember fixing this once a while ago
and I just can't remember what it was - some obscure setting maybe?

Help!

Joe
Click to expand...

Joe,

copy the formula in the cell with #NAME? in this NG, maybe somebody can
help.

Do you use a UDF in the formula? May be this UDF is only in your
personal macro worksheet - this would be one possibility of creating
this error message.
 
Back
Top