Hello, rstran.

If you're referring to enabling Macros. Here's how: 

1. In Excel, go to the File menu.
2. Select Options.
3. Click Trust Center, then select Trust Center Settings.
4. Select Macros Settings, then select Disable all macros except digitally signed macros.
5. Select OK.
6. Re-export the report from QuickBooks Online to Excel.

If you're referring in excel settings so you'll be able to export your data to Excel successfully. Here's how:

1. Open your Microsoft Excel.
2. Go to the File menu.
3. Select Options at the left pane.
4. Click on Advanced under Excel Options.
5. Check the settings under Advanced options for working with Excel.
6. Click OK.

On the other hand, you can also get in touch with an excel Professional for further assistance with the steps. They have the tools to look up your Excel setting via a secured remote access session.

You can also visit our Reports and accounting page for QuickBooks Online (QBO) to learn some tips on how to manage your reports and accounting.

That should do it. Let me know if this works out for you. I’m ready to help if you need anything else. Have a good one!