<div>
That does fine for the file saving but does not affect the Open button so every time Excel is opened and they want to open a file they have to navigate to where all the files are instead of Open opening in that location by default.
</div>


That does fine for the file saving but does not affect the Open button so every time Excel is opened and they want to open a file they have to navigate to where all the files are instead of Open opening in that location by default.

<div>
<div class="content wysiwyg-content">
I was wondering if there was a way to change the default location Excel opens files like there is for changing the default location for saving files. I changed that and it saves them where I want but if I close Excel, open it back up, and click Office -&gt; Open it goes back to Documents instead of the default save location I changed. Thanks all.
</div>
</div>


I was wondering if there was a way to change the default location Excel opens files like there is for changing the default location for saving files. I changed that and it saves them where I want but if I close Excel, open it back up, and click Office -> Open it goes back to Documents instead of the default save location I changed. Thanks all.

Change Default OPEN location in Excel 2007

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.