Refreshing the Data from the Data Warehouse¶

1. Click on the Options button above the formula bar and select enable content in the options box.

2. On the Parameters tab, enter the month and year for the Reporting month (cell B2).  Note: This is the month of the last valid data reported

3. Enter the month, day and year of the report in the third row for the Publication Date (cell B3)

4. On the data tab, place cursor anywhere in the data sheet and hold down the right mouse button to access a drop down menu

5. Select refresh on the drop down menu.

6. If formatting is lost on any of the charts on the Price Bulletin tab after refresh, use a design template or ask the Helpdesk for assistance on learning how to quickly update the chart formats if you do not have the template for this spreadsheet.