Excel in OneDrive does not update real time the linked numbers refreshed in the Excel application

Our team created this Excel file that we used to update every month and I used my OneDrive to share it to about 50+ people in our department. This file has linkages to an offline database which gets updated daily. I am the file owner and the one responsible to refresh the Excel file daily with the new data from the database. However, every time I refreshed the file in the Excel application and simultaneously view it online in my browser, the updated numbers does not reflect 99% of the time especially if there are several people using the file. So the file in my machine shows the updated numbers but the online version the numbers have not changed so those other people using the file are still viewing the old numbers. But when I paste the updated numbers as values, it gets reflected immediately in the online version. Any help from anyone here who knows how to resolve this moving forward so we won't spend so much time pasting values or telling people to exit the file every time because I need to refresh it with updated numbers? Thanks a lot for any help