According to this range, the new drop-down list will show the same options that are written in the A1 to A5 cells. Read: How to connect Google Sheets with Microsoft Excel.