I meet similar problem while using xlsx library. When there are tail blank in the sheetname, some error would occur.   For example, there is a sheet named 'test 1 ' in file 'test.xlsx', and we use xlsx library to read this file:   libname test xlsx '....../test.xlsx'; then SAS will treat the dataset as test.'test 1'n rather than test.'test 1 'n.     ERROR: Couldn't find range or sheet in spreadsheet ERROR: File MULTI.'E7080-C086-108'n.DATA does not exist. Assume that the sheetname of table7 is 'E7080-C086-108 ' rather than 'E7080-C086-108'. Macro variable TABLE7 resolves to E7080-C086-108, without the tail blank. So File MULTI.'E7080-C086-108'n.DATA does not exist, however the correct file name is MULTI.'E7080-C086-108 'n.DATA ... View more