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
|