Until now, XLReport offered two “Refresh” data functionalities.

1.) “Refresh” the current Excel sheet.

2.) “Refresh All” Excel sheets in the current workbook.

When you inserted a real-time data XLReport object into Excel, then the whole XLReport query structure was inherited and, if you edited the underlying query (e.g. adding some new fields), XLReport would not refresh the field list. This sometimes was cumbersome, especially when working with pivot tables where you might use a huge list of fields.

Also, when you inserted a real-time XLReport object with a parameter, it would only ask you to enter the input parameter only once; at the moment when you initially inserted it.

If you clicked the Refresh button, it would still maintain the original parameter.

Now, XLReport version 7.1.0, offers you four Refresh buttons.

image

1.)  “Refresh” the current Excel sheet.
This will refresh all real-time data of the current Excel sheet.
It will not ask you for a new parameter, if one was assigned in the query. And it will not refresh the field list in the Excel sheet or pivot table.

2.)  “Refresh All” Excel sheets in the current workbook.
This will refresh all real-time data of all Excel sheets in the current Excel workbook.
It will not ask you for a new parameter, if one was assigned in the query. And it will not refresh the field list in the Excel sheet or pivot table.

3.)  “Refresh Parameter”
This will refresh the real-time data of the selected XLReport object in Excel asking you for a new parameter, if one is defined in the query.
It will not refresh with the most recent field definition of the underlying query.

4.)  “Refresh Fields”.
This will refresh the real-time data of the selected XLReport object in Excel asking you for a new parameter, if one is defined in the query. And it will refresh with the most recent field definition of the underlying query.

Diagram

image
 
Video: Refresh Parameters

Video: Refresh Fields