sage excel intergrated reporting

Hi,

I have sage accounts 50 accounts 2009. I want to be able to use excel intergrated reporting I believe I have it installed but when I click on add ins it shows SAGE EIR add in but when I click browse nothing appears, Can someone help?
LVL 2
Dan560Asked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
Bruce DenneyConnect With a Mentor Sage 50 Consultant and IntegratorCommented:
Do a clean reinstall with the new security settings, that should fix things.

<installation directory>Reports is where they used to be.  I suspect the documentation you read related to an earlier version or has not been updated and is out of date.
0
 
Bruce DenneySage 50 Consultant and IntegratorCommented:
What version of Excel are you using?
0
 
Dan560Author Commented:
I am using Office 2003 professional edition
0
Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

 
Bruce DenneySage 50 Consultant and IntegratorCommented:
Do you have the Sage menu option at the top of the screen in Excel and the Sage Toolbar?

If not, i suspect it has been un installed or is for a previous version of Sage so get hold of the CD and re-run the installation making sure EIR is selected.
0
 
Dan560Author Commented:
It does have it there. but it wont let me select a company, when I do nothing appears. cant get my head round this one.
0
 
Dan560Author Commented:
I have attached a pic.
Basically I can see Sage toolbar but when I select sage company or application nothing happens not even an error message.

sage.bmp
0
 
Bruce DenneySage 50 Consultant and IntegratorCommented:
Does the "Select Company" option work?

Can you set it up to point to the dataset?

Have you read the Excel Integration pdf in the installation directory (normally located c:\program files\sage\accounts\Excel Integration.pdf) and followed the setup instructions?
0
 
Bruce DenneySage 50 Consultant and IntegratorCommented:
Have you upgraded or is this a new installation?

if an upgrade I would un-install and reinstall, as there was a similar issue in an older version, so it might be some "left over" remnant of a previous installation.
0
 
Dan560Author Commented:
It is a new installation. I even went through the setup on sage again and made sure EIR was selected. I found a few PDF's but nothing explaining how to set it up, I have tried forcing method by going to
C:\Program Files\Common Files\Sage SBD and clicking on  ForceEIRRegistration.exe
nothing though
0
 
Bruce DenneySage 50 Consultant and IntegratorCommented:
What happens when you select the "select company" option on the sage (7th top line "word") menu in excel?
0
 
Dan560Author Commented:
When I select company from the sage menu absolutley nothing happens, it just doesnt do anything, I dont even get any error messages.
0
 
Bruce DenneySage 50 Consultant and IntegratorCommented:
This is getting tough...

What level do you have macro security on?

Perhaps turn off to see if it enables things to run.
0
 
Dan560Author Commented:
It was set to high, but I have just set it to low. It didnt change anything
0
 
Dan560Author Commented:
I was reading that the EIR looks up the following directory to load its reports:
 C:\Program Files\Sage\Accounts\REPORTS\Excel
This folder does not exsist on my system, I think my reports are located in following locations:
C:\Documents and Settings\All Users\Application Data\Sage\Accounts\2009\company.000
C:\Documents and Settings\All Users\Application Data\Sage\Accounts\2009\company.001
C:\Documents and Settings\All Users\Application Data\Sage\Accounts\2009\company.003
 
Do you think it is looking in the wrong place for the reports?
0
 
Dan560Author Commented:
Hey
Thanks I did a complete reinstall and it worked :)
0
All Courses

From novice to tech pro — start learning today.