formula limit of 8192 characters pops up without visible reason ??

[MTurtinen]

Hello

I have a few times got this message:
"One or more formulas in this workbook are longer than the allowed limit of 8192 characters. To avoid this limitation, save the workbook in the Binary Workbook format."

I have no long formulas in my excel. I even made a macro to check all formulas and it cannot find long formulas. Does anybody know about a bug which could be the reason. Any ideas how to find the cell from where the message originates? The workbook is quite complex and has a lot of pages and data.

My excel is v2010.

Thanks in advance :-!

Matti

 

[thuhoang]

For me after trying to delete the conditional formatting, running Macro, saving in binary and older Excel version 2003 and prior (having about 1/5 of data capacity than new Excel version 2019) did not work for me, I had to recreate the file by copying and pasting each individual tab to the new file to detect and eliminate the tab with "over 8192 characters in formula", which i believe is some kind of coding error in Excel to misread text as formula, usually due to linking to other workbooks. Hope it helps!