The suggested solutions did not work, but I found a work-around.  Kind of a pain as I had 24 P&Ls to export.  Here's what worked:

Make sure Excel is closed. Create the report in QuickBooks, open Excel, then go back to the report to export.  Close Excel.  Create report, open Excel, export.  Rinse and repeat.