Excel saved locations?

Question

I am using Excel 2007. In past editions, when I went to open or save a document, the most recent location would appear. Now, I have to go through the same routine of clicking through various folders and pathways just to get where I want. This is frustrating when I am saving 10 documents to the same location but with different names. Is this an Excel setting or a network setting and can it be changed?

Answer 1

Click on the Office icon
Select "Excel Options" found at the bottom of the right panel
Go to "Advanced"
Select under "Display", the number of files you want to keep like that

Answer 2

Yeah, you can set it up so where it does that.

Go to:

Tools > Options

Then select the General tab.

Under "Default file location:" enter the full file address (starting with "C:\" for example) for the file folder that you normally save the file in. If you have trouble with entering the address, open that folder in Windows Explorer, then copy and paste the address in the address bar of Windows Explorer into the Default file location textbox in Excel.

That will take care of the problem regarding where you normally save files to.

While you are on the General tab. Go up to "Recently used file list:" under Settings. Make sure that is checked. And to the right of that change the number of entries to the number of recent entries you'd like it to list at the bottom of the File menu when you click File on the Menu Bar. The maximum number of entries is 9.

Answer 3

I believe this is an excel setting and you should be able to change it. Under Options and then under the General tab check the Recently used fiel list and be sure it is checked and set the number of files.

Hope that helps.