Add in functions and links breaking

BobBridges · #1 01-07-2020, 08:07 PM

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?

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