Forum Discussion
Need unattended "Workbook Links" refresh all
I am League Secretary for 110 teams spread across 24 communities nationwide, and have a master spreadsheet with external links to 50 distributed spreadsheets, with many non-technical users of the distributed files also being able to view the merged results at the following link.
Those users barely know how to do simple data entry of bowling scores into their distributed file, and otherwsie see how well they are doing in competition with other teams by clicking on the shared link for the master spreadsheet to choose their community (c00 through c49).
When changes are made to any distributed file I need the master file updated. It works when I open the master spreadsheet, and works when I manually select "Data" / "Workbook Links" and select "Refresh All" in the pop up "Workbook Links" window.
However, I cannot sit in front of my computer all day manually refreshing. I have a life and am doing other activities while the master spreadsheet is open in the background, and I need Ecxel to automagically do a "Workbook Links" "Refresh All" at some unattended intervals.
I keep seeing answers like, "you can schedule automatic data refreshes by setting up a refresh interval in the "Connections" section under the Data tab." Clicking on "Queries and Connections" above "Workbook Links" opens a window offering two tabs, but the Queries" tab shows 0 Queriees, and the "Connections" tab shows 0 Connections. Perhaps the answer is for someone to teach me how to add something under either tab.
Otherwise, clicking on "Workbok Links" opens the "Workbook Links" window for the manual Refresh All, but I am stuck finding anything to chose to set up some kind of automatic Refresh All.
I see possibilities using VBA, (e.g., https://www.exceldemy.com/auto-refresh-excel-file-without-opening/)
But I am afraid that requires activating Macros for non-technical users with the shared link to the master spreadsheet., so am ignoring any VBA suggestions.
Does anybody have a non-VBA solution?
click on the workbook settings always trust the workbook link that will always refresh you workbook links
If this resolves your query don't forget Mark as Solution.
