In my office we have three spreadsheets used by three different people that need to agree to each other so I have put checks in (+cell x at spreadsheet 1/2/3 etc). The problem is, we all update all three spreadsheets every day so the check links gets broken (or we have to manually update the link e.g. + cell x at spreadsheet 1 vs 2)
Is there way of getting the checks to stay even though the versions are updated?
Hope that is clear
I have looked through Google etc but I cannot find an answer
Can't RW employ a few volunteers with admin rights to sort this out over the weekend? When I was jobless a couple of months ago, I offered to help out but no-one was interested and since then it's detoriated even further.