The Windchill Uses and Occurrences tables both have a hard coded limit of 500 items before paging is enabled. There is no way to change this number and it also dictates the information exported from the table. This limit should not be hard coded and users should be able to set a preference or tick a box for how many items they want to see in the table.
In my case, I have 775 items in the Occurrences table and I have to export the table twice and then merge the XLS files together. Maybe this is okay for a single task, but not acceptable when there are more large designs with over 1,000 items listed in the Occurrences table. Getting this data out of Windchill becomes extremely difficult.