The most common problems people encounter when importing data using an Excel file involve a missing <Named Range> or an incorrectly defined <Named Range> resulting in either too few or too many rows being imported into Excel.
This video shows how to create an Excel <Named Range> and how to avoid common pitfalls related to blank contacts or incorrectly defining what should be imported.
Related Posts:
Excel rows – “Clear Contents” vs “Delete”