I have a workbook that I did a long time ago in Excel 2000. Now I want to convert it to Excel 2016. So this is what I did. I clicked on File then on Export and change file type to macro enabled. But when I clicked OK, I got this pop up that said the following:
"One or more formulas in this workbook are longer than the allowed limit of 8,192 characters. To avoid this limitation, save the workbook in the Excel Binary workbook format"
I checked all of the formulas and none of them are 8,192 characters long. All of my formulas are all short. I'm not even capable of doing formulas that long. My formulas are all very basic addition and multiplication ones. How come this is happening?? Any advice on how I can solve this problem?
"One or more formulas in this workbook are longer than the allowed limit of 8,192 characters. To avoid this limitation, save the workbook in the Excel Binary workbook format"
I checked all of the formulas and none of them are 8,192 characters long. All of my formulas are all short. I'm not even capable of doing formulas that long. My formulas are all very basic addition and multiplication ones. How come this is happening?? Any advice on how I can solve this problem?