I cannot find a way to change my default folder when I want to open a file
back to it's previous state. I recently installed an accounting programme on
my PC and now when I go to FileOpen I endup in
C:\Programfiles\accountprogramme.

I am running Excel 2007 and already tried changing the default file location
without success.

Many thanks

Hi there! I can definitely help you with changing the default folder when opening files in Excel 2007.

Here are the steps to change the default folder:

1. Open Excel 2007.
2. Click on the Office button in the top left corner of the screen.
3. Click on Excel Options at the bottom of the menu.
4. In the Excel Options window, click on the Save tab.
5. Look for the Default file location field and click on the Browse button next to it.
6. Choose the folder you want to set as the default folder for opening files.
7. Click OK to save the changes.

Now, when you go to File Open, you should be directed to the folder you set as the default.

If you're still having trouble, it's possible that the accounting program you installed changed some settings in Excel. In that case, you may need to uninstall the program or contact their support team for assistance.

EXCEL 2007

Try the following:-

Office Button (top left hand corner)

Excel Options (lower right hand corner)

Save (on the left hand side)then, on the right hand side, in the Save
workbooks section at the top, change the Default file location: field to the
option of your choice.

OK

TO TEST THAT THE ABOVE HAS WORKED

File / Open - it should open to the directory that you have set above.

If my comments have helpled please hit Yes.





"Wackyracer" wrote:

I cannot find a way to change my default folder when I want to open a file
back to it's previous state.

I recently installed an accounting programme on
my PC and now when I go to FileOpen I endup in
C:\Programfiles\accountprogramme.

I am running Excel 2007 and already tried changing the default file location
without success.

Many thanks

Hi,
I have exactly the same problem, I installed an Accounts program (Sage Instant Account V16) and now every time I open or Save it goes to the Accounts installation folder.

I have changed correctly in Option/default File Save location. Restarted, rebooted.

Word & other programs are working correctly.

Even if I Save As c:\my docs\test.xls, close excel, start excel, open - It goes straight to "..\sage line 50"

If you options/change default location it then opens correctly but as soon as you exit it goes back to the \accounts even though it is still correct in the options setting.

Very odd, bloody Sage software..

Any ideas, driving me mad.





trip_to_tokyo wrote:

EXCEL 2007Try the following:-Office Button (top left hand corner)Excel Options
03-Jun-10

EXCEL 2007

Try the following:-

Office Button (top left hand corner)

Excel Options (lower right hand corner)

Save (on the left hand side)then, on the right hand side, in the Save
workbooks section at the top, change the Default file location: field to the
option of your choice.

OK

TO TEST THAT THE ABOVE HAS WORKED

File / Open - it should open to the directory that you have set above.

If my comments have helpled please hit Yes.





"Wackyracer" wrote:


I recently installed an accounting programme on

Previous Posts In This Thread:


Submitted via EggHeadCafe - Software Developer Portal of Choice
LINQ With Strings
http://www.eggheadcafe.com/tutorials...h-strings.aspx

I know this thread is a little old now, but just in case anyone else finds it while searching for an answer, I worked out what the problem is. It’s caused by a Sage integration dll (dynamic link library add-in) which allows certain Sage functions to be called from within Excel. Basically, it’s a bug in that function which needs fixing by Sage, disabling the add-in will fix the problem, you can always re-enable it if you really need to (most won't).

To make Excel remember the default directory, do the following:
1. Open Excel
2. Click the round “Office” button in the top left-hand corner, then click the button that says “Excel Options”.
3. From the list on the left, click “Add-ins”.
4. From the drop-down menu at the bottom choose “Com Add-ins” then click the “Go” button.
5. Un-tick the box next to the Sage Integration.
6. Click “ok” and close all menus.

You’ll then be able to set the default open/save directory and Excel will remember it.

HTH