'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
Fix Excel for Mac Not Showing Last Refreshed Time in Power Query
Question details
The user needs to view the 'Last Refreshed' date and time for Power Query connections, but the information is missing from the dialog box.
- Product
- Microsoft Excel
- Device & OS
- macOS
- Scenario
- Checking the Workbook Queries and Connections dialog after refreshing Power Query data.
- Observed behavior
- The 'Last Refreshed' value remains blank or does not appear automatically after the query has finished refreshing.
Ensure your Mac has an active internet connection and verify that the Power Query has completely finished loading data before checking the connection details.
Verify Query Completion and Report the Issue
Since this is a known behavior in certain versions of Excel for Mac, verifying the query status and reporting the missing detail to Microsoft is the recommended approach.
In some versions of Excel for Mac, the UI fails to update the Last Refreshed metadata in the Workbook Queries and Connections dialog even when data is successfully retrieved. Reporting this helps prioritize a patch.
Allow the Power Query to fully finish running. Check the status bar at the bottom of the Excel window to confirm there are no background queries still executing.
Navigate to the top menu bar in Excel and click on 'Help'.
Select 'Feedback' from the dropdown menu, and then click on 'I Don't Like Something' to open the reporting pane.
Describe the missing Last Refreshed time issue. Be sure to include your exact macOS version, Excel version, the type of query you are running, and attach a screenshot of the blank dialog before clicking 'Submit'.
Try WPS Office for Seamless Spreadsheet Management on Mac
Experiencing bugs and missing features with Excel for Mac? WPS Office offers a lightweight, robust, and free alternative that is highly compatible with Microsoft Office formats. Enjoy a smooth spreadsheet experience without the heavy resource demands.
Frequently Asked Questions
Why does the Last Refreshed time stay blank in Excel for Mac?
This can happen if the query is still refreshing in the background, or due to a known display limitation in specific versions of Excel for Mac regarding Power Query dialogs.
Can I use a formula to display the last refreshed time instead?
Yes, as a workaround, you can use a custom VBA macro or create a timestamp column in your source data that updates whenever the query is refreshed.
Will updating Excel for Mac fix the missing Power Query details?
Microsoft frequently releases patches for Excel for Mac. Updating your software to the latest version via Microsoft AutoUpdate is the best way to potentially restore the missing Last Refreshed field.
