Excel 工作簿连接字段 "Last refreshed"始终为空

Question

在 Excel 2010 中，数据连接下有工作簿中所有连接的列表，有一个字段“上次刷新”。这个领域对我来说永远是空的。微软说( http://office.microsoft.com/en-001/excel-help/create-edit-and-manage-connections-to-external-data-HA010342379.aspx )“如果为空，则连接从未刷新过”，但这里显然不是这种情况，因为我们经常刷新日期。

请问有什么想法吗？谢谢彼得

Answer 1

本页http://www.thecodecage.com/forumz/showthread.php?t=208462 claim

... 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

对我来说听起来有点像缺失的功能......