If the formula is returning an error, it is normally because the XLL addin has not been correctly installed. These formulas are contained in an XLL Add-in called HowNow Smart Workpaper Formulas. The hyperlink is trying to find a cell reference which is calculated by one of our formulas called =CurrentCell(). In addition, inside of Excel worksheets, you will see values like #NULL! or #VALUE! or #NAME! in cells that normally work correctly. When you press a hyperlink in a smart workpapers Excel starter file, you receive an error message 'Reference isn't valid', however the function will still otherwise work as expected.
