Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #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
 



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 11:54 AM.


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