You are reading a single comment by @aggi and its replies.
Click here to read the full conversation.
London Fixed Gear and Single-Speed is a community of predominantly fixed gear and single-speed cyclists in and around London, UK.
This site is supported almost exclusively by donations. Please consider donating a small amount regularly.
@aggi
I have a workbook that I want to automatically refresh itself.
I have 3 spreadsheets (say A, B and C) with A populating B and B populating C. If I don't open B to refresh it then C will have old data, therefore I want B to auto-refresh (C can't be populated from A due to access permissions for some team members).
I need B to be refreshed daily, preferably without my machine having to be on (although I do leave it on enough that this wouldn't be a deal breaker). The obvious seems to be something using Excel online (everything is on Sharepoint) but a bit of testing doesn't seem to be getting that work (full thing here https://superuser.com/questions/1672620/excel-online-automatic-refresh-issues ).
Anyone any bright ideas? Cheers