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 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

1 Answer 1

up vote 6 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

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.