Excel “Trace Dependents” stops working in XLSX files generated by ChatGPT – Cause and tested solution

Problem

When opening Microsoft Excel workbooks (.xlsx) generated by ChatGPT, the Trace Dependents feature may stop working, reporting that a cell has no dependents even when other cells explicitly reference it.

The Trace Precedents feature may continue to function normally.

In our testing, the problem was particularly difficult to diagnose because:

• It occurred repeatedly with Excel workbooks generated by ChatGPT.
• Opening an affected workbook caused Trace Dependents to stop working even in other workbooks that had previously worked correctly.
• The malfunction persisted after closing the affected workbook.
• Recalculating formulas, rebuilding the calculation chain and reconstructing the workbook did not consistently resolve the issue.

Root cause identified

The affected XLSX files generated by ChatGPT contained the following setting in xl/workbook.xml:

forceFullCalc="1"

This setting enables forced full calculation, bypassing Excel's normal dependency-based calculation mechanism.

Tested solution

1. Close Excel completely, including any remaining EXCEL.EXE processes.
2. Open the affected XLSX file as a ZIP archive.
3. Locate xl/workbook.xml.
4. Find the <calcPr> element.
5. Change forceFullCalc="1" to forceFullCalc="0", or remove the attribute.
6. Save the corrected XLSX file.
7. Restart Excel in a clean session.
8. Open only the corrected workbook and test Formulas → Trace Dependents.

Experimental confirmation

We verified that:

• An original ChatGPT-generated workbook containing forceFullCalc="1" triggered the malfunction.
• The problem affected the entire Excel session and persisted after closing the original workbook.
• A corrected version containing forceFullCalc="0" worked when opened in a clean Excel session.
• The same issue was reproduced through multiple tests, including Excel Safe Mode.

Recommendation for ChatGPT and XLSX-generation developers

ChatGPT's spreadsheet-generation workflows should explicitly prevent the unnecessary activation of forceFullCalc=True.

Before delivering generated XLSX files, the system should inspect xl/workbook.xml and ensure that persistent forced full calculation is disabled unless specifically required.

This check is particularly important because the problem may affect not only the generated workbook but also other Excel workbooks opened in the same session.

Scope and limitation

This issue was repeatedly observed in workbooks generated through ChatGPT in our testing. The results do not establish that all ChatGPT-generated Excel files are affected, nor that this setting is responsible for every Trace Dependents malfunction.

Nevertheless, the relationship between forceFullCalc="1" and the observed behavior was confirmed experimentally in the tested environment.

Conclusion

A ChatGPT-generated XLSX workbook with forceFullCalc="1" can trigger a persistent malfunction of Excel's Trace Dependents feature.

Disabling this setting and restarting Excel restored the functionality in our tests.