Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I am using Microsoft Office 2010 and Windows 7 on a Dell PC. I am opening a bunch of MSWord files one at a time, copying data tables therein, pasting the data into Excel and saving the Excel files as comma delimited text files. I am creating a separate Excel file for each MSWord file.

The path to the folder containing the saved comma-delimited files is quite long, something like this:

c:\users\me\aa\bb\cc\dd\ee\

Every time I open Excel and save a new comma-delimited file I have to re-navigate the entire path (c:\users\me\aa\bb\cc\dd\ee).

In the past Windows seemed to remember the last used path, saving a lot of tedious key-strokes. In fact, I think Windows did this for me as recently as last week, albeit on a different computer.

Can I apply a setting in Windows somewhere asking it to offer the last used path as a default when saving files so I do not have to re-navigate the entire directory structure to save each new comma-delimited file? If I can, how so? Where is the option for specifying that setting?

Thank you for any help.

share|improve this question

7 Answers 7

Every time I open Excel

That implies you quit Excel after each save. In that case Excel will revert to the default file location. To keep the current location, do not quit. Instead, close the spreadsheet only and Excel will remember the location from the last save.

Alternatively, in Excel go to Tools > Options and click the General tab (I'm using Office 2003 - 2007 and later may be slightly different). You can specify the default file location there.

share|improve this answer

My computer behaves the same way, and I agree that it is annoying. I don't know an exact solution, but what I usually do is copy the path (c:\users\me\aa\bb\cc\dd\ee) to the clipboard, and paste it into the "File name" box and hit enter. This immediately navigates to that folder in the browse window. While it's not a perfect solution, it saves a lot of time as long as you don't need to copy and paste other things.

share|improve this answer

Thanks for the suggestion. That probably would save quite a bit of time.

It occurred to me that if there is no way to ask Windows to re-use the last path, perhaps the most efficient thing to do is simply save the comma-delimited files in the default location that Windows does offer, then copy and paste all files at once from there to the desired location after finishing the file creation process. That assumes you can write to the default location, which I believe I can.

share|improve this answer

During save of first file, right click in explorer browser and select "copy address". It will save back to that folder the following times.

share|improve this answer

John's answer didn't do anything but was partly correct. You can copy the address but it doesn't save the location. The trick is after you have copied the address, click on any other folder - at which point you will see the path change. Then manually click on the path, where it should now become editable. Simply paste the path you just copied and press enter. It doesn't retain the path next time you save, but when you go to save, the path you entered before is now available in the path dropdown list. I do literally do hundreds of excel files a month so I was pulling my hair out on this one.

Have fun! :)

share|improve this answer

To go to the desired path whenever you click on "browse button" while working with Microsoft Excel or Word docs, follow the steps below:

  • Click on File (Keyboard Shortcut Alt+F)
  • Click on Option
  • Then click on Save
  • Change the path in "Default file location" field where you want to redirect when you click on the "browse" button
  • Finally click on "OK"

The next time you click on browse button working with Excel or word it will re-direct the user to the path saved.

share|improve this answer

For now, I am using "Recent Places", and I sort the folder on the Modified Date, Descending order. I always get the last folder I used this way.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.