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 slowing down the report and throwing strange error message . 

 

Please suggets what is the best practice. In cases where more than one SharePoint file needs to be used, is using sharePoint list better than using excels  ?

 

Thanks.

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.

2 Replies

  • 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.