does anyone know a way to get excel to save every time a cell in column C is edited, I have a spreadsheet where multiple users can be working on at the same time and want to ensure they don't use the same reference number, already have it so it updates every ten minutes in the advance options under share workbook but looking for a more robust method