Spreadsheet that clears data upon opening
Our take
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]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- Change contents of cells based on a drop downSo, I'm trying to generate a spreadsheet to make the forms we use in the office to issue keys. When people are given an apartment, we have a sheet with all the key numbers on it, and then they sign for it. At the moment, we've got 22 different PDFs and Word documents, and it doesn't work. So, what I want to do is this. I've built the template in Excel and created a Reference sheet which will have all the numbers in it. What I am trying to do is set it up so that when you use the Apartment number from a dropdown, it populates with all the key numbers. This sounds like it should be easy to do, but my Excel brain is broken. Advice would be much appreciated! submitted by /u/Hot_Syrup_1774 [link] [comments]
- Can I "link" different spreadsheets together and make them "communicate"?i am new to excel but hoping to get a quick answer to my question as I am having trouble finding this on the web. i have Spreadsheet A where new hires get added to a list by someone else. This include their name, division, email, etc. I manage education and compliance in Spreadsheet B which includes me having to manually go through spreadsheet A and pulling all the info over. other than this inconvenience, the trouble is the person managing spreadsheet A deletes these people from her spreadsheet after she is done with their on boarding process so if i dont catch it, its a pain in the ass for me to get that info lol. is there a way for me to have my spreadsheet get updated when she updates hers, but not have that information deleted if she were to delete something from it? submitted by /u/AbleKaleidoscope877 [link] [comments]
- Create a snapshot of a sharepoint file and unlinkHi, I have a spreadsheet on a SharePoint site that is used by my team. I have a second file on the same SharePoint that pulls some data using a FILTER command. I need to share this second file with people who do not have access to the SharePoint. I have tried 'save a copy', and save it to a network drive location, and then email the copy to all viewers, but the file still warns that it cannot update links whenever one of those users opens the file. Is there any way to create a version that does not try to update? The file I send needs to be filterable, and also has editable columns for them to send comments and feedback. Any ideas? submitted by /u/MaxDaClog [link] [comments]
- A new workbook saved to a sharepoint is excruciatingly sluggishI create a book1.xlsx and it's blank, save it to my desktop and it works as expected. Changing cells is instantaneous. Typing in a cell is instantaneous. Hitting enter to finish editing that cell is also instantaneous. Then I save it to our organizations SharePoint, which happens to be overseas. Suddenly, every action is met with nearly half second lag. I can start typing in a cell at a normal speed and it lags, characters show up in chunks as I type. Even single-clicking on different cells is met with lag. This is in the desktop excel, not web based. Why is this happening? Every online resource tells me I have too much data, too complex of a formula, but there is none of that in here. When I open an excel file from a sharepoint it's supposed to put it on my local machine, and then upload changes as I make them in the background. It's worked flawlessly for years. Now that this SharePoint is based overseas it becomes a sluggish nightmare from the get-go. Is there something I can do to stop this behavior? Turning off autosave does not work. submitted by /u/fixthe_fernback [link] [comments]