500 sounds unmanageable for a user in one workbook. How about breeaking it up into several workbooks depending on your app?