An elephant inside a business meeting room.

5 ways your addiction to spreadsheets increases risk in your business

13 Jul 2020

Barry Fisher - Technical Director

Written by
Barry Fisher
Technical Director

Spreadsheets are a wonderful tool when used correctly. But when they're not, they can expose your business to significant, unnecessary risk, putting one of your business' most valuable assets – data – in harm's way.

There can be little argument that spreadsheets are a powerful tool for managing a business. In the main, they are relatively simple to use and, with a little know-how, can be made to fit almost any scenario.

On the surface, they are the perfect, one-size-fits-all solution to any business information management challenge you may be facing.

You can:

  • Sort, index and organise.
  • Create charts, graphs, and tables.
  • Automate and analyse.

Yet, for many businesses, the power of the humble spreadsheet is underappreciated – as is the damage that can be visited on your business when they go wrong.

So many businesses have recently made a rapid shift to homeworking, that it feels like the perfect time to remind ourselves of the inherent problems you are inviting in when you rely too heavily on spreadsheets.

Complexity

Sadly, the power and versatility of the humble spreadsheet can become its greatest weakness.

Was it originally intended to be a complex workbook full of formulae?

Or did it just develop into that over time?

The greater the complexity, the higher the risk of failure.

All too often, businesses are heavily reliant on the one 'Excel* whizz' who speaks fluent Excel* and can create complicated formulae and automation with their eyes shut. They may even 'lock' certain parts of a spreadsheet to protect it from accidental harm.

What happens when that person leaves your business or is simply not at work on the day something goes wrong?

*other spreadsheet software is available

Confidence

This could be the confidence of your users, or confidence in the program.

Spreadsheets can be unstable. Formulae can be fragile. Data validation can be tricky.

What if your spreadsheet contains a minor error that completely distorts the business information you subsequently rely on?

While many people possess a basic to intermediate working knowledge of spreadsheets, few are highly skilled in the deeper workings of the software. The risk of an employee accidentally overwriting a formula, or doing something to break interdependencies is high, and the potential damage, significant.

Control

Whoever holds control of the spreadsheet, holds control of your business!

Version control is an age-old problem.

How many times over the years have you seen versions labelled 0.1, 0.1a, Draft final, FINALfinal… You get the idea and that's just on the shared drive!

Imagine how many 'personal' versions your staff might have on their desktop, laptop or memory stick. When any of those versions are then shared by email the duplication escalates.

Clarity

Being limited to rows and columns, spreadsheets are only good for 2D data sets. What happens when you need to overlay more data sets?

How do you obtain a reliable and comprehensive helicopter view of your business information?

How do you identify trends?

Compliance

Last but not least, compliance.

Implementing robust security and compliance arrangements costs money, time and energy. You are required to satisfy complex legal obligations that carry severe, potentially catastrophic, financial penalties if you fail. Your clients choose their partners and suppliers based on their confidence in your ability to provide security.

Despite this how often do you send, or receive, emails with attachments?

The problem with this is that once the email is sent it effectively becomes public information. Whether it is then deliberately intercepted, or accidentally ends up with the wrong person, your standard email disclaimer won't protect you from the risk of non-compliance!

Aspire to go further

The good news is, there is another way.

Aspire: Custom Software : build the application that is right for you. Meet the requirements of today and tomorrow.

Aspire: Custom Software provides the bespoke solution making it easy and intuitive to access, analyse, update and extract different types of data. As a result, you derive clear business insights allowing you to make decisions confidently.

Aspire: Custom Software makes life so simple your staff won't need to find a workaround!

You can see how Aspire: Custom Software helped M&S overcome their spreadsheet addiction or get in touch today if you want to start your spreadsheet addiction rehab.

Barry Fisher - Director

Get in touch about your project

Give us a call or send us an email to talk through your project

telephone+44 (0) 203 743 0887

emailbarry.fisher@pivale.co

Related articles

Coloured pencils artfully placed together to forma a spiral.

Flat design is going gaga!

Calendar 29 Oct 2014 #Insights #User experience Flat design. What is it? Where did it come from? Will it go away? What do I need to know? All is revealed in this end-to-end opinion piece.

Read the article
An ambiguous figure in a suit throwing dice towards he camera.

Are you gambling with the security of your business?

Calendar 7 Jun 2022 #Security & compliance Ignoring security updates will seriously impact your business. It's time to take action.

Read the article
A square peg smashed in to a round hole with a hammer.

Could mismatched web solutions scupper your business growth?

Calendar 5 Aug 2020 #Insights #Advice If you're responsible for the IT or strategic marketing in a medium or large business, ask yourself 'How is your web portfolio looking?'

Read the article

More recent articles

Bundles of Euro bank notes overlaid by handcuffs and a sinister sillouetted character on the left.

Google Analytics: Is it legal?

Calendar 24 Nov 2022 #Insights #Advice #Security & compliance Promise: not clickbait! It's hard to believe that this popular product could be considered illegal.

Read the article
A girl grimacing in disgust.

What to consider when you're thinking about your webforms

Calendar 3 Nov 2022 #Insights #Advice Webforms are a great way to consolidate interest and turn your visitors into potential new customers. But we bet you hadn't considered the power, positive and negative, that a webform can have on your potential new customer's experience of your business.

Read the article
The ruins of a building in the middle of a field.

6 reasons not to use a standalone microsite for your Christmas marketing campaign

Calendar 27 Oct 2022 #Insights #Advice #Security & compliance #SEO We've compiled a list of the six reasons businesses shouldn't entertain the thought of a microsite - and they're pretty compelling.

Read the article

Subscribe for email updates

1 Your details

2 Your interests

Please select which Pivale services are of interest to you:

3 Legal info

By subscribing, you acknowledge that your information will be transferred to our marketing platform for processing.

You can unsubscribe at any time by clicking the link in the footer of our emails. You can find out more in our privacy policy.