Thank you for responding to my issue Catherine_B. With all due respect, I do not think you considered all the background I provided, in your response.
You suggest visiting this link
I received this link by email in my first call to quickbooks customer service. I ran the utility while on the phone and no problems were detected in my company file data. There is no way to manually fix errors that don't exist. It seems there may be a problem with the Quickbooks utility, the export process, or both?
You suggest getting in contact with the Customer Care Support Team, but I have already done so twice with no resolution offered to my issue aside from contacting other software companies and reinstalling the same softwares. In a screen share yesterday in my second long call with Quickbooks Customer Service my issue was observed and should be well documented with your team. One would hope you already have a "open investigation" about this issue related to reports not exporting to excel, based on my actions yesterday. I could find no such topic and no way to being a new thread in this forum, but my problem with reports is certainly related to the many complaints in this thread about excel export difficulties, including the list export issue you mention specifically below.
Per your request, here is the text from all the alerts and errors that occur when I export the P&L Detail Report from Quickbooks 2021 Desktop Mac Software:
-Excel dialogue box #1 Alert: We found a problem with some content in 'Profit and Loss Detail5.xlsx'. Do you want us to try to recover as much as we can? If you trust the source of this workbook, click Yes. [I click yes]
-Excel dialogue box #2 Excel was able to open the file by repairing or removing the unreadable content. [I click view button]
-Microsoft Word dialogue box #2 This command is not available on this platform. [I click OK which is the only button available]
-Microsoft Word dialogue box #3 This file has custom XML elements that are no longer supported in Word. Saving the file will remove these elements permanently. [I click OK which is the only button available]
-Microsoft Word doc opens in compatibility mode with the following text:
Repair Result to Profit and Loss Detail70.xml
Errors were detected in file'/var/folders/bq/7qwq2nr13_1dkscw011glsnc0000gn/T/Profit and Loss Detail7.xlsx'
Excel completed file level validation and repair. Some parts of this workbook may have been repaired or discarded.
Removed Part: /xl/sharedStrings.xml part with XML error. (Strings) Xml parsing error Line 1, column 97146.
Removed Records: Cell information from /xl/worksheets/sheet1.xml part
I think your programmers need to resolve this issue with the Quickbooks software. It would be great if there was an option to export these reports as a CSV in the Mac 2021 desktop version. I do not see that option but the errors suggest there is some formatting in the outgoing text data from quickbooks that is not readable in excel. The numbers show up on the spreadsheet but the text does not. I'd like some assurance that Quickbooks will address this issue and correct it in upcoming updates/patches to their software? I still consider this issue unresolved, and I still look forward to exporting to excel using this new Quickbooks software. Thanks again for looking into my issue, and please take care.
