Fund Statement Export formatting is not Correct when Opening in Excel
- 18 Jan 2023
- Contributors
- Print
- DarkLight
- PDF
Fund Statement Export formatting is not Correct when Opening in Excel
- Updated on 18 Jan 2023
- Contributors
- Print
- DarkLight
- PDF
Article summary
Did you find this summary helpful?
Thank you for your feedback
When opening a fund statement export file in Excel, the data is some of the columns is not formatted correctly and shifts to the left in the spreadsheeet.
Answer:
This issue is caused by a carriage return in the fields. To prevent this, select the "Exclude block text fields from Export." as outlined in this help guide in the Running the Fund Statements Export section.
Exclude Block Text Fields from Export: You may want to select this checkbox if you plan to open the exported data in Excel. Selecting this checkbox will exclude the Gift Language text block (from the Fund 2 tab of the Fund record) from the export. If you do not exclude it, and there are carriage returns in the text block, it will prevent a clean import into Excel (Excel considers carriage returns as the start of a new record). If there are no carriage returns in that text block, it will import into Excel without a problem. You do not need to select this checkbox if you are merging into Microsoft Word.
Was this article helpful?
