work book taking long time to open
I have got an an issue with one for the work books it is taking 20 minutes to just open, but refreshes quite quick. size is only 1mb and only one data provider in the work book tried all the optimized settings as per attached document please help me.
Are you facing the same issue with the other Workbooks also?
Open the bex analyzer --> settings -> Select repair --> next open the work book. If any inconsistencies in the work book will be repaired.
This should resolve the issue.