Menu
in Excel 2010, under Data-Connections where there is a list of all connections in the workbook, there is a field "Last Refreshed". This field is always empty for me. Microsoft says (http://office.microsoft.com/en-001/excel-help/create-edit-and-manage-connections-to-external-data-HA010342379.aspx) "If blank, then the connection has never been refreshed", but this is obviously not the case here, because we refresh the date quite often.
Any ideas please ? Thanks Petr
456
Update only the selected data Press ALT+F5, or on the Data tab, in the Connections group, click the arrow under Refresh All, and then click Refresh. Update all data in the workbook Press CTRL+ALT+F5, or on the Data tab, in the Connections group, click Refresh All.
Excel Services Click the Authentication Settings button to display the Excel Services Authentication Settings dialog box and to choose a method of authentication when you access the data source that is connected to a workbook and that is displayed in Excel Services.
Getting last refresh time Getting the last refresh time is pretty simple. In Power Query, right-click on the query list pane on the left and select New Query > Other Sources > Blank Query. We can now Close and Load this into Excel. By default, Excel won't show the seconds.
This page http://www.thecodecage.com/forumz/showthread.php?t=208462 claims
... the "Last Refreshed" field is populated in the dialog box for the connections that are used as data sources for pivot tables, BUT not for connections that are used as the source for Tables. If the connection is used as a source for a Table the "last refreshed" section is empty
Sounds a bit like a missing feature to me...
128
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
