cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Everything you need to know about banking in QuickBooks Online - Discover more
stuart-alford-tw
Level 1

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 5
GeorgiaC
QuickBooks Team

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

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? 

stuart-alford-tw
Level 1

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

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

 

GeorgiaC
QuickBooks Team

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

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

stuart-alford-tw
Level 1

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

We are using Windows devices.

The original report was showing zero balances (set to Active rows and Active columns).

After changing setttings to show non-zero the error message did not appear.

Thank you so much for solving this puzzle!

Kurt_M
QuickBooks Team

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

Thanks for getting back here in the thread, Stuart.

 

We're happy that one of our colleagues was able to help you get through your current situation. If you ever need assistance performing specific tasks inside QuickBooks Online (QBO) or have any additional questions related to the program, please don't hesitate to comment below or visit us here in the Community space.

 

Stay safe!

Need to get in touch?

Contact us