EXCEL HFM ADD-IN GENERATE THE ERROR 'FORMULA TOO LONG' WHEN UPDATING LINKS
Posted by Priya Doyle on 08 December 2010 05:12 PM
Applies to:Hyperion Financial Management - Version: 22.214.171.124.00 to 126.96.36.199.16 - Release: 3.5 to 3.5
Information in this document applies to any platform.
Error: "Formula Too Long" when trying to update links.
Length of formula and path to the HFM Add-in exceeds 256 character limit for column width in Excel 2000.
You will see how Excel adds the file path for the Add-in before each Retrieve function. If the total length of the cell so formed exceeds about 250 characters, the cell cannot be edited without losing some characters from the end.
1. Try to reduce the length of the formula.
2. When opening the Excel workbook, choose Don't Update links option if prompted, and click Continue in the next prompt.
Alternatively, save the workbook locally so that the file path length is reduced, reopen it and try again.