I have a workbook that takes way too long to load. When I run the performance trace in sever the overwhelming amount of time, about 80 seconds , is spent on "Building View" while the next closest event is 5 seconds. Similarly, when I run the trace in desktop I find that "Open Workbook" takes 70 seconds and the next closest is also 5. For the life of me I have not been able to find any information on what these events entail or how to reduce the time it spend on these tasks. Both appear to be load related.
I would post the workbook but unfortunately it contains data that I cannot share.