View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Thief_ Thief_ is offline
external usenet poster
 
Posts: 25
Default Removing #NAME? from cells.

OJ,

That's will not work. Let me explain why:

Cell A1 before removing the addin:

=Mx(9,5)

This is a UDF in the addin.

Cell A1, with Calculation turned off, after removing the addin:

='H:\MxAddin.xla'!Mx(9,5)

I then need to remove the "'H:\MxAddin.xla'!" part by editing the cell so
that when the workbook loads on the target PC it doesn't ask to update
links. This act causes the cell to display #NAME?

Any other ideas?

--
|
+--Thief_
|


"OJ" wrote in message
oups.com...
Turn automatic calculation off.
OJ