Start a Post

MYOB can't export to Excel Office 2010

This thread is now archived and closed to new comments.
Some of the links provided in this thread may no longer be available or relevant.
If you have a question please post a new topic.
2 Posts
Cover User

MYOB can't export to Excel Office 2010

I bought two PC's with Office 2010 and 64 bit. MYOB can't export to Excel from Office 2010. I use multi currency so my reports don't total so Excel is a must. Any solutions?

11 REPLIES
318 Posts
Valued Cover User
New Zealand

Re: MYOB can't export to Excel Office 2010

You should be able to get some reports to show a total. In some of the report customisation windows there is the finishing tab. For some reports you can select the option "Display in" option to be "Local Currency"

 

That should give you totals in some reports.

Graeme Muir

EasyBusiness Consulting- Making the bookwork simple
Helping you with MYOB setup and installation in Christchurch

To chat about your training and support needs in the Christchurch area call us on 0800 160 260.
3,068 Posts
Ultimate Partner
New Zealand

Re: MYOB can't export to Excel Office 2010

The usual reason for not seeing totals when using multi-currency is that you have to select one currency for the report, as it will not make sense to add several currency values together.

Regards Mike (mike@datawise.co.nz)
DataWise Limited (www.datawise.co.nz), developers of:
DataWise ProActive - Multi-user sales management add-on
DataWise Report Writer - Specialised Reporting from MYOB programs
26 Posts
MYOB Moderator
New Zealand

Re: MYOB can't export to Excel Office 2010

Hello,

 

In regards to Office 2010, Office 2010 64bit does not currently work with AccountRight, Office 2010 32bit does work with AccountRight. Office 2010 32bit will need to be set up the same as Office 2003 or 2007.

 

This support note covers some of the office link connection alerts. If this does not resolve the linking with Office 2010 32bit, can you please post the alert/error you are receiving.

 

Regards

Reece

1,967 Posts
Ultimate Partner
New Zealand

Re: MYOB can't export to Excel Office 2010

Thanks for that info Reece - I've been wondering why office 2010 works with some clients but not others.

Regards,
Jennie Kingma
JK Business Systems Ltd, Hamilton, NZ
Email: jennie@jkbusiness.co.nz
1 Post
User
Australia

Re: MYOB can't export to Excel Office 2010

Hi, new to the forum and MYOB

When exporting reports to excel I receive the message "unable to locate the files to support the OfficeLink function"

My config is

Win 7 64 bit

Office 2010 32bit

MYOB Accounting Ver 18

I have followed through google searches and references in this forum

To date I have

Un-installed MYOB

Uninstalled Office 2010

Renamed the old MYOB18 directory

Then re-installed office and associated updates

then re-installed MYOB

Then repeated the process when this still did not work

 

Looking in the MYOB18 directory I cabnnot not find the drcxl32.exe file  so I cannot re-register in Win7. Does this indicate something is amiss.

 

Can anyone confirm that Accounting V18 can export to Excel 2010 32 bit

or provide any other help please

 

PS I have exported to html files and then imported these into excel but for the end user these is messy and not a viable solution

 

Appreciate your reply

1,967 Posts
Ultimate Partner
New Zealand

Re: MYOB can't export to Excel Office 2010

Version 18 of MYOB won't be compatible with Office 2010 - because Version 18 is much older and Office 2010 didn't exist back then.

Regards,
Jennie Kingma
JK Business Systems Ltd, Hamilton, NZ
Email: jennie@jkbusiness.co.nz
2 Posts
Cover User
Australia

Re: MYOB can't export to Excel Office 2010

Hi,

 

I am using MYOB AccountRight Premier v19. Recently my PC was changed and we reinstlled MYOB into the system. Now the problem is I cannot send reports to Excel, and it says "Unable to locate the necessary files to perform this Officelink function"   

My PC operating system is ;

Windows 7 Professional

32-bit operating system

Office 2010

 

Can anyone help me solve this problem?

 

Roy

25 Posts
Contributing Cover User
Australia

Re: MYOB can't export to Excel Office 2010

Totally Same as Me...

 

Can anybody help?

 

3,068 Posts
Ultimate Partner
New Zealand

Re: MYOB can't export to Excel Office 2010

See http://community.myob.com/t5/General/MYOB-not-compatible-with-Office-2010/m-p/46031#M5131 for MYOB's comments and suggested solution.

Regards Mike (mike@datawise.co.nz)
DataWise Limited (www.datawise.co.nz), developers of:
DataWise ProActive - Multi-user sales management add-on
DataWise Report Writer - Specialised Reporting from MYOB programs
Didn't find your answer here?
Try using advanced search to find a post more easily Advanced Search
or
Get the conversation started and make a new post Start a Post