Can't Open Excel file generated from SAP

Hi all

I’m currently extracting a table from SAP using “List, Export, Spreadsheet” in the SAP GUI and saving the file as this format


the problem is when I try to use a read range I always get this error

“Read Range: Row number must be between 1 and 1048576”

I’ve checked already and I only have like 10,000 rows. Is there a problem with SAP excel files or has anybody got a solution for this? Thanks

@kahoyim Have you Checked this Post, This may Solve it :

@kahoyim Hi! You managed to solve this? I could not understand what the VB Script code would be like to solve this