Skip to main content

Get 50% OFF QuickBooks for 3 months*

Buy now
Switch to QuickBooks and 70% off for 3 Months
October 13, 2023
Question

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

  • October 13, 2023
  • 1 reply
  • 0 views
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

1 reply

Level 13
October 13, 2023

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? 

October 13, 2023

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

 

Level 13
October 13, 2023

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