Change the default file location of the Open dialog box : Workbook Open « Editing « Microsoft Office Excel 2007 Tutorial






Click the Office button. Then click Excel Options
Click the Office button. Then click Excel Options
Then click Save. Enter a new location in the Default File Location box
Then click Save. Enter a new location in the Default File Location box
Click OK
Click OK








2.2.Workbook Open
2.2.1.Open a Workbook from the Excel WindowOpen a Workbook from the Excel Window
2.2.2.Open a Recently Opened WorkbookOpen a Recently Opened Workbook
2.2.3.Pin/Unpin a workbookPin/Unpin a workbook
2.2.4.Change the number of recently opened files that appear on the Office menuChange the number of recently opened files that appear on the Office menu
2.2.5.Change the default file location of the Open dialog boxChange the default file location of the Open dialog box