Autorecover Location

  • A few years ago I set a custom location for AutoRecover files in excel. Now, following a few role changes, the path no longer exists on the network. When I try to change the location or select an tab in 'Tools/Option' I get an error "Cannot access directory \\blah\blah\blah\Auto Recover Files"

    Is there any way around this?


  • Re: Autorecover Location

    You can normally set this in VBA.... Try something along the lines of the following, but make sure it's a valid path as excel will test the path.



Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!