I would like to know how I can set up a default folder in windows 7 when opening up Office workbooks. If I open up Excel 2010, It defaults to to My Documents. However, if I click on a folder "Fixed Assets" to open up a workbook, Excel looks at the latest folder when wanting to open up further files. I want Excel to always default to My Documents

Your assistance in this regard will be most appreciated