ULFireTester
New Member
- Joined
- Oct 22, 2020
- Messages
- 3
- Office Version
- 365
- Platform
- Windows
I have a question about automatic reverting an Excel spreadsheet.
I have created several spreadsheets in Excel that have both locked and unlocked cells in them. Staff members use these forms as needed to send equipment in for repair and/or calibration.
The majority of the form is pre-filled in and locked so it can't messed up. The parts that are unlocked are so staff members can enter information about the equipment (such as ID#s, quantity, location, etc.) and where to ship the equipment back to once it has been repaired/calibrated.
My question is: Is there a way to make the spreadsheet automatically revert back to a version I choose at a pre-determined time or interval?
Basically, no matter what anybody does to the spreadsheet, I want it to revert back at say midnight every single day. That way, when the next staff member opens the spreadsheet, they don't see all the information from the previous staff member.
Right now, we have these spreadsheets stored in MS Teams, which is where everyone can gain access to them. If what I'm wanting can't be done in Excel, I'll see if something in MS Teams can do it.
Thank you in advance.
Chris
I have created several spreadsheets in Excel that have both locked and unlocked cells in them. Staff members use these forms as needed to send equipment in for repair and/or calibration.
The majority of the form is pre-filled in and locked so it can't messed up. The parts that are unlocked are so staff members can enter information about the equipment (such as ID#s, quantity, location, etc.) and where to ship the equipment back to once it has been repaired/calibrated.
My question is: Is there a way to make the spreadsheet automatically revert back to a version I choose at a pre-determined time or interval?
Basically, no matter what anybody does to the spreadsheet, I want it to revert back at say midnight every single day. That way, when the next staff member opens the spreadsheet, they don't see all the information from the previous staff member.
Right now, we have these spreadsheets stored in MS Teams, which is where everyone can gain access to them. If what I'm wanting can't be done in Excel, I'll see if something in MS Teams can do it.
Thank you in advance.
Chris