Excel

%3CLINGO-SUB%20id%3D%22lingo-sub-1918435%22%20slang%3D%22en-US%22%3EExcel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1918435%22%20slang%3D%22en-US%22%3E%3CP%3EHow%20do%20I%20assign%20the%20default%20file%20location%3F%26nbsp%3B%20That%20is%2C%20when%20I%20open%20excel%20how%20can%20I%20then%20hit%20'open%20file'%20and%20have%20it%20go%20directly%20to%20the%20location%20of%20my%20choice%3F%26nbsp%3B%20Also%20how%20do%20you%20set%20the%20'save'%20function%20so%20it%20will%20go%20to%20the%20same%20desired%20file%20location%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1918435%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EActivity%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1920346%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1920346%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F876370%22%20target%3D%22_blank%22%3E%40Muleteam0491%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYou%20may%20pin%20file(s)%20and%20folder(s)%20which%20always%20will%20be%20on%20the%20top%20on%20open%2Fsave.%20Default%20local%20save%20location%20could%20be%20set%20in%20File-%26gt%3BOptions-%26gt%3BSave%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

How do I assign the default file location?  That is, when I open excel how can I then hit 'open file' and have it go directly to the location of my choice?  Also how do you set the 'save' function so it will go to the same desired file location

3 Replies
Highlighted

@Muleteam0491 

You may pin file(s) and folder(s) which always will be on the top on open/save. Default local save location could be set in File->Options->Save

Highlighted

@Sergei Baklan 

 

Thank you.  When I start excel is there a way when I go to "open file" icon that excel will automatically go to a file location which I have specifically established just for storage of excel documents? 

Highlighted

@Muleteam0491 

As variant you may set in setting default location

image.png

and check "Don't show Backstage..."

 

With that on opening file with shortcut (Ctrl+O) this default folder will be opened.

If with mouse only when use pinned folders.