Unable to open Publish Plan report CSV file in Excel due to huge data
User runs a Publish Plan ESS job in scheduled process application by selecting following parameters,
Plan Name: Procurement Plan
Table Name: CGT Material Plan
Source System: OPS
They download the report generated by submitting this process in File Import and Export application using process ID. The CSV file has huge data and disoriented so Business wants to use Excel to view this data for their decision making process. However, due to limitation of rows in Excel they're unable to view all the data from CSV file.
Please provide us alternate solution for this problem.
1