Hi @PsychLeague,
This typically happens when there is a rogue cell somewhere to the right or bottom right. A single cell with a space character would suffice to throw this error.
Here are two things you can do to fix this:
- Copy just the cell range that contains data to a new file. For example, you have data in A1:E100, copy just that range, paste it in a new file, import the new file. Any cells floating around would automatically be excluded by doing this.
- Mark all columns to the right of your data and delete their content, even if they look empty, e.g. with data in A1:E100, mark columns F through Z and hit delete.
Hope this helps!