Why is the Directory Path displayed in the cell containing the function?

Homepage (2016) v2 XL-Viking Support Forums XL-Viking General Discussion & Support Questions Why is the Directory Path displayed in the cell containing the function?

This topic contains 0 replies, has 1 voice, and was last updated by  Helga 2 years, 4 months ago.

Viewing 1 post (of 1 total)
  • Author
    Posts
  • #1663 Reply

    Helga
    Moderator

    The Microsoft environment works such that porting of add-ins between different versions of Excel (or different users) may sometimes cause the entire directory Path of the location of the add-in in to be left in the cell that contains the add-in function. This is not a big issue and can easily be fixed.

    For Example:
    In a cell that had “=xln(A1)” might display “’=C:\Path To Add-in File\Excel Equation Display\1.1 (With Beam, graph and sheet adaptive number format)\XL_Viking_Display.xlam’!xln(A1)” when the spreadsheet is ported to a different computer or version of Excel.

    If this is the case all that needs to be done is to perform a global FIND/REPLACE (Located on the Home Tab and Find & Select Button (for Excel 2013))
    In the Example above perform a FIND on “‘C:\Path To Add-in File\Excel Equation Display\1.1 (With Beam, graph and sheet adaptive number format)\ XL_Viking_Display.xlam’!” and REPLACE by nothing. I.E. leave the REPLACE option empty.

    This will leave “=xln(A1)” in the cell which will, as normal, display the values of the formula in cell A1. Assuming of course the XL-Viking add-in is installed and activated on the computer.

Viewing 1 post (of 1 total)
Reply To: Why is the Directory Path displayed in the cell containing the function?
Your information:





<a href="" title="" rel="" target=""> <blockquote cite=""> <code> <pre> <em> <strong> <del datetime=""> <ul> <ol start=""> <li> <img src="" border="" alt="" height="" width="">