{"id":275,"date":"2022-06-09T20:47:23","date_gmt":"2022-06-09T20:47:23","guid":{"rendered":"https:\/\/docs.xlreport.com\/docs\/admin-user\/refresh-your-data\/"},"modified":"2022-06-12T16:32:09","modified_gmt":"2022-06-12T16:32:09","slug":"refresh-your-data","status":"publish","type":"docs","link":"https:\/\/docs.xlreport.com\/docs\/admin-user\/insert-query-data-into-excel\/refresh-your-data\/","title":{"rendered":"Refresh Your Data"},"content":{"rendered":"<p>When you inserted a XLReport Query Object into an Excel sheet as Live Data or Live Pivot Table then the Excel sheet is &#8220;live \u2013 real time&#8221; connected to your data source.<\/p>\n<p>In order to retrieve the most current data set you need to click the \u201cRefresh\u201d button.<\/p>\n<p>If your Excel workbook includes more than one XLReport Query data set then you can click the \u201cRefresh All\u201d button in order to retrieve the most recent data for all your sheets of your current Excel workbook.<\/p>\n<p>You have four options to refresh your real-time data:<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/docs.xlreport.com\/wp-content\/uploads\/docs-images\/69.png\" \/><\/p>\n<ul>\n<li value=\"1\">\n<h3><span class=\"DoIt\">Refresh<\/span> the current Excel sheet.<\/h3>\n<p>This will refresh all real-time data of the current Excel sheet.<br \/>\nIt 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.<\/li>\n<li value=\"2\">\n<h3><span class=\"DoIt\">Refresh All<\/span> Excel sheets in the current workbook.<\/h3>\n<p>This will refresh all real-time data of all Excel sheets in the current Excel workbook.<br \/>\nIt 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.<\/li>\n<li value=\"3\">\n<h3><span class=\"DoIt\">Refresh Parameter<\/span><\/h3>\n<p>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.<br \/>\nIt will not refresh with the most recent field definition of the underlying query.<\/li>\n<li value=\"4\">\n<h3><span class=\"DoIt\">Refresh Fields<\/span><\/h3>\n<p>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.<br \/>\nAnd it will refresh with the most recent field definition of the underlying query.<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n","protected":false},"featured_media":0,"parent":224,"menu_order":9,"comment_status":"open","ping_status":"closed","template":"","doc_tag":[],"_links":{"self":[{"href":"https:\/\/docs.xlreport.com\/wp-json\/wp\/v2\/docs\/275"}],"collection":[{"href":"https:\/\/docs.xlreport.com\/wp-json\/wp\/v2\/docs"}],"about":[{"href":"https:\/\/docs.xlreport.com\/wp-json\/wp\/v2\/types\/docs"}],"replies":[{"embeddable":true,"href":"https:\/\/docs.xlreport.com\/wp-json\/wp\/v2\/comments?post=275"}],"version-history":[{"count":3,"href":"https:\/\/docs.xlreport.com\/wp-json\/wp\/v2\/docs\/275\/revisions"}],"predecessor-version":[{"id":373,"href":"https:\/\/docs.xlreport.com\/wp-json\/wp\/v2\/docs\/275\/revisions\/373"}],"up":[{"embeddable":true,"href":"https:\/\/docs.xlreport.com\/wp-json\/wp\/v2\/docs\/224"}],"wp:attachment":[{"href":"https:\/\/docs.xlreport.com\/wp-json\/wp\/v2\/media?parent=275"}],"wp:term":[{"taxonomy":"doc_tag","embeddable":true,"href":"https:\/\/docs.xlreport.com\/wp-json\/wp\/v2\/doc_tag?post=275"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}