Microsoft Office 365 (Office 2013) and QuickBooks

Asked By 30 points N/A Posted on -
qa-featured

Hi Experts,

It is all about Microsoft Office 365 (Office 2013) and QuickBooks. The common features are given below:

Office 365

In light of the above mentioned theme let me know that QuickBooks is able to work with Office 2013.

Inventory Stock Status

Through the process mentioned above it seems that it is working well.

Have a look at some changes mentioned below.

Sample Template

So QuickBooks has created some special feature in Excel.

Special features Excel QuickBook option excel

Suddenly the QuickBooks tools has quit from the excel sheet. 

Quickbook option Disappeared

Finally it threw the error message. Have a look at the error message.

Error in MS Excel regarding Quickbook

Warning

The Microsoft Excel version installed on this machine is not compatible with QuickBooks.

Refer to QuickBooks Help topic for Microsoft Excel to see which versions are supported. You must have one of these versions to use Export.

OK

I think the error message indicates that some of its part is disabled to perform any action.

Primarily I got an empty spreadsheet. 

Just one Heading

Finally I found two spreadsheets and my data was in the second one. 

Excel Data Details

Please look at the items in Excel.

Excel Database

I transferred it to the QuickBooks and it worked smoothly.

Paste from Excel or type to add or modify list Prepare an Invoice Letter

It started off smoothly.

Create Invoice

But at the extreme point QuickBooks crashed threw the error message.

Quickbook Crashed

We apologize for the inconvenience. Please help the QuickBooks team eliminate this issue by providing us with the following information

View Report

Learn more about event reporting

Code: 00000 16203

Send Don't Send

What can I do now to solve the issue?

Please help.

SHARE
Answered By 5 points N/A #146041

Microsoft Office 365 (Office 2013) and QuickBooks

qa-featured

Hi,

Based on the screenshots you have provided it appears that there is a formula or a VBA macro configuration that is not compatible or is of a different format in excel to Quickbooks making it hot.

To go around this you will have to do some elimination process to see where the actual error is. To do this copy and paste the file in a per column, row or block setup.

Another is before you transfer the excel file to quick books I suggest you temporarily disable or remove any formula in a given column or row. This may take some time but this is the only what you can see which part is making QuickBooks fail.

If you do find what part of the sheet is failing you will have to manually convert the formula it has from excel to Quickbooks.

I hope this helps.

Thank you.

Related Questions