AnsweredAssumed Answered

Export to Excel issue in 15.2

Question asked by giriraj.gupta1 on May 30, 2018
Latest reply on Apr 8, 2019 by PPMRider

Hello guys,


We have just upgraded our system from 13.3 to 15.2 and facing issue while extracting data in Export to Excel.


In 15.2 User is trying to extract project list data ( 10-15 columns and 1500 - 2K rows) and while using option Export to excel, after some time Excel file is generating with following message inside -


The system has determined that this export to Excel will take 43.43 minutes to complete, which is greater than the allowed amount of time. The operation has been stopped by the system. Please refer to the online help for more info.


Data with same number of rows, filters and columns is easily being extracted by System administrator with 2-3 mins in 15.2.


When user tried to extract same number of rows, filters and columns in export to excel in 13.3, it is taking 7-9 mins. User has tried to reduce number of columns in 15.2 but still getting same message in generated excel file.


All Parameters are set with default value as follows. Number of rows are not too high and all Columns on list page are in Project properties page and user has view access on it so this should not cause of taking long time.


So Please any suggestions on Why 15.2 system is taking too much time in Export to excel? Is there any config is missed out while upgrading to 15.2?