Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-06-2020, 07:15 PM
uac988 uac988 is offline Add in functions and links breaking Windows 7 64bit Add in functions and links breaking Office 2013
Novice
Add in functions and links breaking
 
Join Date: Feb 2018
Posts: 2
uac988 is on a distinguished road
Angry 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.
Reply With Quote
  #2  
Old 01-07-2020, 08:07 PM
BobBridges's Avatar
BobBridges BobBridges is offline Add in functions and links breaking Windows 7 64bit Add in functions and links breaking Office 2010 32bit
Expert
 
Join Date: May 2013
Location: USA
Posts: 700
BobBridges has a spectacular aura aboutBobBridges has a spectacular aura about
Default

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?
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Add in functions and links breaking 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
Add in functions and links breaking Breaking links in Office 2007 derohanes Word 3 05-01-2011 06:15 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:43 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft