I purchased 2019 QB accountant edition and is not functioning with my Excel 2007 program.

I purchased 2019 Accountant Quick book and unable to open the statement writer with my Excel 2007 program.  Support states that 2007 Excel is compatible with statement writer, but after 4 phone call no one is able to fix the problem

Answer

1 person found this helpful

Only Excel works with QB; you cannot use open source or Lotus or whatever other spreadsheet tool you have, because QB connects directly to Excel and Word as "Add in" connectivity. Statement Writer is a skin on Excel (all macros and embedded formats).

You didn't mention what "unable" means. Getting an error? Won't launch at all? This article shows the Warning message pop up; is that what you are getting? It lists the compatible Excel requirements and how to Bypass that for newer Excel:

https://www.accountexnetwork.com/blog/2014/09/make-quickbooks-statement-writer-work-office-2013/

Did you make sure the QB program allows the connection, in Edit menu > Preferences, Integrated Applications? I have mine set to Prompt, for the connectivity certificate?

Did you install Office/Excel as 32-bit? Microsoft warns you that this type of connectivity works better with 32-bit; QB is a 32-bit program, as well.

It appears that Office/Excel 2010 is the earliest supported by QB 2019, which is not by definition also the list for ISW, of course, but a good guideline:

https://quickbooks.intuit.com/community/Getting-Started/System-requirements-for-QuickBooks-2019-and-...

Here are earlier specs with installation/compatibility notes:

https://www.dell.com/support/article/us/en/19/sln70987/compatibility-between-versions-of-quickbooks-...

https://www.accountexnetwork.com/blog/2015/10/quickbooks-and-office-2016/


I have a computer with both Excel 2013 and 2016 installed, and it won't use 2016 and I haven't bother to address this. I know this, because Excel 2013 is lavender when it launches, and Excel 2016 is dark green. Please see my attachment.





Was this answer helpful? Yes No
Original
AllStar
1 additional answer

No answers have been posted

More Actions

People come to Accountants Community for help and answers—we want to let them know that we're here to listen and share our knowledge. We do that with the style and format of our responses. Here are five guidelines:

  1. Keep it conversational. When answering questions, write like you speak. Imagine you're explaining something to a trusted friend, using simple, everyday language. Avoid jargon and technical terms when possible. When no other word will do, explain technical terms in plain English.
  2. Be clear and state the answer right up front. Ask yourself what specific information the person really needs and then provide it. Stick to the topic and avoid unnecessary details. Break information down into a numbered or bulleted list and highlight the most important details in bold.
  3. Be concise. Aim for no more than two short sentences in a paragraph, and try to keep paragraphs to two lines. A wall of text can look intimidating and many won't read it, so break it up. It's okay to link to other resources for more details, but avoid giving answers that contain little more than a link.
  4. Be a good listener. When people post very general questions, take a second to try to understand what they're really looking for. Then, provide a response that guides them to the best possible outcome.
  5. Be encouraging and positive. Look for ways to eliminate uncertainty by anticipating people's concerns. Make it apparent that we really like helping them achieve positive outcomes.

Select a file to attach: