Quote:
Originally Posted by bignose
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