SCENARIO

The downloaded Project table does not contain project data.

SOLUTION

This issue arises due to a formatting problem with Excel. When audit trails are excessively long in Excel cells, they might not display all the data, resulting in the file not showing the data correctly. It's important to note that this limitation is attributed to MS Excel.

1. After downloading the Project table, exclude the audit trail to eliminate the formatting problem.
2. Look for the specific Project in question.
3. Download the table again, including the audit trail.
4. Open the file in a text editor such as Notepad, not in Excel.
5. Remove most of the data in the file, leaving the very first line intact, and remove two-thirds of the file.
NOTE: Leave the bottom third untouched
6. Click Save.
7. Open in Excel and filter. If the formatting problem persists, use CTRL+F to search for the name of the project.

NOTE: This solution addresses the formatting issue in Excel and ensures that the downloaded data is properly displayed.