Skip to main content
Oct 13, 2023 12:46 PM UTC
Question

Error124720_02.xml Errors were detected in file Can anyone direct me to a solution?

Excel completed file level validation and repair. Some parts of this workbook may have been repaired or discarded. Removed Records: Formula from /xl/worksheets/sheet1.xml part

5 replies

Oct 13, 2023 1:59 PM UTC

Hello stuart-alford-tw, thanks for posting on the Community

 

Are you receiving this error response when importing or exporting a specific report or file to/from QuickBooks? 

Oct 13, 2023 2:21 PM UTC

Hi Georgia, it is only the Trial Balance report exported to Excel which generates this error message

 

Oct 13, 2023 2:49 PM UTC

Thanks for clarifying, stuart-alford-tw. 

 

Are you using a Mac or a Windows device, and does the error message continue after changing the setting on the TB report before exporting to show non-zero rows only (from the Show non-zero or active only drop-down, select Non-zero under Show rows)?