When Excel saves your spreadsheet, it always saves the location of any add-ins that have been used within the formula. This means that if you share a spreadsheet among colleagues, and you don't use the same location for the PaXcel XLA file, then you may find that a formula is prefixed with the full path to the XLA, and the formula shows the result as #NAME?
To make it easier for users to remove this static add-in location, we have added this function to the PaXcel toolbar.
The first step is to select a cell that contains a PaXcel formula with the static XLA location - as shown below - then press the icon on the PaXcel toolbar.
Static XLA location
The PaXcel function will do a find and replace, replacing the static location, so that formulas will be returned to their normal state.
