Error message when saving an Excel workbook: "formula too long"

Hello,

I suddenly have an error message when saving an Excel workbook: "one or more formulas in this workbook exceed the upper limit of 8192 characters. Please save it in binary format...."

Having used the same template for 3 years, I am sure that the formulas I employed should not exceed 8192 characters... but a user error is always possible!

Not having any idea where the "too long" formulas are (20 worksheets), how can I search for the cells whose formulas are in question?

Thank you for your responses; I found nothing on the subject during my internet searches!

Configuration: Windows / Firefox 69.0 :

2 answers

  • Votes
  • Date
  • Descending date
  1. Hello everyone,

    I would start by recording the sheet/sheet to identify the faulty sheet, then do a copy/paste of the "useful range" onto a blank sheet and see when saving it

    Best regards