2 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

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?

submitted by /u/kcguru23
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#Excel alternatives for data analysis
#generative AI for data analysis
#real-time data collaboration
#big data management in spreadsheets
#machine learning in spreadsheet applications
#conversational data analysis
#cloud-based spreadsheet applications
#intelligent data visualization
#modern spreadsheet innovations
#enterprise-level spreadsheet solutions
#digital transformation in spreadsheet software
#collaborative spreadsheet tools
#AI-driven spreadsheet solutions
#automation in spreadsheet workflows
#no-code spreadsheet solutions
#natural language processing for spreadsheets
#Excel compatibility
#rows.com
#financial modeling with spreadsheets
#employee reimbursement form