You can update saved reports while working in Excel.
To do this task
Click the QuickBooks tab.
Select Update Report.
Note: The first time you update a report from Excel, QuickBooks must be open. This is important because QuickBooks automatically updates your integrated applications preference. Basically, it tells QuickBooks that Excel has permission to access your data. After that, you can update reports from Excel even if QuickBooks is closed.