Reply
This thread is now archived and closed to new comments.
If you have a question please post a new topic.
Cover User
Clodagh
Posts: 2
Registered: ‎02-06-2011
0 Kudos

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?

Please use plain text.
Valued Partner
easybusiness
Posts: 318
Registered: ‎17-06-2010
New Zealand
0 Kudos

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.
Please use plain text.
Ultimate Partner
Mike_James
Posts: 2,415
Registered: ‎08-05-2007
New Zealand
0 Kudos

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 cross-platform sales management add-on
DataWise Report Writer - Specialised Reporting from MYOB programs
Please use plain text.
MYOB Moderator
Reece
Posts: 26
Registered: ‎29-12-2010
New Zealand
0 Kudos

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

Please use plain text.
Ultimate Partner
jenniek
Posts: 1,385
Registered: ‎28-06-2007
New Zealand
0 Kudos

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
Please use plain text.
User
events
Posts: 1
Registered: ‎04-06-2011
Australia
0 Kudos

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

Please use plain text.
Ultimate Partner
jenniek
Posts: 1,385
Registered: ‎28-06-2007
New Zealand
0 Kudos

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
Please use plain text.
Cover User
Planet
Posts: 2
Registered: ‎07-07-2011
Australia
0 Kudos

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

Please use plain text.
Contributing Cover User
JPeace
Posts: 25
Registered: ‎30-09-2010
Australia
0 Kudos

Re: MYOB can't export to Excel Office 2010

Totally Same as Me...

 

Can anybody help?

 

Please use plain text.
Ultimate Partner
Mike_James
Posts: 2,415
Registered: ‎08-05-2007
New Zealand
0 Kudos

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 cross-platform sales management add-on
DataWise Report Writer - Specialised Reporting from MYOB programs
Please use plain text.