I have been experiencing the same issue on my PC, and found that the functionality returned after "repairing" my MS Office 365 installation.  So relieved that this worked as I'm heavily dependent on the export to Excel function.