In the past I managed to solve this issue with the Quickbooks Tool Hub. I just followed the instructions there for my specific problem.
Recently however, I've started experiencing this issue again and the only thing that works is to close all open Excel sheets before clicking on 'Export'. Only then does the QB report export to Excel.
