{"id":8463,"date":"2014-09-30T10:00:25","date_gmt":"2014-09-30T15:00:25","guid":{"rendered":"http:\/\/www.mrc-productivity.com\/blog\/?p=8463"},"modified":"2014-09-29T15:26:16","modified_gmt":"2014-09-29T20:26:16","slug":"7-dangers-of-spreadsheets-part-1","status":"publish","type":"post","link":"https:\/\/www.mrc-productivity.com\/blog\/2014\/09\/7-dangers-of-spreadsheets-part-1\/","title":{"rendered":"7 dangers of spreadsheet overuse (part 1)"},"content":{"rendered":"

\"Education\"Summary: Described as “the most dangerous software on the planet,” spreadsheet overuse poses many risks to businesses. However, many companies aren’t aware of these risks, or that they’re even misusing spreadsheets in the first place. Learn how misuse occurs, and the dangers it creates. <\/em><\/span>
\n<\/a>
\nIs Excel really the most dangerous software on the planet, as stated in this article<\/span><\/a>? <\/p>\n

For businesses, the answer might be \u201cyes.\u201d<\/p>\n

\"photo<\/a>
photo credit: subflux<\/a> via photopin<\/a> cc<\/a><\/figcaption><\/figure>\n

It\u2019s not that spreadsheets are unsafe. It\u2019s that businesses use them in ways they were never intended. They turn spreadsheets into multi-user, or multi-department tools. They store crucial data on spreadsheets. They run their business off of spreadsheets.<\/p>\n

\u201cSpreadsheets are certainly a powerful tool, but my rule of thumb has always been that any given spreadsheet should not be used by more than a few people over a given period of time,\u201d says Michael Talve, Founder and Managing Director of The Expert Institute<\/span><\/a>. \u201cWhat I’ve seen happen in SMB’s is that spreadsheets will be stretched beyond their useful capability because they are cheap and versatile, and it is easy for a spreadsheet to evolve from a purpose built tool into a bloated mess. If you have multiple people – especially from multiple departments – using the same spreadsheet over an indefinite amount of time, you run the risk of data inconsistency, access issues (only one user can edit a spreadsheet at a time), and other significant problems like file deletion.\u201d<\/p>\n

And that\u2019s just the tip of the iceberg. When businesses overuse spreadsheets, they open themselves up to a world of problems. In fact, this topic is so broad, we’re splitting it up into two articles. While we’ll explore more problems in a future article, today let’s focus on just 7 dangers of spreadsheet overuse.<\/p>\n

1. Spreadsheets make errors easy (but hard to catch)<\/h3>\n

Why are spreadsheets so widely adopted? Because they\u2019re installed on most any computer and are easy to use–even for non-technical users. <\/p>\n

But, this ease of use comes with a price: Making an error in a spreadsheet is also easy. Even worse: They\u2019re hard to detect. Businesses can go weeks or months before recognizing an error. By then, the damage has been done.<\/p>\n

\n\u201cThere have been many high profile stories of Excel errors playing a role in bad decision making including this one last year<\/span><\/a>,\u201d says Judi Otton, CEO and co-founder of GrowthCast<\/span><\/a>. \u201cIt\u2019s really easy to make an error in Excel. I know, I\u2019ve done it. Even if we don\u00b9t make errors big enough to get our names in the papers, we still harm our businesses by operating on invalid data. The trickiest thing about Excel errors is that you may not ever realize they are there.\u201d\n<\/p><\/blockquote>\n

How common are spreadsheet errors? Studies estimate that anywhere from 80 – 90% of spreadsheets contain errors. I\u2019ve seen websites (like this one<\/span><\/a>) dedicated to sharing the problems caused by these errors. <\/p>\n

With errors so common, and the risks so high, do you really want to rely on spreadsheets? I wouldn\u2019t.<\/p>\n

2. Spreadsheets are slow, and prone to crash<\/h3>\n

Spreadsheets cannot scale with your business. As they grow, performance suffers–especially on the more complex spreadsheets. The larger they grow, the slower and more unstable they become.<\/p>\n

\"photo
photo credit: PublicDomainPictures<\/a> via pixabay<\/a> cc<\/a><\/figcaption><\/figure>\n

\u201cSpreadsheets with a lot of data, especially when formulas are being used on that data, can be extremely slow and often crash,\u201d says Alex Juel, Sr. Specialist at Inflow<\/span><\/a>. \u201cOnce you have a spreadsheet that starts to crash, it’s hard to get that data out and in usable form.\u201d<\/p>\n<\/blockquote>\n

Why do they become so unstable as they grow? Because spreadsheets were never meant to handle large amounts of data. They\u2019re not designed to serve as databases–yet many businesses treat them as such. <\/p>\n

3. Spreadsheets cannot be controlled<\/h3>\n

As spreadsheets grow, they spread throughout a company. The more they spread, the harder they are to control. <\/p>\n

After a while, you don\u2019t know how many people have changed the spreadsheet. You don\u2019t know how many places it\u2019s stored. You don\u2019t know how many versions exist, or which one is accurate. You don\u2019t know if someone has made an error.<\/p>\n

\n\u201cHere’s how most people end up with spreadsheets: there is no package software that fits, or not enough budget to build a customized one,\u201d says Berrin Sun, Product Marketer at Ragic, Inc<\/span><\/a>. \u201cBut businesses usually outgrow their spreadsheets much faster than expected. Using spreadsheets gets frustrating after you have more than a handful of co-workers or dozens of interrelated spreadsheet files.<\/p>\n

This means that you have no way of controlling access, or keeping track of who edited what, so when there is a mistake, you have no way of tracing it back. When you look at a piece of data, you cannot be 100% sure that it would be correct, and when someone asks for a piece of data, you know you couldn’t find it in time. These spreadsheets also tend to load very slow with their massive filesize even on good computers, and business people have a hard time figuring out why.\u201d\n<\/p><\/blockquote>\n

4. Spreadsheets are easily corrupted<\/h3>\n

\n\u201cSpreadsheets get corrupted,\u201d says Juel. \u201cI have clients that are many years old and I still use spreadsheets that were created for them 5+ years ago. I’ve had spreadsheets just randomly become corrupted and I can’t access the data. I use Dropbox and Google Drive now, which helps because I can usually back up from older versions.\u201d\n<\/p><\/blockquote>\n

\"photo
photo credit: Kasman<\/a> via pixabay<\/a> cc<\/a><\/figcaption><\/figure>\n

It\u2019s happened to many an Excel user. Yesterday, the spreadsheet worked fine. Today, it\u2019s corrupted. Why does this happen so often?<\/p>\n

There\u2019s no single reason, but it usually happens as the spreadsheet grows. As more changes occur and more data gets added, spreadsheets become unstable. The more unstable they become, the greater your chances are for data loss. <\/p>\n

5. Spreadsheets (built by others) are hard to understand<\/h3>\n

When businesses use spreadsheets as multi-user tools, they run into another problem: There is no set design template. One user\u2019s idea of a well-formatted spreadsheet may be confusing and unreadable to other employees.<\/p>\n

\n\u201cSpreadsheets can be hard to understand,\u201d explains Juel. \u201cEveryone seems to have their own method of formatting spreadsheets and they’re the only ones who understand what the spreadsheet is saying. I get spreadsheets all the time from clients who have formatted their spreadsheets with all sorts of colors and data branches and I have a hell of time trying to figure it out.\u201d\n<\/p><\/blockquote>\n

These different designs can become more than just a minor nuisance. It can lead to confusion or even users misunderstanding data…which in turn can lead to costly mistakes.<\/p>\n

6. Spreadsheets are a productivity drain<\/h3>\n

\n\u201cOveruse of spreadsheets can also have a productivity cost for business,\u201d says Shelly Collins, Professional Organizer at Clutter Contained<\/span><\/a>. \u201cOnce a spreadsheet is created, it seems to take on a life of it’s own. It’s something that must be updated and maintained, even if the information it provides is not useful or if that information is being duplicated elsewhere. Businesses are spending time compiling data into spreadsheets, but far too often it goes unused after it has been collected.\u201d\n<\/p><\/blockquote>\n

How much time do you (or other employees in your company) waste on spreadsheets? How much time do they spend creating, updating, and maintaining spreadsheets? The answer may surprise you. <\/p>\n

I\u2019ve seen companies where some employees spend half of their time on spreadsheets. Some budgeting and reporting processes require a few days of spreadsheet work every month. Spreadsheets are a productivity drain that exist in far too many businesses.<\/p>\n

7. Spreadsheets make data analysis difficult<\/h3>\n

\"MultiWhen used across multiple departments, different spreadsheets might hold related data. For instance, different spreadsheets might hold different information about the same customer. One might hold sales data. Another might hold billing data. Another might hold completely different data on the same customer.<\/p>\n

What happens when you need to analyze that data? What happens when you need to create a report across various data points? What happens if you need to link related data across different spreadsheets? <\/p>\n

\n“There is no way to link data on spreadsheets,\u201d says Graham Cleven, Spreadsheet Expert. \u201cSpreadsheets simply report data, they do not show the link between data which is just as important as the data itself. For example in a consumer spreadsheet you will have a list of your customers and their personal information and perhaps an ID for each customer. Then in another spreadsheet that handles transactions you would have the transaction data with the customer ID on it. As two separate spreadsheets there is no logical way to link those two sets of data together.\u201d\n<\/p><\/blockquote>\n

So, what do you think? Is there anything you would add to this list? If so, please share your thoughts in the comments.<\/p>\n","protected":false},"excerpt":{"rendered":"

Summary: Described as “the most dangerous software on the planet,” spreadsheet overuse poses many risks to businesses. However, many companies aren’t aware of these risks, or that they’re even misusing spreadsheets in the first place. Learn how misuse occurs, and the dangers it creates.<\/p>\n","protected":false},"author":4,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"default","ast-global-header-display":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","slim_seo":{"title":"7 dangers of spreadsheet overuse (part 1) - mrc's Cup of Joe Blog","description":"Summary: Described as \"the most dangerous software on the planet,\" spreadsheet overuse poses many risks to businesses. However, many companies aren't aware of t"},"footnotes":""},"categories":[8],"tags":[44],"class_list":["post-8463","post","type-post","status-publish","format-standard","hentry","category-education","tag-spreadsheets"],"_links":{"self":[{"href":"https:\/\/www.mrc-productivity.com\/blog\/wp-json\/wp\/v2\/posts\/8463","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.mrc-productivity.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.mrc-productivity.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.mrc-productivity.com\/blog\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/www.mrc-productivity.com\/blog\/wp-json\/wp\/v2\/comments?post=8463"}],"version-history":[{"count":7,"href":"https:\/\/www.mrc-productivity.com\/blog\/wp-json\/wp\/v2\/posts\/8463\/revisions"}],"predecessor-version":[{"id":8487,"href":"https:\/\/www.mrc-productivity.com\/blog\/wp-json\/wp\/v2\/posts\/8463\/revisions\/8487"}],"wp:attachment":[{"href":"https:\/\/www.mrc-productivity.com\/blog\/wp-json\/wp\/v2\/media?parent=8463"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.mrc-productivity.com\/blog\/wp-json\/wp\/v2\/categories?post=8463"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.mrc-productivity.com\/blog\/wp-json\/wp\/v2\/tags?post=8463"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}