Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
custom addin gives #name? errors
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
custom addin gives #name? errors
Just a complete guess...
Select the range that has the offending formulas (or all the cells on the sheet) Ctrl-h (shortcut for edit|replace) what: = (an equal sign) with: = replace all Just to see if those formulas recalculate ok. === I didn't notice this before, but that f.xla in the formula looks very strange. If the addin is open, then the workbook name shouldn't be part of the formula--and if the addin is closed, then the formula should contain the drive/path/filename. If the first edit|replace doesn't work, I'd try replacing what: f.xls! with: (leave blank) replace all (It can't hurt much to try!) bh1 wrote: 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. -- Dave Peterson |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
custom addin gives #name? errors
I tried both thank you very much.
But when looking at the formula calculation steps it still says that the xHXCross results in #name? when you evaluate the formula. The f.xla shows up in both the links list and the addin list. Should it? In the links list it says "source is open" if I select update nothing happens. Is there a way to open the .xla file to check that the xHXCross function is in fact in that file and how does it know to look in that addin for that function? This may be a bit much for this forum, if so how do I locate someone in my area who is good with addins that maybe could look at the program for me. again thanks for the help "Dave Peterson" wrote: Just a complete guess... Select the range that has the offending formulas (or all the cells on the sheet) Ctrl-h (shortcut for edit|replace) what: = (an equal sign) with: = replace all Just to see if those formulas recalculate ok. === I didn't notice this before, but that f.xla in the formula looks very strange. If the addin is open, then the workbook name shouldn't be part of the formula--and if the addin is closed, then the formula should contain the drive/path/filename. If the first edit|replace doesn't work, I'd try replacing what: f.xls! with: (leave blank) replace all (It can't hurt much to try!) bh1 wrote: 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. -- Dave Peterson |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
custom addin gives #name? errors
And they both failed I presume???
Yes. f.xla should appear in both the links and addin list. Maybe...It depends on if the developer locked the workbook's project. There may be ways to check to see if there is a UDF with that name, but I think I'd go back to the developer and ask for help. And maybe you could put an advertisement in craigslist.com--or maybe your local college/university's newspaper??? bh1 wrote: I tried both thank you very much. But when looking at the formula calculation steps it still says that the xHXCross results in #name? when you evaluate the formula. The f.xla shows up in both the links list and the addin list. Should it? In the links list it says "source is open" if I select update nothing happens. Is there a way to open the .xla file to check that the xHXCross function is in fact in that file and how does it know to look in that addin for that function? This may be a bit much for this forum, if so how do I locate someone in my area who is good with addins that maybe could look at the program for me. again thanks for the help "Dave Peterson" wrote: Just a complete guess... Select the range that has the offending formulas (or all the cells on the sheet) Ctrl-h (shortcut for edit|replace) what: = (an equal sign) with: = replace all Just to see if those formulas recalculate ok. === I didn't notice this before, but that f.xla in the formula looks very strange. If the addin is open, then the workbook name shouldn't be part of the formula--and if the addin is closed, then the formula should contain the drive/path/filename. If the first edit|replace doesn't work, I'd try replacing what: f.xls! with: (leave blank) replace all (It can't hurt much to try!) bh1 wrote: 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. -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Collection custom functions as asn addin | Excel Discussion (Misc queries) | |||
An AddIn for a custom function | Excel Discussion (Misc queries) | |||
How I know if a file is using a custom addin | Excel Discussion (Misc queries) | |||
How I know if a file is using a custom addin | Excel Worksheet Functions | |||
Custom Functions saved as addin | Excel Worksheet Functions |