Need more, need help now?
- - - - - - - - - - - - - - - - - - pay-as-you-go support - no contract - tenth of an hour billing - expert help - fast service - no call queues
Need integration?
- - - - - - - - - - - - - - - - - - with your shipping system - website - invoicing system - crm - cms - manufacturing - order import - back to back orders..
Need a report?
- - - - - - - - - - - - - - - - - - Excel reporting that pulls data from Sage - custom layouts - layouts that change adapt to your brands and/or for drop shipping.
Want web hosting?
- - - - - - - - - - - - - - - - - - Your own domain name - email - a shop - wordpress - woo commerce - ticket systems - help desks - forums - portals

Sage 50 Accounts & Excel

Sage 50 general help forum - Free help and support for all general issues
Post Reply
Alan Clark
User
User
Posts: 17
Joined: 20 Nov 2008, 17:47

Sage 50 Accounts & Excel

Post by Alan Clark » 31 Jan 2009, 13:02

I've recently installed Sage 50 Accounts 2009 and for some reason it has affected Excel.

When I now 'Save as' in Excel it defaults to SageLine 50. How do I change this back so that it defaults directly to my Excel files?

It's not a big problem but I would like to change it back to the way it was. :?:
Top
User avatar
brucedenney
Site Admin
Site Admin
Posts: 4664
Joined: 28 Feb 2006, 09:56
Sage Version: v30 UK/Europe/Africa

Post by brucedenney » 03 Feb 2009, 17:05

What is the default file location set in Excel?
For just about anything Sage :- Discount subscriptions, pay-as-you-go support, application integration, reports, layouts, linked excel spreadsheets, analysis or any other help making life with sage easier/less time consuming Contact me.
Top
Alan Clark
User
User
Posts: 17
Joined: 20 Nov 2008, 17:47

Post by Alan Clark » 03 Feb 2009, 17:18

As it stands if I 'Save as' it automatically defaults to Sage Line 50. Before installing the program it used to go through 'My Documents' to 'Excel' where all my folders/files are listed.

Hope that makes sense?!?
Top
User avatar
brucedenney
Site Admin
Site Admin
Posts: 4664
Joined: 28 Feb 2006, 09:56
Sage Version: v30 UK/Europe/Africa

Post by brucedenney » 03 Feb 2009, 18:39

In Excel

go to

Tools>Options and on the General tab look for Default file location
For just about anything Sage :- Discount subscriptions, pay-as-you-go support, application integration, reports, layouts, linked excel spreadsheets, analysis or any other help making life with sage easier/less time consuming Contact me.
Top
Alan Clark
User
User
Posts: 17
Joined: 20 Nov 2008, 17:47

Post by Alan Clark » 09 Feb 2009, 11:30

I did this and it is set up as D\Documents and Settings\Alan\My Documents\EXCEL.

I changed EXCEL to Excel and 'saved', and when I tried to 'save as' it was as I want it to be; defaulting to my Excel files.

However, if I then come out of Excel and then go back in, it goes back to defaulting to Sage Line50 and the Default file location has changed back to EXCEL not Excel.

It's not a big problem but just an annoyance that I can't get it right!

Regards,
Top
User avatar
brucedenney
Site Admin
Site Admin
Posts: 4664
Joined: 28 Feb 2006, 09:56
Sage Version: v30 UK/Europe/Africa

Post by brucedenney » 13 Feb 2009, 13:24

If you go back and check is it still saying

D:\Documents and Settings\Alan\My Documents\EXCEL

I assume the missing colon was a typo.

I can't reproduce your problem, so it is hard to help, what version of Excel are you using?
For just about anything Sage :- Discount subscriptions, pay-as-you-go support, application integration, reports, layouts, linked excel spreadsheets, analysis or any other help making life with sage easier/less time consuming Contact me.
Top
Alan Clark
User
User
Posts: 17
Joined: 20 Nov 2008, 17:47

Post by Alan Clark » 13 Feb 2009, 14:09

Sorry, it wa a typo. It's still showing D:\Documents and Settings\Alan\My Documents\EXCEL

