Print portfolio no longer prints to excel?

me
me Member ✭✭✭
in Reports (Windows)
When portfolio is on the screen, there is a option File:Print Portfolio that has allowed export to Text, Excel, and 1-2-3 for just about forever.

The print to excel doesn't work. When you chose it says it will print to a txt file and does.

Any suggestions?

Answers

  • splasher
    splasher Quicken Windows Subscription SuperUser ✭✭✭✭✭
    Seems like it is there for me:


    Running 27.1.29.12 on Win10

    -splasher using Q continuously since 1996
    - Subscription Quicken - Win11 and QW2013 - Win11
    -Questions? Check out the Quicken Windows FAQ list

  • me
    me Member ✭✭✭
    edited October 2020
    Choose it and see what happens. It tries to save a text file (it used to be a comma delimited file.)
  • Rocket J Squirrel
    Rocket J Squirrel Quicken Windows Subscription SuperUser ✭✭✭✭✭
    That ancient dialog needs some correction.
    Printing to a tab-delimited file results in a .txt file.
    Printing to a 123-compatible file results in a .prn file.
    Excel doesn't handle these well with those file extensions. Rename them to be .csv files and Excel will open them more gracefully. The PRN (123) format is true CSV and works well except for the file extension.

    Quicken user since version 2 for DOS, now using QWin Biz & Personal Subscription (US) on Win10 Pro.

  • Jim_Harman
    Jim_Harman Quicken Windows Subscription SuperUser ✭✭✭✭✭
    To build on RJS's comment, if you choose 123 format but give the file a CSV extension, you can generally open it directly in Excel with out going thru the text file import process.
    QWin Premier subscription
This discussion has been closed.

Categories