Spreadsheet used as a database/application.

One department in our company still maintain their customer records and contacts in a spreadsheet document. They do lots of analysis and reporting on the data for their service. The data is also used for other purposes. There are numerous proper applications on the market which also offer the same functionality for their line of business but they seem adamant in keeping their trusty spreadsheet as their main 'system'. Can there be any risks limitations or shortfalls in using a spreadsheet almost as a proper system/database just so we can make them aware and consider they review whether a spreadsheet is the right tool for recording their data. It sounds an odd approach but need to ensure we have identifed the problems in their solution, if indeed there are any.
LVL 4
pma111Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Geert GOracle dbaCommented:
moving the file to some place different "by accident", grab a bag of chips, sit back and then see all hell breaks loose

should be easy to convince them to have backups, or a better system, etc after that
0
Aaron TomoskySD-WAN SimplifiedCommented:
recoverability. Assuming it's on a server fileshare with the appropriate permissions, script copy/version that thing often.
0
pma111Author Commented:
Single use was one we'd thought of e.g. cannot be updated by multiple officers at a given time.
0
10 Tips to Protect Your Business from Ransomware

Did you know that ransomware is the most widespread, destructive malware in the world today? It accounts for 39% of all security breaches, with ransomware gangsters projected to make $11.5B in profits from online extortion by 2019.

Aaron TomoskySD-WAN SimplifiedCommented:
If it's in share point online (ms teams), multiple users works fine and it versions.
0
pma111Author Commented:
Its just on a traditional windows file server
0
Fabrice LambertFabrice LambertCommented:
Hi,

Spreadsheets can't ensure that data type remain correct, neither ensure data integrity, nor data constraints or default values.
They can't handle triggers either.

Plus, if reading spreadhseets trough SQL work fine, adding, deleting, updating rows can be a nightmare.
0
Serena HsiMarketing ConsultantCommented:
There are some lower cost CRM systems out there like ZohoCRM. And if you're a nonprofit, there's Salesforce for NonProfits.
0
Rob HensonFinance AnalystCommented:
Audit trail of changes, what changed and by whom.

Once a change is made and saved the original data is lost other than resorting to recovery from a backup.

@Fabrice -
Spreadsheets can't ensure that data type remain correct, neither ensure data integrity, nor data constraints or default values.
Data Validation can overcome maintaining data type, formula/VBA based checks can check for integrity.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Software

From novice to tech pro — start learning today.