I am working with a fairly complicated directory/folder structure which has many levels, and need to change the default folder frequently in both Word and Excel.
Changing the default file location in Word is easy and fast: all I have to do is call up Tools | Options and modify the path, which I can do with the mouse by simply selecting each stage in the path until I've got the one I want.
Doing the same thing in Excel is infuriatingly cumbersome, as I apparently have to physically type in the name of the whole path into a box. Since there are sometimes up to half a dozen levels in my default file location, I frequently get it wrong, and often have to retype it several times.
I want to be able to carry out this procedure as I do in Word. Is there any way to do that? (Modifying the file structure to make it easier to navigate isn't an option, as the network is used by the whole company.)
Many thanks for any help received.
Changing the default file location in Word is easy and fast: all I have to do is call up Tools | Options and modify the path, which I can do with the mouse by simply selecting each stage in the path until I've got the one I want.
Doing the same thing in Excel is infuriatingly cumbersome, as I apparently have to physically type in the name of the whole path into a box. Since there are sometimes up to half a dozen levels in my default file location, I frequently get it wrong, and often have to retype it several times.
I want to be able to carry out this procedure as I do in Word. Is there any way to do that? (Modifying the file structure to make it easier to navigate isn't an option, as the network is used by the whole company.)
Many thanks for any help received.