Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, I have added a new sheet to a existing Document. When users are clicking on this sheet to try and open it, it is taking over 2 minutes to open. Any reason how to improve this? Thanks
The problem is due to big amount of data or really complex expressions.
In the first case try to filter on some fields (with triggers) when you enter the sheet, this will reduce data amount.
Otherwise if expressions are too complicated, try to review using set analysis (try expression one by one)
Look at the Sheet Properties > Objects tab and see what Object's Calc Time is taking the longest which may give you an idea about why it's taking a while
Hi, Denis.
If none of the above recommendations work, try pressing Ctrl-Shift S.
This will reveal any hidden objects which can also be a drain on resources.
Regards,
Neil
This is the sheet properties showing for this sheet, is there anything on here that is alarming?
Lots of if statements can sometimes cause delays in calc times or unresponsive sheet/objects. I'd say make the effort of going through your solution and trying to change if statements into set analysis statements where applicable. Also if your expressions are complex you can pull them off the objects/chart and flag them in the load script, I have done this before on dashboard that was sort of laggy and it helped a great deal.
Hi Denis
As Alessandro said i am also sure that you have used Complex Expressions in your Charts.
Checklist:
1) Try to Optimize your Expressions in the best possible way. Use Set Analysis.
2) Remove unwanted Charts, Objects, Tables if not required.
3) Work on your Data Model, remove synthetic Keys if any.
4) Go to Document Properties and see the Sheet ID which is taking Longer time to open. when you do single click on it, you will see all the objects using in the Sheet. If you found any Duplicate charts or any unwanted Charts you can delete it from there only.
Kindly see the Attachment for it.
5) Finally, if your have Bulk data try setting Triggers for Max Year and Max Month. This will definitely reduce the Opening Time of the sheet and you will make your Users Happy.
Hope that Helps You.
Regards
Aviral Nag
That TX84 with a calc time of 453 looks a little suspicious.
The Calc times shown are the last calc time. Is the display you posted taken right after clicking on the sheet? Or were there other clicks?
For the most accurate results.
1. Close and then Open the document.
2. Click on the sheet.
3. When the sheet becomes ready, then right-click view the Object list in the sheet properties.
-Rob