Excel Error: "Formula is too long" when modifying formula

B

Billy B

Version: Excel, Office 2002
Error: "Formula is too long"
Details: Select cell containing formula, choose EDIT/REPLACE. Enter
characters to replace, and choose to 'replace' (not replace all)
generates above error message.

Trouble shooting: Move file to the root of C: incase the directory
path+filename was too long. This did not help. Moved the 4 linked
tabs to new sheet and get same error.
This is a workbook that contains linked sheets. Not sure if this
could be a limitation of excel or not.

PLEASE HELP!!!

Billy B.
 
F

Frank Kabel

Hi
you may post your formula. Excel limits the formula to 1024 characters.
So you may have used references to external files with a large
pathname. There are some solutions to prevent this error. e.g. Create
defined names but as said post your formula :)
 
Top