Recently I was having issues with an excel file that was owned and controlled by my department but external departments would often need to see the data to help inform them in decision making. Consequently we would often find the file locked by anther used and we were unable to up-date until they closed the file. To combat this I up-loaded the file to share point and gave people access control or view. It worked really well.
However my manager didn’t like me using the cloud and wanted a file physically on our network drive.
I have read that in excel you can get excel to create a backup to a second location which would be great. I could keep my file on the cloud but have it routinely backed up onto the network drive so that I have two copied stored in different places. I have done some reading on the matter but at this point I cannot get my file to do it.
