When sending a report to Excel from QuickBooks, the worksheet opens in Restricted View preventing the cells from updating properly. To show the amounts from the report, you can click the Enable Editing button on the Message Bar.
If you close it accidentally, you can follow the steps below to turn on the Enable Editing option.
- Click File on the top menu.
- Select Info.
- Click Enable Editing.