Problem exporting QB files to excel

[Denise Parejko]

Hi everyone-
Currently I am running Leopard, QuickBooks for Mac 2007 and Microsoft
Office for Mac 2008 (Home and Student Edition). I have had nothing but
problems with Excel ever since I downloaded Office Œ08 ­ especially in
tandem with Quick Books. Whenever I hit the ³export to excel² button to
convert reports to excel format, excel either will not open, or it will open
but not respond and needs to be force quit. Also, many times it will not
open period to open attachments from Entourage.

Has anyone else had these problems or know how to fix them?

Denise

 

[CyberTaz]

I'm afraid you'll probably have to get the solution from support at
QuickBooks - they're the ones that claim to be able to provide the
Excel-compatible file. It sounds to me like they haven't yet updated their
software to interface with the most recent release of Excel... or if they
have you've not yet acquired it

 

[Bob Greenblatt]

Hi everyone-
Currently I am running Leopard, QuickBooks for Mac 2007 and Microsoft
Office for Mac 2008 (Home and Student Edition). I have had nothing but
problems with Excel ever since I downloaded Office Œ08 ­ especially in tandem
with Quick Books. Whenever I hit the ³export to excel² button to convert
reports to excel format, excel either will not open, or it will open but not
respond and needs to be force quit. Also, many times it will not open period
to open attachments from Entourage.

Has anyone else had these problems or know how to fix them?

Denise

I don¹t know how quickbooks is exporting data. Usually it just writes a text
file. The fact that you are saying that quickbooks launches Excel leads me
to believe that quickbooks is expecting Excel to run some macros which is
not possible in Excel 2008. Your best bet is to contact quickbooks to see if
they have a workaround.

 

[Pam]

I, too, have had a problem with excel 2008 and QB Mac 2004. Here's a workaround I found online just now and it worked.
When you want the QB window in an excel format, instead of clicking "Export to Excel", go under "File" at top, pick "Save Report as Text" (or some other title such as "Export as text" if your software is another version), then open that text file with excel. It worked super and now I can relax. It doesn't keep all the old formatting - e.g. color, but it looks great to me. Audit season was going to be a bear without excel compatibility.

 

[Pam]

Oops, that was QB Pro 2005 for MAC that I use