Skip to content

Fix : QuickBooks Runtime Error 13 Type Mismatch

    What is QuickBooks Runtime Error 13 Type Mismatch Issue?

    The QuickBooks Runtime Error 13 Type Mismatch is a type of error that generally occurs when we execute the code in an Excel file. When this error occurs, all your ongoing processes/activities related to the Excel application may get terminated. It may also affect XLS OR XLSX files adversely. 

    This is one of the most common issues faced by QuickBooks users. But, if you have faced this issue, this blog can help you immensely. We understand it is quite frustrating to face such issues while you are in the middle of something important. This is why; we are discussing some easy solutions to fix this issue. Just go through this blog till the end and get rid of this issue.

    Here we go! 

    Simple Solutions to Fix QuickBooks Runtime Error 13 Type Mismatch Issue 

    Here are some simple solutions to fix the QuickBooks Runtime Error 13 Type Mismatch issue

    Total Time: 33 minutes

    Use Open & Repair Utility Tool in Excel

    Use of this tool in excel will enable you to recover damaged or corrupt files. Please carry out the following steps –
    🔷 Open Excel
    🔷 Go to the File menu
    🔷 Click Open
    🔷 From the drop-down box, select the corrupt file
    🔷 Click on Open & Repair
    🔷 Now click on Repair
    🔷 After the repairing process gets completed, open QuickBooks and check if the issue is still there

    Edit Registry Key

    🔷 Log in to your system as an admin 
    🔷 Go to the Start menu
    🔷 Type Regedit on the space provided
    🔷 Press Enter
    🔷 The Registry Editor window will open up on your screen
    🔷 Browse to the path HKEY_CURRENT_USER\Software\Intuit\ QuickBooks\Security
    🔷 Click Edit
    🔷 Tab on New
    🔷 Opt for the DWORD value
    🔷 A new registry key will pop up on the right of the screen
    🔷 Name it as AllowOMWithUI and press Enter
    🔷 Now right click on the key to edit it
    🔷 A dialogue box named Edit DWORD Value will appear
    🔷 On the Value Data field, enter 1
    🔷 Press Enter
    🔷 Close the Registry Editor
    🔷 Restart your computer
    🔷 Open QuickBooks and check if the issue is still there

    Also Read -: How to Fix QuickBooks Error 1618

    Recover Missing Macros

    🔷 Open a new excel file
    🔷 Set the calculation mode to ‘manual’
    🔷 Go to the Tools menu
    🔷 Click on Security
    🔷 Select High
    🔷 Click on the Office tab
    🔷 Go to Excel options
    🔷 Navigate to Trust Center on the left
    🔷 Now click on the Trust Center Settings  tab
    🔷 Go to Macro Settings
    🔷 Mark the checkbox next to ‘Disable all macros without notification’
    🔷 Click the OK button two times
    🔷 Open the corrupt/damaged workbook
    🔷 A message will appear stating that ‘Macros are disabled’
    🔷 Now press Alt+F11 together to open the MS Visual Basic Editor
    🔷 Open Project Explorer
    🔷 Right click on a module
    🔷 Click on Export file
    🔷 Type in a name and folder for the module
    🔷 Repeat these steps multiple times till the entire module gets exported
    🔷 Close the Visual Basic Editor and Exit
    🔷 Open QuickBooks and check if the issue is still there

    Conclusion :

    All the solutions discussed above are simple but effective ones. You just need to perform the procedure sequentially and fix thisissue once and for all!  However, if none of the above-mentioned methods helps solve the issue, you may reach out to some of the experienced QuickBooks experts. 

    You May Also Read -: How to QuickBooks Won’t Export to Excel

    💠 Frequently Asked Questions💠

    What are the Reasons for the Occurrence of the QuickBooks Runtime Error 13 Type Mismatch Issue?

    Many technical reasons may lead to the occurrence of the QuickBooks Runtime Error 13 Type Mismatch issue. Some of these are listed below
    ▪ When there is a mismatch between various software applications you intend to use
    ▪ When multiple files or methods are needed to start a program that works on the Visual Basic platform
    ▪ Damage of Windows system files or Excel files due to Virus/malware infection 
    ▪ When the user clicks on any macro/function that is created by another macro
    ▪ Compatibility issues between the operating system  and the software 
    Incomplete installation of MS Excel
    ▪ When a user tries to run VBA codes that include mismatched data types

    What are the Symptoms of the QuickBooks Runtime Error 13 Type Mismatch Issue?

    When the QuickBooks Runtime Error 13 Type Mismatch issue occurs on your system, you may get different symptoms depending on your system configuration or the Windows version you are using. Some of the notable symptoms are as follows-
    ▪ The Windows operating system gets frozen
    ▪ QuickBooks is not responding properly
    ▪ Processing of inputs submitted by keyboard and mouse is slow
    ▪ QuickBooks is freezing or becoming slow
    ▪ The Windows operating system gets crashed

    Why do I face the QuickBooks Won’t Export To Excel Issue?

    Some of the reasons for the occurrence of this issue are listed below-
    ▪ Improper functioning of the file registry
    ▪ Damaged or corrupted MS Excel.
    ▪ The QB application may have got damaged or corrupt.
    ▪ QuickBooks is not updated to the latest release

    Leave a Reply

    Your email address will not be published. Required fields are marked *

    three + eight =