We are running Istanbul and it looks like we have a hard limit of 10,000 rows for Excel. I found a setting in the ServiceNow console under System Properties --> Import Export with a Save button but I cannot change anything even with a priviledged account. The default value is 10,000 for .xlsx files but it looks like there is no way to edit this number. Need to know what I am doing wrong. There is just a Save button which tells me there must be some way to change these values.
You can directly go the sys_properties table and update the property glide.excel.export.limit to 50000 and try. Also do a cache.do after changing the settings.
Thanks. I saw that but there is no way to change the values. Just a Save button in the upper right corner but the values are read only. Do I need to be a member of a group? Why a Save button if you can't change anything. Logged in with an Admin account. Very strange. I also do not see a property called glide.excel.export.limit under Excel. Do I need to add it? What is cache.do? I am a novice.
