#1
|
|||
|
|||
Add in functions and links breaking
I have extensive functions in an Excel add-in. From time to time when loading spreadsheets that call functions from the add-in, Excel will get the links all messed up. I haven't work out the trigger. Example:
Assume the add-in has a valid function called func() A cell initially had "=func(a1)" and everything worked well. At some point, may be days or week later Excel will mess up the spreadsheets and substitute into the cell ='c:\path\path\addinname.xlxa'!func(a1) Even though the path is actually correct it will not work and return "#NAME?" How can I stop Excel trying to be smart and messing it up? I thought the purpose of add ins was to have a file already loaded in memory so paths to physical files was not required. I had gained some improvements by unchecking for every spreadsheet that uses the addin "Update links to other documents" and "Save external Link Values". But after opening on a new PC previously better behaved spreadsheet are now messing up. In the end I never want Excel to try to point or link to a file, just assume its loaded and ready to go. |
#2
|
||||
|
||||
It sounds like your worksheet function(s) are sometimes in the workbook and sometimes in a different one. Or to put it another way, you have a workbook (call it Here.xlsm) that has the code for func(), and sometimes you're trying to call it from Here.xlsm and sometimes from There.xlsx. I'm not saying that's what's going on, but that would at least explain why "=func()" is sometimes translated to "=drive:\\path\filename!func()".
Or wait, you say the filename has an extension of .xlxa (or did you mean .xla?). I don't use that extension much (where "not much" is pronounced "not ever, I think"), but maybe this means sometimes you have that add-on file open in Excel and sometimes you don't? |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
non-breaking ] and [ | nielsgeode | Word | 13 | 08-18-2017 11:48 PM |
Links need to be Hot links in Bibliography in Word 2010, 2013 | synses | Word | 1 | 11-23-2013 12:48 AM |
Breaking Links In A Formula And Making Them Values, Office 2003 | tcohen | Excel | 1 | 03-18-2013 07:05 AM |
Non-breaking items | judicial85 | Word | 7 | 02-23-2012 07:12 PM |
Breaking links in Office 2007 | derohanes | Word | 3 | 05-01-2011 06:15 AM |