Start a conversation Sign in
Start a conversation
  1. Concentric Solutions Ltd
  2. Source Default Category
  3. Source Default Folder

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


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.
Choose files or drag and drop files
Was this article helpful?
Yes
No

  1. GKontos

  2. Posted

Comments