Hello there, @kfrem.
I’m glad repairing QuickBooks fixed the error message you receive. Let me provide some clarification about exporting reports and updating existing worksheets.
Yes, you can update reports in Excel with colors or borders. However, the newly exported data will replace the existing one removing the effects, fonts and colors on the spreadsheet.
Check out this article about exporting reports for reference: Export report from QuickBooks Desktop to Microsoft Excel.
That should do it. Leave a comment below if you have any other concerns, I’m always here to keep helping. Have a good one!