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

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

Name:  excel2010_save2.jpg
Views: 66
Size:  56.5 KB

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

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.

Edit:
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 - Office.com

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

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
Reply

 Changing Excel 2010 default save folder location




Thread Tools




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 06:37 PM.
Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App
  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33