Error “the selected range cannot be converted to a table..” When Import from Spreadsheet
I got This Error :
When Creating List from Spreadsheet. Then after sometimes of trying, I’ve found out that Error won’t happened when I removed the Formula. The trick to remove formula in Excell is just copy and paste to other sheet with option Values when pasting (as seen below), then use that pasted sheet for importing.