Export to csv different than export to Excel
We're using BO XI r3. We've had a user report a problem when, in Infoview, they click document- save to my computer as csv. This results in duplicates.
Exporting via save report to my computer as = Excel does not. However, the csv export includes the drilling criteria in the left hand columns, the excel does not.
I'm at a loss to understand why exporting to excel seems to deliver what you see on the screen, whereas exporting to a .csv returns a more detailed list, with duplicates, with drilling attributes.
The user would like the .csv export (as it includes the drilling attributes) but without the duplicates.
I can't see how to do this but to design a new report with drilling credentials in columns, then export to excel.
How can I see what export to csv is doing?
Thanks in advance for any help