After defining the basic account and time data that you want to show in your report, you can pull in the connected data from Adaptive Insights and view your report.
You can refresh data for:
- A selection of rows or columns
- The current worksheet
- Selected worksheets if you have multiple ones open
- All worksheets in a workbook
To pull in the data and view the resulting report:
From the OfficeConnect tab > Design group, select Refresh.
A progress bar appears briefly while OfficeConnect retrieves data from your Adaptive Insights data source. The data appears in the cells of the worksheet according to your report design.
OfficeConnect automatically widens columns to accommodate large numbers. Click Book Properties from the OfficeConnect tab > Book group. On the Format tab under Column Display, clear the Autofit columns and refresh the data. Click OK. Columns do not narrow with shorter data, but you can do that manually if necessary.