View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jim Cone Jim Cone is offline
external usenet poster
 
Posts: 3,290
Default custom addin gives #name? errors


RTFM and then try contacting the programs author.
Most programmers would want to know if their creations are having problems. (I would)
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)



"bh1"
wrote in message
I have a spreadsheet and addin file f.xla that an associate sent me as a
pair. In Excel 2003 the addin shows on the add in list. I check it but none
of the cells that use the functions in the addin sheet calculate. they all
end up with name errors.
for example one of the cells has the formula

{=TRANSPOSE(f.xla!xHXCross(WGIAU,Q74,Q71,Q70,Q75,R 75,R74,F71,F70,F75,G75,WGIAT,"ST"}
When I select the "show calculation steps" under the information button and
I select the "step out" the #NAME? shows up where the f.xla!xHXCross is in
the formula. If I continue stepping through the formula the #name? shows
as the result. When I look in the links and check the status of the f.xla
says "source is open"

I would like to know either a solution or a resource that might help me
figure out how to get the addin working correctly. my associate went over
the same setting I just told you about, said they did not know and gave up.
His works fine.

I have uncheked all the addins, closed excel reopened it and rechecked all
of them. That did not seem to help.

Thank you in advance for your assisatance.