Knowledgebase: HFM
EXCEL HFM ADD-IN GENERATE THE ERROR 'FORMULA TOO LONG' WHEN UPDATING LINKS
Posted by Priya Doyle on 08 December 2010 05:12 PM

EXCEL HFM ADD-IN GENERATE THE ERROR 'FORMULA TOO LONG' WHEN UPDATING LINKS

 Modified 18-DEC-2009 

Applies to:

Hyperion Financial Management - Version: 3.5.1.0.00 to 3.5.1.0.16 - Release: 3.5 to 3.5
Information in this document applies to any platform.

Symptoms

Error: "Formula Too Long" when trying to update links.

Office 2000

Cause

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.

Solution

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.

(0 vote(s))
Helpful
Not helpful

Comments (0)
Post a new comment
 
 
Full Name:
Email:
Comments: