I am on chat with Microsoft. They are less than helpful. as long as Excel opens and works then there is nothing wrong with Office and it must be an Intuit issue. They also tell me that Quickbooks will ALWAYS default to a .csv file and i would have to save it as an actual .xlsx file after exporting it. I can export a Payroll Summary report from Payroll, that goes right into an Excel file, however when I click Update Report, i get an error msg that 'It is not a valid QB Report Excel Sheet' so why doesn't Excel recognize the QB report that it just created? Here is a screen shot of the QB report and the error i get when i try to update the report
