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

  • Thread starter Thread starter Billy B
  • Start date Start date
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.
 
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 :-)
 
Back
Top