Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

i have to save about 1000 different csv files and every time i click file save as, it goes to some default directory.

is there anyway it can default to remember the directory that i saved the last file into?

share|improve this question
up vote 7 down vote accepted

You can try adding registry setting for Excel.

  • start regedit
  • go to HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Excel\Options (12.0 for Excel 2007, if you have older version of Excel it will be different, 11.0 for 2003, 10.0 for 2002...)
  • add a dword value named AlwaysSaveToCurrentPath and set it to 0

This should make "Save As" use the same folder where the file was opened in. If you set the value to 1, it will use Default folder when using "Save As"

share|improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .