Windows 7 Forums
Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.

Windows 7: Changing Excel 2010 default save folder location

18 Sep 2011   #1

Changing Excel 2010 default save folder location

Hi folks, got a question re: Excel 2010, running on win7 Pro 32-bit (it's not the machine in my stats).

I looked up tutorials to change the default save folder location for MS Office, and pretty much all of them reference MS Word 2010. Like for example the one in this forum, MS Office Word : Set Default Save Location -- which works fine when I try it, no problem with Word 2010. However, Excel 2010 is being a **** and refuses to following spec.

When I click on File -> Options, then navigate to the "Save" tab, it displays a screen similar to the equivalent one in Word... except that the "Browse" button to change the folders is missing.

Changing Excel 2010 default save folder location-excel2010_save1.jpg

No big deal, plus the default file location is already pointing to my user folder: that's fine. However, when I go to save or save-as, this is what pops up:

Changing Excel 2010 default save folder location-excel2010_save2.jpg

Yea-- no. Why is Excel showing libraries? I don't want to use libraries. I don't want to see libraries. I've used the registry hack from this forum to remove libraries from showing up in the left pane of Explorer.

How do I get Excel to use my documents folder as the default?

My System SpecsSystem Spec
18 Sep 2011   #2
Darryl Licht

Windows 7 Ultimate 64 bit Steve Ballmer Signature Edition

After changing the location in the Excel Options --> Save tab... did you reboot?
My System SpecsSystem Spec
18 Sep 2011   #3


No, I didn't change the folder; it was already pointing to my documents folder. Haven't rebooted, will try that in a sec - gotta wait for a download to finish.

Nope, still opens Libraries first. Tried changing the folder to C:\; huh, that worked, didn't have to reboot. Restarted Excel, yep, save-as goes to C:\. Changed it to another folder, also worked.

Changed it to my documents folder - blam, back to the Library. Changed it to another folder, it goes to that folder. Oookay...

Well, I can accept that - I don't mind pointing Excel elsewhere (my original problem is solved). This however still leaves the fact that if you point it to your user document folder, Excel will automatically jump to the library.
My System SpecsSystem Spec

19 Sep 2011   #4

Windows 7 Home Premium 64bit

One small point - in your illustration it states "Save as" Excel 97-2003 (*.xls).

Maybe that was intentional, but Excel 2010 is usually the first in the list, Excel Workbook (*.xlsx).
My System SpecsSystem Spec
19 Sep 2011   #5


Yes, that was intentionally changed previously - many of the people I liaise with have older versions of MS Office.
My System SpecsSystem Spec
19 Sep 2011   #6

Windows 7 Ultimate SP1 64-Bit

If it is any help to you, I don't use libraries either.

I have created a data partition and sub-divided that with separate folders for personal data such as MS Office docs, digital images, music and video files.

The folders are then configured with sub-folders as shown in the screenshot below.

Changing Excel 2010 default save folder location-excel.jpg

I have a separate sub-folder for each Office application whose default Save filepath points to their respective sub-folder within H:\Personal Files Backup\Microsoft Office Files\

This way, all my personal stuff is kept well away from the Windows partition and makes backing up so much easier and quicker.

My System SpecsSystem Spec
19 Sep 2011   #7

Windows 7 x64 pro/ Windows 7 x86 Pro/ XP SP3 x86

One solution to that problem is to move the Users folder. One way to move the Users folder is

User Folders - Change Default Location

Another, slightly more involved way.

User Profile - Change Default Location
My System SpecsSystem Spec
19 Sep 2011   #8


Some random suggestions that might work:

How to Change the Default Save Location for Word 2010 - I think it may work for Excel also.

Microsoft Office Compatibility Pack for Word, Excel, and PowerPoint - Products -

If all else fails, here are a couple of Work-Arounds:

This is not exactly the same thing, because you're not saving THE file/folder to a different location, but you can use these Keyboard shortcuts in Windows Explorer to take you to your last 'saved location'

Clicking Alt + Left Arrow takes you back to your last location

Clicking Alt + Right Arrow –after you’ve gone back to your last location, it takes you back to where you originally were.
My System SpecsSystem Spec
20 Sep 2011   #9
Darryl Licht

Windows 7 Ultimate 64 bit Steve Ballmer Signature Edition

I see this thread is now marked as solved, but I do not see where the OP states it is fixed... WHY???
My System SpecsSystem Spec
20 Sep 2011   #10


Sorry for the confusion, but in my second post I mentioned that I am able to get Excel to use a different folder. That is an acceptable solution for me hence I marked my thread solved.

However it doesn't work (still goes to Libraries) if I point it at my user documents folder. As long as you point it elsewhere, Excel will obey you.
My System SpecsSystem Spec

 Changing Excel 2010 default save folder location

Thread Tools

Similar help and support threads
Thread Forum
Outlook 2010 setting default save location
Hi, If I choose to save an attachment that has been mailed to me, the default location is always: Libraries\Documents I would like to nominate a different location. I have searched the Options, but cannot find anywhere to change this location. Can anyone help with this? :huh:
Microsoft Office
Will moving Downloads folder change program default save location?
The Downloads folder by default is at C:\Users\User-Name\Downloads I have another hard disk D:\ that I use it to save data files only and I would like to move the Downloads folder to the D:\Downloads I will follow...
General Discussion
Changing the default save location of things from Documents
Hello all! I was always wondering, Is there some way that I can change the default save location of things? For instance.. Games... Virtual machines.. I want JUST documents to be in documents rather then a bunch of BS stuff. If I make a folder in documents like "BS Folder" and put everything...
Saving to a library location that is NOT the default save location
OK, I've googled and searched for this as much as I can. I'm a new Windows 7 user. I have a library (Documents) with three folders included. Call them folders A, B, and C. I understand how to set the default save location. Let's say I've set it to Folder A. Now, I want to save a file in *Folder B*...
General Discussion
Setting default save location to last save folder
Is there any way to set the default save location folder for downloads in IE8 to the last folder that the same file type was saved in? It makes no sense to default to a single folder and have to browse through to the desired folder for every single download, so I assume there has to be an option...
General Discussion

Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

Designer Media Ltd

All times are GMT -5. The time now is 08:20.
Twitter Facebook Google+ Seven Forums iOS App Seven Forums Android App