Please follow the exact steps below and let us know if this helps in displaying the worksheets and workbooks in the dropdowns:
- Log in to OneDrive.
- Instead of opening the Excel file directly, search for Excel files by entering "xlsx" in the search bar.
- Click on the required .xlsx file to open it.
- Go to Pabbly Connect, reconnect with Excel in the action step, and check if the workbooks appear.
- If the workbooks still don’t appear, try refreshing the fields multiple times.
