Creating a new spreadsheet¶

1. Use Microsoft Internet Explorer to open the Data Warehouse and add or edit the Data Set you want to use. It is important that you use Internet Explorer because Microsoft Excel will use the session cookie that is created when you log in to the application using Internet Explorer to authenticate you when it refreshes the data.

2. Copy the URL for the web query for the Data Set that you want to use to your clipboard.

3. Open a new Excel 2007 Worksheet

4. Select the Data menu and then the From Web ribbon button

5. Paste the URL into the Address input box and press Go

6. Wait for the Import button to become enabled (which will take up to 15 minutes depending on the size of the dataset) and then press it

7. If you get an error saying, “Microsoft Office Excel cannot access the file” make sure that you can access the Data Warehouse using Internet Explorer.

8. If you get a dialog box asking to create an XML Schema press Accept

9. At the dialog box asking where you want to insert the data place the data at \(A\)1 on a blank sheet (this will be the default if you are creating a new spreadsheet)