exporting a report to Excel and when I export it to Excel the totals are all '0'

Hello there, AngeloBnB.

Thank you for sharing with me about your report showing up zero amounts when exporting it to Excel. The file is maybe in Protected View. 

You need to click Enable Editing to view the full report. See the attached screenshot for your visual guide.

QuickBooks Online gives you the flexibility to generate reports and get insights about your business. Check out these additional articles to help you get the data that matters to you most.

• Export Your Reports To Excel From QuickBooks Online
• Common Custom Reports In QuickBooks Online

Please don't hesitate to leave a comment below if you need more help with QuickBooks. I'm always here to help you. 

Good news first: your numbers aren't missing. QuickBooks exports report totals as Excel formulas, and when those formulas don't calculate, the cells show 0, so this is a display issue, not lost data. The usual cause is Excel's Protected View, but since you've already clicked Enable Editing and still see zeros, the next most common cause is that Excel is set to manual calculation, and there are a couple of other checks below.

1. Confirm you left Protected View

Open the file and, if you see the yellow Protected View bar, select Enable Editing. Tip: click a zero cell, if the real number appears in the formula bar, the value is there and just isn't calculating, which points to the next step.

2. Turn calculation back to Automatic (most likely fix here)

1. In Excel, go to the Formulas tab.
2. Select Calculation Options and set it to Automatic.
3. Or press Ctrl + Alt + F9 to force a full recalculation.

When calculation is set to Manual, the exported formula cells stay at 0 even after you enable editing, this matches what you're seeing.

3. A few more checks if it persists

• Open in the desktop Excel app, not the browser or a preview. Previewers and some viewers don't calculate the formulas.
• Update or repair Office (File, Account, Update Options), and if you use a non-Microsoft spreadsheet app, try opening the file in Excel itself.
• Re-export from a different browser if the downloaded file itself looks incomplete, though since you've already tried Chrome and Edge with cache cleared, the Excel-side steps above are the more likely fix.

If the totals are still 0 after enabling editing and setting calculation to Automatic in the desktop Excel app, that's worth reporting to QuickBooks Support so they can look at the export on your account. If it helps in the meantime, exporting to PDF gives you the figures directly without relying on Excel calculation.