I am facing issue while selecting any filters. When the users are selecting any filters on access point it takes lot of time for selecting more than one filter and to filter out data. Performance lag is observed. Is there any way that i can improve the performance of application?
It sounds like your document contains either a lot of objects or objects with complex expressions and/or calculated dimensions and or variables with complex expressions. Any selection would cause all these to be recalculated leading to the performance problems you experience. You can find some information about calculation times of chart objects on the Objects tab of the sheets properties window. For a more complete analysis of your document use the Document Analyzer: Document Analyzer V3.0 Update Available
