...
Import your data directly into Microsoft Excel. By binding your Excel report to a report web url, you can rerun the report, updating all your numbers, but not lose all the custom formatting that you may have applied in Excel. This is a great alternative to Excel and Access DatabasesRefresh Files because it removes the overhead of saving out of Projector and having access to a network drive. The following instructions are for Excel 2010.
...
2. In the dialog that appears enter your report url. Remember to set the format to XML. If you don't provide authentication information in the URL, either via user password, auth token, or session ticket - then you'll be prompted to enter your username/password. Be sure to select the table by clicking on the yellow right arrow before clicking Import.
3. Click Import
4. If you receive the following error dialog it can be safely ignored
...
If you choose not to provide auth information, you'll need to enter it again at some point in the future. You can do that from the Connection | Properties | Definition | Edit Query section of Excel.
