Error message when saving an Excel workbook: "formula too long"
Helios
-
Raymond PENTIER Posted messages 58207 Registration date Status Contributor Last intervention -
Raymond PENTIER Posted messages 58207 Registration date Status Contributor Last intervention -
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 :
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
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
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
https://forum.excel-pratique.com/viewtopic.php?t=58782
--
Retirement is great! Especially in the Caribbean...
Raymond (INSA, AFPA)
--
Retirement is great! Especially in the Caribbean...
Raymond (INSA, AFPA)