Community Homepage
Discussions
Categories
Quicken for Mac
Quicken Lifehub
Quicken Mobile
Quicken on the Web
Quicken for Windows
Support
Quicken Classic
Quicken Simplifi
Getting Started
Community Training FAQs
Using and Improving the Community
Connect and Engage
Announcements & Alerts
Announcements
Alerts, Online Banking & Known Product Issues
Product Ideas
Beta
Home
Quicken Classic for Windows
Reports (Windows)
Why does my exported excel file from a budget report have some Category headers incorrect
MarkG
See the two attached files
Find more posts tagged with
Comments
Sherlock
This is long standing bug. When exporting the
Budget
report to using
Copy to Clipboard
or
Export to Excel Workbook (.xlsx)
, Quicken is attempting to
normalize
the categories for the spreadsheet incorrectly. It appears, when searching for the category
Insurance
, the first match alphabetically is
Auto:Insurance
and, when searching for
Vacation
, the first match alphabetically is
Salary:Vacation
. If you haven't already, I suggest you report the issue to Quicken: select
Help > Report a problem...
There are a few ways to work around the issue. If you don't require the attempt to
normalize
the categories, I suggest you export a report to Excel compatible file by pressing
Ctrl + P
, choosing
Export to:
, and selecting
tab-delimited (Excel compatible) text file.
Otherwise, you may use unique category names or manually correct the error.
Quick Links
All Categories
Recent Posts
Activity
Unanswered
Best Of