Some times show error during the export GSTR-1 there issue in the disable macro and also issue in the trust center also.

Step 1) Open a new Excel file and then go to File Option.
Step 2) After that click on the Option.
Step 3) After that Click on Trust Center option. And Click on the right side Trust Center Settings.
Step 4) Show the Macro Setting on the Left side select that and select Enable all Macros and press Ok.