Hello,

I have several users who are trying to use excel as a database. Average file size is between 20MB-200MB. I’ve already tried explaining to them that excel isn’t supposed to be used this way, but of course they keep using it that way.

And of course users won’t go out of their way to learn something else, so now it’s my job to figure out a solution. Have you ever encountered this in the workplace? What’s my best option to resolve this? Do I need to look at power bi, tableau, etc?

Users have a year worth of data in excel that they use to find discrepancies, or they use pivot tables in excel to show other members of the company data - like financials / spending etc.

I’m trying to look for the best solution, but I’m not trying to go down a rabbit hole.

I basically have to learn their job and what they do, then go out and learn what software will work with their workflow.

Any recommendations?

Edit: for those of you who don’t know, excel absolutely runs like garbage with files over 20MB