My organization newly implemented sharpoint in our workflow. My problem is excel in sharepoint.
We use a premade excel spreadsheet for calculations for material costs. There is a set of formulas that are premade. We need our coworkers to be able to open the spreadsheet, plot in their data, but not save any changes made to the spreadsheet. I need the spreadsheet not to save any changes made by another person. Normally I would just have used an macro, but this is not possible in sharepoint as online excel is not macro-compatible.
Limmit to only read is not going to work, as we need them to be able to plot in data in the sheet. We just don’t want them to be able to save any changes made.