Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

SharePoint excel files Vs SharePoint list

Hi All,    I wanted to seek opinions on best pratice for using Sharepoint files.    In my report, I need to use five different Sharepoint files from same SharePoint folder . I feel that it is slo...
Need Help
  • edhans's avatar
    edhans
    5 years ago

    SharePoint Lists are different than Excel. I prefer them for user data entry because you can lock down what the user can enter and they cannot override it accidentally. Even with Data Validatation users can just paste data and override your requirements.

    But if it is something exported out of another system, I'm ok with XLSX (NOT XLS) because it is usually identical every single time - computer programs don't change output much. Even ugly output - once you get the M code right, it just works.

edhans's avatar
edhans
Community Champion
5 years ago

SharePoint Lists are different than Excel. I prefer them for user data entry because you can lock down what the user can enter and they cannot override it accidentally. Even with Data Validatation users can just paste data and override your requirements.

But if it is something exported out of another system, I'm ok with XLSX (NOT XLS) because it is usually identical every single time - computer programs don't change output much. Even ugly output - once you get the M code right, it just works.