Broken Link to User Defined Formula In Add-In

ekenigs

New Member
Joined
Jul 15, 2007
Messages
9
Hi,
I have a problem that I cannot find a way to get around as follows:

I am using a link to a user defined formula from a 3rd pary add-in.

I am using the file on two computers (home and office), one running on windows 7 and the other is XP.

The file uses a full path formula, i.e. C:/Program Files....FormulaName... (although the add-in is installed and ribbon is active)

The problem is that on the XP computer the ribbon is installed on C:/Program files.... and on the windows 7 it's C:/Program files (x86)... and so I get broken links (#NAME error)when switching back and forth between the computers.

I cannot understand why the formula keeps switching to full path even though the Add-In is installed (From what I understand when source file/add-in are open the path should be dropped by excel and only the user defined formula shown).

I cannot figure out a way around this.

I hope this message is not too confusing or long.

Appreciate any assistance.

Available to give more details s.a. full formulas & paths etc..

Thank You!!
 

Some videos you may like

Excel Facts

Create a chart in one keystroke
Select the data and press Alt+F1 to insert a default chart. You can change the default chart to any chart type

Weaver

Well-known Member
Joined
Sep 10, 2008
Messages
5,196
I've had this problem too and been unable to find a solution. I'm just making this comment so I can track the thread! Sorry for getting your hopes up.
 

Watch MrExcel Video

Forum statistics

Threads
1,118,168
Messages
5,570,604
Members
412,330
Latest member
carlosjw
Top