Problem
After configuring the Requirements Management for Jira add-in for Microsoft Excel and loading data from any R4J project, no issues are imported and only the header/columns are displayed in Excel.
Cause
The default maximum number of issues to return from Jira search results may have been configured to 0. In fetching issues to be imported, Excel add-in calls Jira API GET /rest/api/2/search which is affected by the maximum allowable value configuration.
Solution
As JIRA Administrator, go to System > General Configuration > Advanced Settings.
Search for the jira.search.views.default.max key.
Set value from 0 to the minimum count of issues (e.g. 1000).
See image for reference:
Load data from a project in Excel add-in.