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
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