This article troubleshoots an error that occurs when clicking on Enter Data window.
When a user clicks on Enter Data Window, they receive the following error message:
"Error occurred while performing this task. Invalid index. (Exception from HRESULT: 0x8002000B (DISP_E_BADINDEX)) at Microsoft.Office.Interop.Excel.Sheets.get__Default(Object Index) at Planning.clsExcelReaderWriter.GetRangeFromAddress(Workbook wb, String sRngAddress) at Planning.clsSIM.FillActualSetting() at Planning.clsSIM..ctor(Int64 rowno, Int64 gridRowNumber, Boolean flag, Boolean connectionestablish) at Planning.frmInfoManager.RetriveData(Boolean flag, Boolean FlagDisplayUI) at Planning.frmInfoManager.frmInfoManager_Load(Object sender, EventArgs e)"
This is caused by certain department does not have any data for the certain section. For example, some departments have Revenue data and some departments don't have revenue so when clicking on Enter data for department that does not have revenue, user will receive the above error message.
Create a blank row above the first data input row and add an ignore syntax for this row. Then add this row in Data and Interface settings. This will ensure that data and interface settings are pointed to a row that will always render.