Child pages
  • Error: "Unable to locate the necessary files to perform this OfficeLink function"

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Next »

This information applies to MYOB AccountRight version 19. For later versions, see our help centre.


 

 

ANSWER ID:9237

AccountRight sends information to Microsoft Word or Excel using the OfficeLink connection. This happens when you create personalised letters (mail merge) in Word or send a report to Excel. There's a few things that can affect, or break, the OfficeLink connection which will result in an error.

This error can be caused by:

  • Not having Microsoft Office installed before AccountRight is installed. If your computer's hard drive is partitioned, make sure that both AccountRight and Microsoft Office are installed on the same partition.
  • Having Microsoft Word or Excel open when AccountRight tries to send the information
  • Missing or damaged OfficeLink files
  • Missing or damaged Microsoft Office files
  • A Windows corruption that prevents AccountRight from passing information to Microsoft Office

The tasks below will help fix this issue. Perform each task in order until your issue is resolved.

 

1. Register the OfficeLink drivers

OfficeLink drivers are "registered" in Windows each time your computer is started. If this registration fails, OfficeLink won't work.

To correct this:

  1. Simultaneously press the Windows Image and E keys on your keyboard (the Windows Image key is between the CTRL and ALT keys). The File Explorer or Windows Explorer window appears.
  2. Navigate to your AccountRight program folder. The table below shows the default location for your software. If you installed your software in a different location, navigate there instead.

    If you're using...

    Your installation folder is here...

    AccountRight Standard

    C:\Standard19

    AccountRight Plus

    C:\Plus19

    AccountRight Premier

    C:\Premier19

    AccountRight Enterprise

    C:\Enterprise19

  3. In your AccountRight installation folder, locate and double-click the file called drvxl32.exe. A window appears.
  4. Close this window.
  5. In your AccountRight installation folder, locate and double-click the file drvwd32.exe. A window appears.
  6. Close this window. The OfficeLink drivers are now registered.
  7. Restart your computer.

  8. Test the AccountRight function you were performing when the error occurred to see if the issue is fixed.

If the error persists, continue to Task 2.

2. Enable the OfficeLink macro

Repeat the following steps in both Microsoft Word and Excel.

If using this...Do this...
Office 2010 or 2013
  1. Open Microsoft Word and create a new document (don't save it).
  2. Go to the File menu and choose Options.
  3. Click Trust Centre then click Trust Centre Settings.
  4. Click Macro Settings then select the Enable all macros option.
  5. Click OK then click OK again to exit the Word Options screen.
  6. Exit Microsoft Word.
  7. Repeat steps 1 to 6 in Microsoft Excel.
  8. Test the AccountRight function you were performing when the error occurred to see if the issue is fixed.

If the error persists, continue to task 3. 

Office 2007
  1. Open Microsoft Word and create a new document (don't save it).
  2. Click the Office button in the upper left hand corner of the screen.
  3. Click Word Options > Trust Centre > Trust Centre Settings.
  4. Click Macro Settings then select the Enable all macros option.
  5. Click OK then click OK again to exit the Word Options screen.
  6. Exit Microsoft Word.
  7. Repeat steps 1 to 6 in Microsoft Excel.
  8. Test the AccountRight function you were performing when the error occurred to see if the issue is fixed. 

If the error persists, continue to task 3.

Office 2003
  1. Open Microsoft Word and create a new document (don't save it).
  2. Click Help > About Word > Disabled Items.
  3. The displayed window may contain a file named Addln:Myobmn97.dot. If so, highlight it and click Enable. If Addln:Myobmn97.dot isn't listed, close the About Word window.
  4. Exit Microsoft Word.
  5. Repeat steps 1 to 4 in Microsoft Excel.
  6. Test the AccountRight function you were performing when the error occurred to see if the issue is fixed.

If the error persists, continue to task 3.

3. Uninstall and reinstall AccountRight

Uninstalling and reinstalling AccountRight will replace any missing or damaged OfficeLink files.

To uninstall AccountRight

  1. Close all programs on your computer.
  2. Access the list of programs installed on your computer:
    • In Windows 8 or later: Right-click in the screen's bottom-left corner and choose Programs and Features.
    • In Windows 7/Vista: Click the Windows Start button and choose Control Panel then choose Programs and Features.
    • In Windows XP: Click the Windows Start button and choose Control Panel then choose Add/Remove Programs.
  3. Click the MYOB AccountRight software to be uninstalled then click Change. In some Windows versions this may appear as Change/Uninstall.
  4. If a confirmation message is displayed, click Yes.
  5. If the Setup window is displayed, select the Remove option.
    Image
  6. Click Next.
  7. Click Yes to the confirmation message.
  8. Click Finish once the uninstall process is complete.
  9. Restart your computer.

To reinstall AccountRight (with an installation CD)

  1. Close all programs on your computer. This includes disabling any anti-virus software.
  2. Place the MYOB software CD into the disc drive. If the installation window does not automatically display:
    1. Simultaneously press the Windows and E keys on your keyboard to display My Computer (or Computer).
    2. Double-click your CD-ROM drive (usually the D: drive).
    3. Locate the file named autorun.exe and double-click it.
  3. Follow the on screen prompts to complete the installation.
  4. When complete, restart your computer.
  5. Test the AccountRight function you were performing when the error occurred to see if the issue is fixed.

To reinstall AccountRight (via a download)

If needed you can download AccountRight from my.MYOB (providing you have an active support subscription). Once you've downloaded the installation file, complete the following:

  1. Close all programs on your computer. This includes temporarily disabling antivirus program.
  2. Double-click the downloaded installation file. The installation will begin.
  3. Follow the on screen prompts to complete the installation.
  4. When complete, restart your computer and re-enable your antivirus program.
  5. Test the AccountRight function you were performing when the error occurred to see if the issue is fixed.

If the error persists, continue to task 4.

4. Uninstall and reinstall Microsoft Office

Uninstalling and reinstalling Microsoft Office will refresh the components that are used by OfficeLink. For information on uninstalling Microsoft Office, please refer to the documentation that came with your Microsoft Office program.

Uninstalling and reinstalling Microsoft Office will affect the information stored in Outlook, including emails and contacts. Therefore this task should only be carried out by a qualified computer technician or someone who is familiar with this process and its impacts.

After uninstalling Microsoft Office:

  1. Uninstall AccountRight as described in task 3 above.
  2. Using Windows Explorer, navigate to the Microsoft Office folder and move any documents it contains to another location, then delete the Microsoft Office folder.
  3. Visit Microsoft's website and, if available, download and run a Windows registry cleaner for your version of Windows. If you are unsure about running the Windows registry cleaner refer to your IT consultant.
  4. Reinstall Microsoft Office.
  5. Reinstall AccountRight as described in task 3 above.
  6. Restart your computer.
  7. Test the AccountRight function you were performing when the error occurred to see if the issue is fixed.

If the issue persists, it suggests there is a problem with your Windows installation which will need to be investigated by an IT person.