Thanks for the advice! I'll try running it first and see what it shows.
As Ritesh suggested the way to improve workbook performance is to create a recording of your interactions with the workbook, including opening it. There are a couple of things to look our for:
- avoid blending on many unique values IDs and reduce data. If it is not possible, consider joining data sets together moving to single data source
- displaying too many marks, you might be viewing too many rows at once (particularly if you are using tables consider changing these to other chart types)
- the type of calculation used may affect performance, from left fastest to slowest: Number and Boolean>date>string
I would also suggest to publish your Extract onto Server rather than connecting to it from the Network drive as you see an improvement of load times in your workbook being hosted there.
Hope this helps.