Spreadsheet that clears data upon opening
I work for an organization that has a Employee Reimbursement Form that people access on our intranet. We've been using this spreadsheet for years now but we've hit a snag. We recently removed all old versions of Office (specifically Office 2019). The majority of our users have an E1 license, which means they do not get desktop applications, just web versions. So now, when our users want to fill out the form, they need to download it, save it to their OneDrive, open it in the web version and fill it out. Admin finds this very inconvenient and time consuming. I can take the spreadsheet and share it from a sharepoint site, so that it opens automatically in the web version, but we are running into problems because when we share it from a link, it retains all the data. So user A clicks on the link, opens the form and enters their data and closes it. It autosaves the spreadsheet with user A's data. Then user B opens it and sees the previous data still there.
I did figure out a VB that makes it clear itself but that only works/runs on a desktop application version of Excel, not the online one. How can I post this spreadsheet on our intranet, either from OneDrive or SharePoint, and have the users be able to edit it but not save the data?
[link] [comments]
Want to read more?
Check out the full article on the original site