Quickbooks for Windows, .xlsx export with MS Office for Mac

A

AndrewL3

Bit poster
Is there a way for me to export .xlsx files from Quickbooks for Windows if I have MS Office for Mac while running on Parallels? I'm currently only able to export .csv files and it is not pulling in the current formatting of reports.
 
Make sure to update your QB as the latest version of QB pro probably has the feature you are looking for:
  1. Make sure QuickBooks for Mac is at latest release:
    1. Go to the QuickBooks > Check for Updates.
    2. Apply any updates & retry.
  2. Go to Finder > Go > Go To Folder.
  3. Type ~/Library in the text field and hit Go.
  4. In the Library folder, navigate to Caches > Temporary Items folder to see your exported reports.
  5. Double click on the report (such as A/R Summary.xlsx) to see if it opens.
    1. If it still fails to open, rename it something basic such as report.xlsx or report.xls and see if it opens.
    2. If it still fails to open, go back to the report and try exporting a unmodified report to determine if filtering the report broke it.
Source: https://community.intuit.com/questi...to-ms-excel-for-mac-2011-from-qb-for-mac-2015
For QB hosting related information visit: myrealdata.com
 
VipulS2 said:
Make sure to update your QB as the latest version of QB pro probably has the feature you are looking for:
  1. Make sure QuickBooks for Mac is at latest release:
    1. Go to the QuickBooks > Check for Updates.
    2. Apply any updates & retry.
  2. Go to Finder > Go > Go To Folder.
  3. Type ~/Library in the text field and hit Go.
  4. In the Library folder, navigate to Caches > Temporary Items folder to see your exported reports.
  5. Double click on the report (such as A/R Summary.xlsx) to see if it opens.
    1. If it still fails to open, rename it something basic such as report.xlsx or report.xls and see if it opens.
    2. If it still fails to open, go back to the report and try exporting a unmodified report to determine if filtering the report broke it.
Source: https://community.intuit.com/questi...to-ms-excel-for-mac-2011-from-qb-for-mac-2015
For QB hosting related information visit: myrealdata.com
Click to expand...
Thanks for sharing this information.
 
You must log in or register to reply here.
Back
Top