It is taking a good minute to load 1 of my layouts. Wondering if anyone has suggestions on how to cut this back significantly.
The layout currently finds ~52 fields.
Each record has several calc fields;
-a start date which is unstored and looks for matching contents from 1 of the other 52 fields.
-an end date whisch is also unstored and does the same as start
-10 calc fields that are global
-5 unstored calc fields
7 of the unstored calc fields are repeating 127x
within each record of the 127 repeats, there is conditional formatting
Any ideas on how to speed up?