Right now, because of caching the update can take up to 12h. But you can manually update the data source to bring the latests data from the spreadsheet.
Thanks for the heads-up. That would indeed cause an interesting confusion if not known to the users. We could probably live with it for some use cases, a more direct update would be better though.