SharePoint Lists vs. Excel Tables
Simply put, and contrary to popular belief, Excel is not designed
for storing tables of data!
Excel is a spreadsheeting tool, intended for data analysis.
Do you know what IS designed for storing tables of data?
Databases.
And SharePoint lists! Which are essentially database tables
anyway.
