I have an Excel 365 .xlsx spreadsheet that I am trying to read into a FME 2021 workspace. When I try to read it, it gives me an error message:
|ERROR |Excel Reader: Could not open file '...\input.xlsx', file is too large. Try switching to 64-bit FME, or exporting the Excel file to CSV. If the file is exported to CSV, formulas and formatting will be lost...
T
I cannot change the spreadsheet to a .xls, it has to remain a .xlsx.
Any ideas on how to solve this?
The spreadsheet I need to read is 22mb with approximately 93,000 records.