I'm operating Excel 2002 (10.2614.2625).
Top
User avatar
brucedenney
Site Admin
Site Admin
Posts: 4664
Joined: 28 Feb 2006, 09:56
Sage Version: v30 UK/Europe/Africa

Post by brucedenney » 21 Feb 2009, 18:09

Just to be 100% clear.

Create a new sheet and press Crtl-S

what location does it prompt you with to save the file?
For just about anything Sage :- Discount subscriptions, pay-as-you-go support, application integration, reports, layouts, linked excel spreadsheets, analysis or any other help making life with sage easier/less time consuming Contact me.
Top
Alan Clark
User
User
Posts: 17
Joined: 20 Nov 2008, 17:47

Post by Alan Clark » 19 Mar 2009, 12:12

If I create a new Excel file and press 'Control S', the default comes up as 'Sage Line50'.
Top
User avatar
brucedenney
Site Admin
Site Admin
Posts: 4664
Joined: 28 Feb 2006, 09:56
Sage Version: v30 UK/Europe/Africa

Re: Sage 50 Accounts & Excel

Post by brucedenney » 02 Jun 2009, 16:15

Just found out that this is a bug in the Excel add in.

Some people have managed to work around it be enabling the "Sage Integrated Reporting Excel97 Linkage" as well.
For just about anything Sage :- Discount subscriptions, pay-as-you-go support, application integration, reports, layouts, linked excel spreadsheets, analysis or any other help making life with sage easier/less time consuming Contact me.
Top
Alan Clark
User
User
Posts: 17
Joined: 20 Nov 2008, 17:47

Re: Sage 50 Accounts & Excel

Post by Alan Clark » 02 Jun 2009, 16:55

Hello Bruce,

Don't know how I managed it but it seemed to self-correct a few weeks ago!!!
Top
flooman
User
User
Posts: 2
Joined: 06 Apr 2010, 15:24
Sage Version: v2009 15 UK/Europe/Africa

Re: Sage 50 Accounts & Excel

Post by flooman » 06 Apr 2010, 15:35

I have just installed sage 50 accounts professional 2010 vs16 and have the same problem with excel defaulting to Sage Line50.
Bug still appears to be there. Anyone know how to fix it?
Excel is 2002.
Top
flooman
User
User
Posts: 2
Joined: 06 Apr 2010, 15:24
Sage Version: v2009 15 UK/Europe/Africa

Re: Sage 50 Accounts & Excel

Post by flooman » 06 Apr 2010, 16:29

Just found out how to fix it !
Go into Excel, Tools, Add-ins and remove the tick on the Sage add-in.
Excel defaults back to the folder set up in Options, General.
Job done!!!
Top
User avatar
brucedenney
Site Admin
Site Admin
Posts: 4664
Joined: 28 Feb 2006, 09:56
Sage Version: v30 UK/Europe/Africa

Re: Sage 50 Accounts & Excel

Post by brucedenney » 14 Apr 2010, 14:18

Local support is always the best way, build a local relationship and it will server you for years.
For just about anything Sage :- Discount subscriptions, pay-as-you-go support, application integration, reports, layouts, linked excel spreadsheets, analysis or any other help making life with sage easier/less time consuming Contact me.
Top
cooldude
User
User
Posts: 1
Joined: 27 Apr 2010, 05:02
Sage Version: V09 UK/Europe/Africa

Re: Sage 50 Accounts & Excel

Post by cooldude » 27 Apr 2010, 05:07

Hi, Try this it worked out for me.

The following fix worked for me:

Open Excel
Click View, Toolbars, Customize
Click New to add a new toolbar – the default name ‘Custom 1′ is OK
Click the Commands tab and select Tools from the left column. Scroll down the right column to COM Add-Ins and drag this to the new toolbar.
Click Close to close the customise screen
Click on COM Add-Ins on the new toolbar and untick Sage Integration Option.
Close the new toolbar
Click View, Toolbars, Customize
Select Custom 1 from the Toolbars tab a click Delete to remove it.

Your Excel default directory should now revert to ‘My Documents’ or your chosen alternative
Top
Post Reply

Return to “Sage 50 UK version General Help”

Who is online

Users browsing this forum: No registered users and 1 guest