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

Discussion in 'General Questions' started by AndrewL3, Jul 19, 2016.

  1. AndrewL3

    AndrewL3 Bit poster

    Messages:
    1
    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.
     
  2. Arunn

    Arunn Parallels Support

    Messages:
    300
    Hi AndrewL3, update Quickbooks to the latest build and check if it works.
     
  3. susana1

    susana1 Bit poster

    Messages:
    2
    I think quickbooks pro has both CSV and Xlsx formats available for export because it has latest firmware version!
    Fordyce
     
    Raj@Parallels likes this.
  4. Raj@Parallels

    Raj@Parallels Guest

    Messages:
    467
    Thanks for sharing this information.
     
  5. VipulS2

    VipulS2 Bit poster

    Messages:
    2
    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
     
    Raj@Parallels likes this.
  6. Raj@Parallels

    Raj@Parallels Guest

    Messages:
    467
    Thanks for sharing this information.
     

Share This Page