Error: File X.Sheet.DATA does not exist

[jerrylshen]

I've done a Google search of this error and it seems none of the results were applicable.   

Both the Excel file and the SAS code programs are in the same folder.

The multisheet-Excel file has a sheet named "Dictionary"

LIBNAME XLSLIB xlsx "K:\Folder1\Folder2\FileName.xlsx";

data dict;
    set XLSLIB.Dictionary;
    /*ERROR: File XLSLIB.Dictionary.DATA does not exist.*/ ...
run;   

I've also tried this, but it also has the same error:

data XLSLIB.Dictionary;
    set XLSLIB.Dictionary;

 https://blogs.sas.com/content/sasdummy/2015/05/20/using-libname-xlsx-to-read-and-write-excel-files/

It should just read and not overwrite anything.

Thanks

[ChrisNZ]

What tables do you see when you open the XLSLIB  library?