<div>
Thanks carlosab. <br />
<br />
To help others who may have the same problem in the future please let us know what resolved things for you.<br />
<br />
Regards<br />
Brian.
</div>


Thanks carlosab.

To help others who may have the same problem in the future please let us know what resolved things for you.

Regards
Brian.

<div>
Good point. Sorry. I saved as a binary, then closed, reopened, and saved as *.xlsm.
</div>


Good point. Sorry. I saved as a binary, then closed, reopened, and saved as *.xlsm.

<div>
Thanks, carlosab.<br />
<br />
xlsb and xls file formats are completely different to the xlsx/xlsm format, so it's possible that the two complete rebuilds have permanently removed the problem. However I'd be suspicious and make sure that my backups were good!<br />
<br />
Regards,<br />
Brian.
</div>


Thanks, carlosab.

xlsb and xls file formats are completely different to the xlsx/xlsm format, so it's possible that the two complete rebuilds have permanently removed the problem. However I'd be suspicious and make sure that my backups were good!

Regards,
Brian.

<div>
this is happening not because of any particular formula that is created, but a pivot range path that crosses this limit of 8192 characters. I have created a small script that fixes this path problem. But incidentally this does not work as a one time fix. the problem seems to occur once in a while and I have to re-run the script every time it happens.
</div>


this is happening not because of any particular formula that is created, but a pivot range path that crosses this limit of 8192 characters. I have created a small script that fixes this path problem. But incidentally this does not work as a one time fix. the problem seems to occur once in a while and I have to re-run the script every time it happens.

<div>
<div class="content wysiwyg-content">
When I try to close the file, I get this error:<br />
<br />
&quot;One or more formulas in this workbook are longer than the allowed limit of 8192 characters. To avoid this limitation, save the workbook in Excel Binary Workbook format.&quot;<br />
<br />
The workbook does not have any formula that is &gt;&nbsp;100 characters. Help. Thanks.
</div>
</div>


When I try to close the file, I get this error:

"One or more formulas in this workbook are longer than the allowed limit of 8192 characters. To avoid this limitation, save the workbook in Excel Binary Workbook format."

The workbook does not have any formula that is > 100 characters. Help. Thanks.

Weird Excel Error on Save

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.