{"id":7605,"date":"2021-03-16T14:00:00","date_gmt":"2021-03-16T13:00:00","guid":{"rendered":"https:\/\/beebole.com\/blog\/?p=7605"},"modified":"2026-08-10T12:45:56","modified_gmt":"2026-08-10T10:45:56","slug":"excel-formulas-not-working-fixing-workbooks","status":"publish","type":"post","link":"https:\/\/beebole.com\/blog\/excel-formulas-not-working-fixing-workbooks","title":{"rendered":"Excel formulas not working: 5 critical examples of checking &#038; fixing workbooks"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">When it comes to <a href=\"https:\/\/beebole.com\/blog\/excel-power-query-for-business-intelligence\/\">working with data in Microsoft Excel<\/a>, especially if it wasn\u2019t your data to begin with, things can get tricky quickly. Between <strong>Excel formulas not working<\/strong>, human error, and simply trying to understand someone else\u2019s thought process, there are a lot of ways checking and fixing an Excel workbook can go wrong. That\u2019s where this post comes in. Written by Excel MVP, creator of the YouTube channel Excel on Fire, trainer, LinkedIn instructor, and co-host of ExcelTV, <a href=\"https:\/\/ozdusoleil.com\/#about-me\" target=\"_blank\" rel=\"noopener\">Oz du Soleil<\/a>, <strong>this article dives into five critical examples of checking and fixing an Excel workbook<\/strong>, a situation managers\u2014however reluctantly\u2014might find themselves in.\u00a0<\/p>\n\n\n\n<p class=\"has-text-align-center wp-block-paragraph\"><em>&#8211;<br>This article is just one of the <a href=\"https:\/\/beebole.com\/blog\/category\/learn-tutorials-howtos\/\">tutorials<\/a> on our blog. We often ask spreadsheet experts to share their top tips for managers, creating actionable tutorials that professionals can start putting into practice today.<br>&#8211;<\/em><\/p>\n\n\n<div  class=\"position-relative bbl-summarize-w-ai-block\">\n    <div class=\"bbl-swa-inner \">\n        <div class=\"bbl-swa-inner-top\">\n                            <div class=\"bbl-swa-title\">\n                    TL;DR: What you&#8217;ll learn                <\/div>\n            \n                            <div class=\"bbl-swa-quote montserrat-font\">\n                    <p class=\"font-claude-response-body break-words whitespace-normal\" dir=\"ltr\">If you&#8217;re managing a spreadsheet someone else built, there are a few quick checks that can tell you whether the numbers (and the habits behind them) are trustworthy before you sign off on them.<\/p>\n<p class=\"font-claude-response-body break-words whitespace-normal\" dir=\"ltr\">Here&#8217;s what this article covers:<\/p>\n<ul class=\"[li_&amp;]:mb-0 [li_&amp;]:mt-1 [li_&amp;]:gap-1 [&amp;:not(:last-child)_ul]:pb-1 [&amp;:not(:last-child)_ol]:pb-1 list-disc flex flex-col gap-1 pl-8 mb-3 print:block print:space-y-1\" dir=\"ltr\">\n<li class=\"font-claude-response-body whitespace-normal break-words pl-2\"><strong>Why hard-coded numbers are a red flag<\/strong>: Typed-in values invite typos and go stale the moment the underlying data changes, while formulas update automatically<\/li>\n<li class=\"font-claude-response-body whitespace-normal break-words pl-2\"><strong>How Excel Tables keep data honest<\/strong>: Tables auto-expand to include new rows, so formulas don&#8217;t silently leave fresh data out of a calculation<\/li>\n<li class=\"font-claude-response-body whitespace-normal break-words pl-2\"><strong>What crossfooting is and why it catches errors<\/strong>: Calculating the same total two different ways is a fast way to tell if a summary actually adds up<\/li>\n<li class=\"font-claude-response-body whitespace-normal break-words pl-2\"><strong>Where hidden sheets hide problems<\/strong>: Right-clicking a tab to unhide sheets can surface formulas, notes, or adjustments nobody mentioned<\/li>\n<li class=\"font-claude-response-body whitespace-normal break-words pl-2\"><strong>How to reveal every formula on a sheet<\/strong>: One shortcut (Ctrl+`) shows exactly what&#8217;s driving each number, so you don&#8217;t have to take it on faith<\/li>\n<\/ul>\n                <\/div>\n                    <\/div>\n\n        <div class=\"bbl-swa-actions d-flex justify-content-between\">\n                                                <div\n                        class=\"bbl-swa-actions-label montserrat-font bbl-wider-label\"\n                    >Stress-test your next spreadsheet:<\/div>\n                            \n            <div class=\"bbl-swa-logos-outer d-flex\">\n                                <div class=\"bbl-swa-logos\">\n                                            <a class=\"bbl-summarize-w-chatgpt\" href=\"https:\/\/chat.openai.com\/?q=Please%20read%20the%20article%20at%20https:\/\/beebole.com\/blog\/excel-formulas-not-working-fixing-workbooks.%20Based%20on%20the%20information%20in%20this%20article,%20turn%20its%20five%20checks%20into%20a%20fast%20audit%20routine%20I%20can%20run%20the%20next%20time%20I%20inherit%20someone%20else&#039;s%20spreadsheet%20\u2014%20rank%20the%20checks%20by%20how%20much%20risk%20each%20one%20catches%20versus%20how%20long%20it%20takes,%20and%20flag%20which%20of%20the%20five%20problems%20could%20have%20been%20avoided%20entirely%20if%20the%20underlying%20numbers%20had%20come%20from%20an%20automated%20source%20instead%20of%20manual%20entry.%20Stick%20to%20only%20what%20this%20article%20says%20\u2014%20no%20outside%20information%20or%20generic%20knowledge.\" rel=\"nofollow noopener noreferrer\" target=\"_blank\">\n            <svg width=\"28\" height=\"26\" viewBox=\"0 0 28 26\" fill=\"none\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\">\n                <mask id=\"mask0_1578_5676\" style=\"mask-type:luminance\" maskUnits=\"userSpaceOnUse\" x=\"0\" y=\"0\" width=\"28\" height=\"26\">\n                    <path d=\"M27.1171 0H0.882935V26H27.1171V0Z\" fill=\"white\"\/>\n                <\/mask>\n                <g mask=\"url(#mask0_1578_5676)\">\n                    <path d=\"M10.9449 9.46396V6.99394C10.9449 6.78592 11.023 6.62986 11.2049 6.52598L16.171 3.66598C16.847 3.276 17.6531 3.09409 18.4849 3.09409C21.6049 3.09409 23.581 5.51214 23.581 8.08603C23.581 8.26799 23.581 8.47602 23.555 8.68404L18.4069 5.66798C18.095 5.48608 17.7828 5.48608 17.4709 5.66798L10.9449 9.46396ZM22.5409 19.084V13.1819C22.5409 12.8178 22.3848 12.5578 22.0729 12.3759L15.5469 8.57989L17.6789 7.35781C17.8609 7.25393 18.0169 7.25393 18.1989 7.35781L23.165 10.2178C24.5951 11.0499 25.557 12.8178 25.557 14.5337C25.557 16.5097 24.3871 18.3297 22.5409 19.0838V19.084ZM9.41092 13.8841L7.27892 12.6361C7.09702 12.5323 7.01893 12.3761 7.01893 12.1681V6.44817C7.01893 3.66625 9.15093 1.5601 12.037 1.5601C13.1291 1.5601 14.1429 1.92419 15.0011 2.57416L9.87915 5.53826C9.56725 5.72016 9.41119 5.98015 9.41119 6.34429V13.8843L9.41092 13.8841ZM14 16.536L10.9449 14.82V11.1802L14 9.46423L17.0548 11.1802V14.82L14 16.536ZM15.963 24.4401C14.8709 24.4401 13.8571 24.076 12.9989 23.4261L18.1208 20.462C18.4328 20.2801 18.5888 20.0201 18.5888 19.6559V12.1159L20.7469 13.3639C20.9288 13.4677 21.0069 13.6238 21.0069 13.8319V19.5518C21.0069 22.3337 18.8488 24.4399 15.963 24.4399V24.4401ZM9.8009 18.6421L4.83475 15.7822C3.40464 14.95 2.44277 13.1822 2.44277 11.4662C2.44277 9.46423 3.63879 7.67025 5.48467 6.91618V12.8442C5.48467 13.2082 5.64079 13.4682 5.95269 13.6502L12.4528 17.4201L10.3208 18.6421C10.1389 18.746 9.98281 18.746 9.8009 18.6421ZM9.51507 22.9061C6.57704 22.9061 4.41898 20.6961 4.41898 17.9661C4.41898 17.7581 4.44504 17.55 4.47089 17.342L9.59288 20.3061C9.90478 20.4881 10.217 20.4881 10.5289 20.3061L17.0548 16.5363V19.0063C17.0548 19.2143 16.9768 19.3704 16.7948 19.4742L11.8288 22.3342C11.1527 22.7242 10.3467 22.9061 9.51479 22.9061H9.51507ZM15.963 26C19.109 26 21.7349 23.7641 22.3331 20.8C25.2451 20.0459 27.1171 17.3159 27.1171 14.534C27.1171 12.7139 26.3372 10.946 24.9331 9.67198C25.0631 9.12594 25.1411 8.57989 25.1411 8.03412C25.1411 4.31617 22.1251 1.53399 18.641 1.53399C17.9392 1.53399 17.2631 1.63786 16.5871 1.87201C15.4169 0.727951 13.8049 0 12.037 0C8.89099 0 6.26513 2.23587 5.66691 5.19997C2.75494 5.95404 0.882935 8.68404 0.882935 11.466C0.882935 13.2861 1.66285 15.0539 3.0669 16.328C2.9369 16.874 2.85887 17.4201 2.85887 17.9659C2.85887 21.6838 5.87493 24.466 9.35895 24.466C10.0608 24.466 10.7369 24.3621 11.4129 24.1279C12.5828 25.272 14.1948 26 15.963 26Z\" fill=\"#313358\"\/>\n                <\/g>\n            <\/svg>\n        <\/a>\n                                                                    <a class=\"bbl-summarize-w-perplexity\" href=\"https:\/\/www.perplexity.ai\/search\/new?q=Please%20read%20the%20article%20at%20https:\/\/beebole.com\/blog\/excel-formulas-not-working-fixing-workbooks.%20Based%20on%20the%20information%20in%20this%20article,%20turn%20its%20five%20checks%20into%20a%20fast%20audit%20routine%20I%20can%20run%20the%20next%20time%20I%20inherit%20someone%20else&#039;s%20spreadsheet%20\u2014%20rank%20the%20checks%20by%20how%20much%20risk%20each%20one%20catches%20versus%20how%20long%20it%20takes,%20and%20flag%20which%20of%20the%20five%20problems%20could%20have%20been%20avoided%20entirely%20if%20the%20underlying%20numbers%20had%20come%20from%20an%20automated%20source%20instead%20of%20manual%20entry.%20Stick%20to%20only%20what%20this%20article%20says%20\u2014%20no%20outside%20information%20or%20generic%20knowledge.\" rel=\"nofollow noopener noreferrer\" target=\"_blank\">\n            <svg width=\"24\" height=\"26\" viewBox=\"0 0 24 26\" fill=\"none\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\">\n                <path d=\"M3.93943 0.132141L11.2677 6.8839V0.147583H12.6947V6.91478L20.0551 0.132141V7.83097H23.0778V18.9346H20.0641V25.7893L12.6947 19.3142V25.864H11.2664V19.421L3.94844 25.8678V18.9346H0.925781V7.82968H3.93943V0.132141ZM10.1932 9.24H2.35025V17.5256H3.94586V14.9121L10.1932 9.24ZM5.37419 15.5375V22.7242L11.2677 17.5333V10.1819L5.37419 15.5375ZM12.7346 17.4638L18.6384 22.6496V18.9346H18.6306V15.5298L12.7346 10.1768V17.4638ZM20.0641 17.5256H21.652V9.23871H13.8708L20.0654 14.8529L20.0641 17.5256ZM18.6294 7.83097V3.37355L13.791 7.83097H18.6294ZM10.2035 7.83097L5.36519 3.37355V7.83097H10.2035Z\" fill=\"#262C54\"\/>\n            <\/svg>\n        <\/a>\n                                                                    <a class=\"bbl-summarize-w-gemini\" href=\"https:\/\/www.google.com\/search?aep=11&#038;udm=50&#038;q=Please%20read%20the%20article%20at%20https:\/\/beebole.com\/blog\/excel-formulas-not-working-fixing-workbooks.%20Based%20on%20the%20information%20in%20this%20article,%20turn%20its%20five%20checks%20into%20a%20fast%20audit%20routine%20I%20can%20run%20the%20next%20time%20I%20inherit%20someone%20else&#039;s%20spreadsheet%20\u2014%20rank%20the%20checks%20by%20how%20much%20risk%20each%20one%20catches%20versus%20how%20long%20it%20takes,%20and%20flag%20which%20of%20the%20five%20problems%20could%20have%20been%20avoided%20entirely%20if%20the%20underlying%20numbers%20had%20come%20from%20an%20automated%20source%20instead%20of%20manual%20entry.%20Stick%20to%20only%20what%20this%20article%20says%20\u2014%20no%20outside%20information%20or%20generic%20knowledge.\" rel=\"nofollow noopener noreferrer\" target=\"_blank\">\n            <svg width=\"29\" height=\"29\" viewBox=\"0 0 29 29\" fill=\"none\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\">\n                <path d=\"M28.8828 14.4703C21.1362 14.9372 14.9348 21.1362 14.4691 28.8828H14.4125C13.9456 21.1362 7.74541 14.9372 0 14.4703V14.4137C7.74661 13.9456 13.9456 7.74661 14.4125 0H14.4691C14.936 7.74661 21.1362 13.9456 28.8828 14.4137V14.4703Z\" fill=\"#262C54\"\/>\n            <\/svg>\n        <\/a>\n                                                                    <a class=\"bbl-summarize-w-grok\" href=\"https:\/\/x.com\/i\/grok?q=Please%20read%20the%20article%20at%20https:\/\/beebole.com\/blog\/excel-formulas-not-working-fixing-workbooks.%20Based%20on%20the%20information%20in%20this%20article,%20turn%20its%20five%20checks%20into%20a%20fast%20audit%20routine%20I%20can%20run%20the%20next%20time%20I%20inherit%20someone%20else&#039;s%20spreadsheet%20\u2014%20rank%20the%20checks%20by%20how%20much%20risk%20each%20one%20catches%20versus%20how%20long%20it%20takes,%20and%20flag%20which%20of%20the%20five%20problems%20could%20have%20been%20avoided%20entirely%20if%20the%20underlying%20numbers%20had%20come%20from%20an%20automated%20source%20instead%20of%20manual%20entry.%20Stick%20to%20only%20what%20this%20article%20says%20\u2014%20no%20outside%20information%20or%20generic%20knowledge.\" rel=\"nofollow noopener noreferrer\" target=\"_blank\">\n            <svg width=\"32\" height=\"32\" viewBox=\"0 0 32 32\" fill=\"none\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\">\n                <path d=\"M12.3998 19.784L21.6343 12.9589C22.0871 12.6243 22.7342 12.7548 22.9499 13.2745C24.0853 16.0155 23.578 19.3094 21.3191 21.571C19.0603 23.8325 15.9173 24.3285 13.0445 23.1989L9.90625 24.6536C14.4074 27.7339 19.8733 26.9721 23.2888 23.5501C25.9981 20.8376 26.8372 17.1403 26.0526 13.8061L26.0597 13.8132C24.9219 8.91511 26.3394 6.9573 29.243 2.95385C29.3117 2.85892 29.3804 2.764 29.4492 2.6667L25.6283 6.49216V6.4803L12.3974 19.7864\" fill=\"#262C54\"\/>\n                <path d=\"M10.4902 21.4428C7.25946 18.3529 7.81648 13.5711 10.5731 10.8136C12.6115 8.77269 15.9513 7.93973 18.8667 9.16426L21.9979 7.71666C21.4338 7.30848 20.7108 6.86946 19.8812 6.56095C16.1314 5.01605 11.6421 5.78494 8.59393 8.83439C5.6619 11.7699 4.73985 16.2836 6.3232 20.1352C7.50597 23.0138 5.56708 25.0498 3.61397 27.105C2.92184 27.8335 2.22735 28.5621 1.66797 29.3333L10.4878 21.4451\" fill=\"#262C54\"\/>\n            <\/svg>\n        <\/a>\n                                                                    <a class=\"bbl-summarize-w-claude\" href=\"https:\/\/claude.ai\/new?q=Please%20read%20the%20article%20at%20https:\/\/beebole.com\/blog\/excel-formulas-not-working-fixing-workbooks.%20Based%20on%20the%20information%20in%20this%20article,%20turn%20its%20five%20checks%20into%20a%20fast%20audit%20routine%20I%20can%20run%20the%20next%20time%20I%20inherit%20someone%20else&#039;s%20spreadsheet%20\u2014%20rank%20the%20checks%20by%20how%20much%20risk%20each%20one%20catches%20versus%20how%20long%20it%20takes,%20and%20flag%20which%20of%20the%20five%20problems%20could%20have%20been%20avoided%20entirely%20if%20the%20underlying%20numbers%20had%20come%20from%20an%20automated%20source%20instead%20of%20manual%20entry.%20Stick%20to%20only%20what%20this%20article%20says%20\u2014%20no%20outside%20information%20or%20generic%20knowledge.\" rel=\"nofollow noopener noreferrer\" target=\"_blank\">\n            <svg width=\"32\" height=\"32\" viewBox=\"0 0 32 32\" fill=\"none\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\">\n                <path d=\"M7.66688 21.2213L13.3509 18.0321L13.4465 17.7551L13.3509 17.601H13.074L12.124 17.5425L8.87626 17.4547L6.05958 17.3376L3.33068 17.1913L2.64407 17.045L2.00037 16.1965L2.06669 15.7733L2.64407 15.3851L3.47112 15.4573L5.29884 15.5821L8.0414 15.7713L10.031 15.8883L12.9784 16.1946H13.4465L13.5128 16.0054L13.3529 15.8883L13.2281 15.7713L10.3899 13.848L7.31772 11.8155L5.70847 10.6451L4.8385 10.0521L4.39961 9.4962L4.2104 8.28292L5.0004 7.41295L6.06153 7.48512L6.33266 7.5573L7.40745 8.38435L9.70331 10.1614L12.7014 12.3694L13.1403 12.7342L13.3158 12.6094L13.3373 12.5216L13.1403 12.1919L11.5096 9.24457L9.76963 6.24649L8.99524 5.00395L8.79043 4.25882C8.71826 3.95257 8.66559 3.69509 8.66559 3.38105L9.56482 2.15997L10.0622 2.00002L11.2618 2.15997L11.7671 2.59885L12.5122 4.30368L13.7196 6.98772L15.5922 10.6373L16.1403 11.7199L16.4329 12.7225L16.5421 13.0287H16.7313V12.8532L16.8854 10.7973L17.1702 8.27317L17.4472 5.02541L17.5428 4.11057L17.9953 3.01433L18.8946 2.42135L19.5968 2.75685L20.1742 3.58391L20.0942 4.11837L19.7509 6.34987L19.0779 9.84536L18.639 12.1861H18.8946L19.1872 11.8935L20.3712 10.3213L22.3608 7.83428L23.2386 6.84728L24.2626 5.75688L24.92 5.23802H26.1625L27.0774 6.5976L26.6677 8.00203L25.3881 9.62494L24.327 11.0001L22.8055 13.0483L21.8556 14.6868L21.9434 14.8175L22.1696 14.796L25.6066 14.0645L27.4636 13.729L29.6795 13.3486L30.6821 13.8168L30.7913 14.2927L30.3973 15.2661L28.0273 15.8513L25.2477 16.4072L21.1085 17.3864L21.0578 17.4235L21.1163 17.4956L22.9811 17.6712L23.7789 17.7141H25.7315L29.3674 17.9852L30.3173 18.6133L30.8869 19.3819L30.7913 19.9671L29.3284 20.7122L27.3544 20.244L22.747 19.1478L21.167 18.7538H20.9486V18.8845L22.2652 20.1719L24.6781 22.3507L27.6996 25.1596L27.8537 25.854L27.4655 26.4021L27.0559 26.3436L24.4011 24.3462L23.3771 23.4469L21.0578 21.4944H20.9037V21.6992L21.4382 22.4814L24.2607 26.724L24.407 28.025L24.2022 28.4483L23.4707 28.7038L22.667 28.5575L21.0149 26.2383L19.3101 23.6264L17.9349 21.2857L17.7671 21.3813L16.9557 30.1219L16.5753 30.5686L15.6975 30.9041L14.9661 30.3482L14.5779 29.449L14.9661 27.672L15.4342 25.3527L15.8146 23.5094L16.1579 21.2193L16.3627 20.4586L16.349 20.4079L16.1813 20.4294L14.455 22.7993L11.8295 26.3475L9.75208 28.5712L9.25467 28.7682L8.39251 28.3215L8.47248 27.5237L8.95428 26.8137L11.8295 23.1563L13.5636 20.8897L14.6832 19.5808L14.6754 19.3916H14.6091L6.97246 24.3501L5.61289 24.5256L5.02771 23.9775L5.09988 23.0783L5.37687 22.7857L7.67273 21.2057L7.66493 21.2135L7.66688 21.2213Z\" fill=\"#262C54\"\/>\n            <\/svg>\n        <\/a>\n                                                            <\/div>\n            <\/div>\n        <\/div>\n    <\/div>\n<\/div>\n\n\n<h2 id=\"h-who-s-this-article-for\" class=\"wp-block-heading\">Who\u2019s this article for?<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">During the very first Excel course I taught, back in 2010, I met TJ. She was a warehouse manager who, though very skilled in many ways, wasn\u2019t savvy with Microsoft Excel or data analysis. For her particular role, she relied on other people\u2019s spreadsheets, with data on scheduling, inventory, performance, products, and more. Since Excel wasn\u2019t her strong suit, you can imagine why this was concerning. And she\u2019s not alone.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">More people like TJ have been blindsided by spreadsheets and data as the entire world becomes more data-driven. Nothing is more frustrating than Excel formulas not working. They start at a job\u2014maybe driving a forklift or designing logos\u2014and they move up to leading small teams. Their skills might be more geared toward conflict resolution, team motivation, sales, or operating heavy machinery. But then there\u2019s the promotion to a role that\u2019s less about people and hands-on work, and more about data. <\/p>\n\n\n\n<p class=\"wp-block-paragraph\">As I wrote this article, I&#8217;ve kept several\u00a0people in mind:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>TJ, a manager who relies on and is responsible for complex spreadsheets that she just doesn\u2019t understand.&nbsp;<\/li>\n\n\n\n<li>Nancy, a manager who needs to sign off on someone\u2019s calculations without having the time (or need) to learn that person\u2019s job or re-do said calculations. All she needs to be able to do is look at the calculations to see if there are any spreadsheet \u201cbad habits.\u201d<\/li>\n\n\n\n<li>Avi, the CEO of a small company, who likes Excel just fine but has many other more important things to focus on, like looking for clients and growing the business. Still, he needs to know he can trust other people&#8217;s Excel work.<\/li>\n<\/ul>\n\n\n\n<h2 id=\"h-this-article-s-promise\" class=\"wp-block-heading\">This article\u2019s promise<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">This article won\u2019t take you into the guts of Excel\u2014more than a <em>how-to<\/em>, it\u2019s a <em>what to look for<\/em>. This article strives to get you thinking about <strong>the quality of your data and spreadsheets<\/strong>, as well as the skill of the people whose Excel files you rely on. If there\u2019s an Excel formula not working, one of these tips might lead you in the right direction.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">I\u2019m going to share several features of Excel that can help you do quick, high-level investigations of someone else\u2019s work.<em> Can you trust the data? Can you trust the person who made the spreadsheet? Does that person practice good spreadsheet habits?<\/em><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Those last two points are critical. Over the years as a consultant, I\u2019ve had to break the news to several managers that the person in charge of their spreadsheets might be accurate, but their bad habits are a ticking time bomb. Now it\u2019s time to find out: Is that the case for you, too? And yes, these might very well be tips to improve your own spreadsheets, too.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Let\u2019s dive in!<\/p>\n\n\n\n<h3 id=\"h-1-why-excel-formulas-are-a-must-the-sin-of-hard-coded-values\" class=\"wp-block-heading\">1. Why Excel formulas are a must: The sin of hard-coded values<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">The image below shows what these four people need to be paid. There are no formulas. Someone typed these numbers directly into the cells. And there\u2019s a problem in cell E5.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"475\" height=\"230\" src=\"https:\/\/beebole.com\/blog\/wp-content\/uploads\/2020\/11\/Excel-formulas-not-working.png\" alt=\"If your Excel formula isn&#039;t working, perhaps there isn&#039;t any formula at all, but rather a hard-coded value.\" class=\"wp-image-7621\" title=\"\"><figcaption class=\"wp-element-caption\">This data shows how much four people need to be paid; however, there is an issue in E5.<\/figcaption><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">According to cell E5, we owe $59.25 to H241. After doing the math:<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">30 hours * $19.75 = $592.50<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">OUCH! Someone used a calculator to do the math, and then made a very human typographical error <strong>and put the decimal in the wrong place<\/strong>. Of course, the Excel formula is not working because there was no formula to begin with!<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Formulas should be making these calculations, especially when we\u2019re talking about critical data like money. Sure, this is a simple example, but hard-coded values are often applied when calculations get more complex.\u00a0<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Another problem arises with hard-coded values when the data needs to be updated. Let\u2019s say, H327 actually worked 29 hours and their rate has gone up to $45\/hour. Formulas will automatically update the Pay in Column E. By using a formula instead, we don\u2019t have to rely on someone to remember to manually make the update and accurately do so.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">2. How to keep your data dynamic and integrated in Excel: Tables<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>The number one Excel feature that people should use more is Tables<\/strong>. Tables are the glue that holds your data together.\u00a0If you receive a workbook that doesn\u2019t have tables in it, be wary. Tables help ensure that data is integrated and that formulas cover complete columns. If your Excel formula doesn&#8217;t seem to be working, this might be why.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">In the image below, the data in columns C and D is totaled in F3: 185. The total for columns K and L is in H3: 122. They should be the same. What\u2019s going on?<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"700\" height=\"278\" src=\"https:\/\/beebole.com\/blog\/wp-content\/uploads\/2020\/11\/troubleshooting-formulas-excel-700x278.jpg\" alt=\"Using tables in Excel is the ideal way to keep data updated and to ensure a formula is working.\" class=\"wp-image-7629\" title=\"\" srcset=\"https:\/\/beebole.com\/blog\/wp-content\/uploads\/2020\/11\/troubleshooting-formulas-excel-700x278.jpg 700w, https:\/\/beebole.com\/blog\/wp-content\/uploads\/2020\/11\/troubleshooting-formulas-excel-768x305.jpg 768w, https:\/\/beebole.com\/blog\/wp-content\/uploads\/2020\/11\/troubleshooting-formulas-excel-1536x609.jpg 1536w, https:\/\/beebole.com\/blog\/wp-content\/uploads\/2020\/11\/troubleshooting-formulas-excel.jpg 1780w\" sizes=\"auto, (max-width: 700px) 100vw, 700px\" \/><figcaption class=\"wp-element-caption\">Here you can see the potential difference between using a Table and not using one.<\/figcaption><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">In F3 the formula is:<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">=SUM(Table1[[Store 1]:[Store 2]])<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Because the dataset is in a formal Table, the SUM formula includes the entire columns Store 1 and Store 2 in the table named Table1.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">In H3, the formula is: =SUM(K3:L10)<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">By selecting H3 and placing the cursor in the formula bar, we\u2019re able to see what area is covered by the formula. It stops counting at Electric Grape.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"483\" height=\"413\" src=\"https:\/\/beebole.com\/blog\/wp-content\/uploads\/2020\/11\/why-are-excel-formulas-not-updating.png\" alt=\"If your Excel formula is not working, try putting the cursor in the formula bar of Excel to see that without a Table, data has been excluded\" class=\"wp-image-7630\" title=\"\"><figcaption class=\"wp-element-caption\">Place the cursor in the formula bar to see which area is covered by the formula.<\/figcaption><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">How does this happen, you might wonder?<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Well, sometimes a person adds data slowly, whenever it happens to come in. When done this way, it\u2019s easy to forget to modify the formula. However, when adding new data to a table, the table absorbs the new data, applies existing formulas and updates calculations\u2026<em>automatically<\/em>. <strong>Insist that tables be used by the people who are sending you Excel files. <\/strong>And when in doubt about an Excel formula not working, check whether a table is being used or not.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"700\" height=\"422\" src=\"https:\/\/beebole.com\/blog\/wp-content\/uploads\/2020\/11\/how-to-check-excel-workbook-700x422.png\" alt=\"A few examples of how to identify Tables in Microsoft Excel to keep in mind if an Excel formula isn&#039;t working\" class=\"wp-image-7625\" title=\"\" srcset=\"https:\/\/beebole.com\/blog\/wp-content\/uploads\/2020\/11\/how-to-check-excel-workbook-700x422.png 700w, https:\/\/beebole.com\/blog\/wp-content\/uploads\/2020\/11\/how-to-check-excel-workbook-768x463.png 768w, https:\/\/beebole.com\/blog\/wp-content\/uploads\/2020\/11\/how-to-check-excel-workbook-1536x927.png 1536w, https:\/\/beebole.com\/blog\/wp-content\/uploads\/2020\/11\/how-to-check-excel-workbook.png 1724w\" sizes=\"auto, (max-width: 700px) 100vw, 700px\" \/><figcaption class=\"wp-element-caption\">Here are three ways to identify a Table in Microsoft Excel.<\/figcaption><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">3. A great way to double-check your data in Excel: Crossfooting<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">It just arrived! The Excel workbook with the summary that we\u2019ve been waiting for. It includes the breakdown of data by month and by product line.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"455\" height=\"189\" src=\"https:\/\/beebole.com\/blog\/wp-content\/uploads\/2020\/11\/excel-formula-troubleshooting.png\" alt=\"A summary page on Excel can be helpful, but only if the source data is correct. \" class=\"wp-image-7620\" title=\"\"><figcaption class=\"wp-element-caption\">A summary tab in Excel can be helpful, but how do you know you can trust the numbers you&#8217;re seeing?<\/figcaption><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">But the thing with summaries like this is that they can raise several questions. <em>Can we trust these numbers?<\/em> <em>How can we be sure the correct Excel formula is working?<\/em><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Let\u2019s say that in this scenario, we know that even on bad months that figure is at least $24,000. September is low, and $18,033.74 in October suggests either dreadful sales, a big client dropped us, or the calculations aren\u2019t accurate.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">This is definitely something that you\u2019d want to check before meeting with the executives, right? Below is the source data that\u2019s also in the workbook.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"534\" height=\"510\" src=\"https:\/\/beebole.com\/blog\/wp-content\/uploads\/2020\/11\/fixing-spreadsheet-workbook-in-excel.png\" alt=\"Source data that is used for the summary page in an Excel report. This is important to check if an Excel formula isn&#039;t working\" class=\"wp-image-7623\" title=\"\" srcset=\"https:\/\/beebole.com\/blog\/wp-content\/uploads\/2020\/11\/fixing-spreadsheet-workbook-in-excel.png 534w, https:\/\/beebole.com\/blog\/wp-content\/uploads\/2020\/11\/fixing-spreadsheet-workbook-in-excel-28x28.png 28w\" sizes=\"auto, (max-width: 534px) 100vw, 534px\" \/><figcaption class=\"wp-element-caption\">The source data used in the summary tab.<\/figcaption><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">In situations like this, where we have the source data and a summary, good spreadsheet development would include some kind of alert \u2014 for example, crossfooting \u2014 to indicate that the data is sound.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">While <strong>crossfooting <\/strong>is technically a formal term in accounting, I\u2019m borrowing it to describe <strong>calculating the data in at least two ways that should produce the same result.<\/strong>.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">With this data, you can see the crossfooting section within the dashed line.&nbsp;<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"700\" height=\"363\" src=\"https:\/\/beebole.com\/blog\/wp-content\/uploads\/2020\/11\/how-to-troubleshoot-excel-not-working-700x363.png\" alt=\"One quick, easy way to double-check that the data adds up and that Excel formulas are working is by crossfooting\" class=\"wp-image-7627\" title=\"\" srcset=\"https:\/\/beebole.com\/blog\/wp-content\/uploads\/2020\/11\/how-to-troubleshoot-excel-not-working-700x363.png 700w, https:\/\/beebole.com\/blog\/wp-content\/uploads\/2020\/11\/how-to-troubleshoot-excel-not-working-768x399.png 768w, https:\/\/beebole.com\/blog\/wp-content\/uploads\/2020\/11\/how-to-troubleshoot-excel-not-working.png 1158w\" sizes=\"auto, (max-width: 700px) 100vw, 700px\" \/><figcaption class=\"wp-element-caption\">An example of using a crossfooting method to double-check data.<\/figcaption><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">There are several components in this fairly sophisticated alert (Again, our objective isn\u2019t to get into the how-to. The main point is to show why it\u2019s important to have these features in good, reliable Excel files.):<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Cell J12 is a total of the Amounts in column E.<\/li>\n\n\n\n<li>J14:J16 totals each product line separately and provides an overall sum.<\/li>\n\n\n\n<li>J20:J21 uses the data in column F to calculate monthly totals.<\/li>\n\n\n\n<li>Cell J11 uses an IF statement to check whether those three totals are equal. If the totals don\u2019t match, the IF statement shows \u201cBEWARE!\u201d<\/li>\n\n\n\n<li>Conditional formatting is used to show bold text with a red fill if the numbers don\u2019t match.<\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"700\" height=\"361\" src=\"https:\/\/beebole.com\/blog\/wp-content\/uploads\/2020\/11\/common-mistakes-excel-troubleshooting-700x361.png\" alt=\"This alert is set up to have a quick glance at whether an Excel formula is working or not, and if you can trust the data\" class=\"wp-image-7617\" title=\"\" srcset=\"https:\/\/beebole.com\/blog\/wp-content\/uploads\/2020\/11\/common-mistakes-excel-troubleshooting-700x361.png 700w, https:\/\/beebole.com\/blog\/wp-content\/uploads\/2020\/11\/common-mistakes-excel-troubleshooting-768x396.png 768w, https:\/\/beebole.com\/blog\/wp-content\/uploads\/2020\/11\/common-mistakes-excel-troubleshooting-1536x792.png 1536w, https:\/\/beebole.com\/blog\/wp-content\/uploads\/2020\/11\/common-mistakes-excel-troubleshooting.png 1830w\" sizes=\"auto, (max-width: 700px) 100vw, 700px\" \/><figcaption class=\"wp-element-caption\">The BEWARE! alert in red lets us know that we can&#8217;t trust the data in the summary.<\/figcaption><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">This alert is a quick-glance method of knowing whether you can trust the data in the summary.\u00a0<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Question: What can we tell from this specific example?&nbsp;<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Answer: We CANNOT trust the summary in I3:L6<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Send this data back to whomever compiled it, and have them troubleshoot and repair it until the alert looks like this:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"356\" height=\"383\" src=\"https:\/\/beebole.com\/blog\/wp-content\/uploads\/2020\/11\/why-excel-formula-isnt-working.png\" alt=\"An example of when an Excel formula is working, the data does add up in Excel, and we are able to trust the data in the summary tab of the workbook\" class=\"wp-image-7631\" title=\"\"><figcaption class=\"wp-element-caption\">When you see the OK alert at the top, you know you can trust the data.<\/figcaption><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">All three values are equal, and the Check value says OK.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">4. Right-click: Is there anything hiding?<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Here\u2019s a workbook that includes membership data. Members are in three groups on different sheets: Orange, Crimson, and Purple. We\u2019ve got a nice summary on the <strong>Overview sheet<\/strong>.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"527\" height=\"350\" src=\"https:\/\/beebole.com\/blog\/wp-content\/uploads\/2020\/11\/examples-of-excel-formulas-not-working.png\" alt=\"This overview sheet in Excel has incorrect data, so how can we make sure the Excel formula is working?\" class=\"wp-image-7618\" title=\"\"><figcaption class=\"wp-element-caption\">An overview tab that shows membership data.<\/figcaption><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">However, there\u2019s a problem. In this scenario, we know that Dakota is the Chairperson of the Crimson group, not Ariana, as shown in cell D6.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">However, in D6 there\u2019s a complex formula that\u2019s retrieving Ariana\u2019s name, as noted below.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"624\" height=\"146\" src=\"https:\/\/beebole.com\/blog\/wp-content\/uploads\/2020\/11\/how-to-check-an-excel-formula.png\" alt=\"This complex formula in D6 lets us know that there is a hidden sheet named Details in this Excel workbook\" class=\"wp-image-7624\" title=\"\"><figcaption class=\"wp-element-caption\">This complex formula is used in D6.<\/figcaption><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Knowing exactly what this formula is doing isn\u2019t so important. But at a higher level, notice this: Details!. The exclamation point is Excel\u2019s way of telling us that there is a sheet named <em>Details<\/em> somewhere in this workbook. But according to the screenshot above, we only see sheets named Overview, Crimson, Orange, and Purple.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">The Details sheet must be hidden.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Here\u2019s how to find it:<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Hover over any of the tabs<\/li>\n\n\n\n<li>Right-click<\/li>\n\n\n\n<li>Select Unhide<\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"317\" height=\"367\" src=\"https:\/\/beebole.com\/blog\/wp-content\/uploads\/2020\/11\/checking-fixing-excel-workbooks.png\" alt=\"To find hidden sheets in Excel workbooks, right click over any of the tabs, and select unhide.\" class=\"wp-image-7615\" title=\"\"><figcaption class=\"wp-element-caption\">Right-click while hovering over any of the tabs, and select Unhide.<\/figcaption><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Oh! There\u2019s a Details sheet and an Indigo sheet, both hidden.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"426\" height=\"293\" src=\"https:\/\/beebole.com\/blog\/wp-content\/uploads\/2020\/11\/excel-workbook-troubleshooting.png\" alt=\"In fact, there were two hidden sheets in this Excel workbook: Indigo and Details.\" class=\"wp-image-7622\" title=\"\"><figcaption class=\"wp-element-caption\">A window pops up to show two hidden sheets.<\/figcaption><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Select Details, and click OK.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"700\" height=\"380\" src=\"https:\/\/beebole.com\/blog\/wp-content\/uploads\/2020\/11\/how-to-check-someone-elses-excel-workbook-700x380.png\" alt=\"A hidden page in this Excel workbook has incorrect data, which is why the Excel formula is not working properly\" class=\"wp-image-7626\" title=\"\" srcset=\"https:\/\/beebole.com\/blog\/wp-content\/uploads\/2020\/11\/how-to-check-someone-elses-excel-workbook-700x380.png 700w, https:\/\/beebole.com\/blog\/wp-content\/uploads\/2020\/11\/how-to-check-someone-elses-excel-workbook-768x417.png 768w, https:\/\/beebole.com\/blog\/wp-content\/uploads\/2020\/11\/how-to-check-someone-elses-excel-workbook.png 804w\" sizes=\"auto, (max-width: 700px) 100vw, 700px\" \/><figcaption class=\"wp-element-caption\">After clicking OK, the hidden Details sheet appears.<\/figcaption><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">WOW! There\u2019s a lot on the Details sheet., including a separate dues structure for people in the Orange group. Cell G3 is where Dakota\u2019s name should replace Ariana.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">You can use hidden sheets for many purposes, including:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>protecting complex formulas&nbsp;<\/li>\n\n\n\n<li>sheets with notes or instructions<\/li>\n\n\n\n<li>background data that needs to be accessible but not always visible<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">If you\u2019re dealing with a workbook that you didn\u2019t create, <strong>it\u2019s a good habit to check for any hidden sheets<\/strong>. They may not always be relevant, but it\u2019s a best practice to find out if any exist.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">5. How do you show formulas in Excel? The accent trick<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">One simple but valuable feature in Excel allows you to see all of the formulas on a sheet, which is a handy trick if you&#8217;re troubleshooting why an Excel formula isn&#8217;t working. It\u2019s a shortcut to show all formulas in Excel. This helps with troubleshooting when you know that something is wrong or you simply want to review all of the formulas (or check if the person who created the file uses good habits.)<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Below, we received the summary of contractors that need to be paid.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"472\" height=\"229\" src=\"https:\/\/beebole.com\/blog\/wp-content\/uploads\/2020\/11\/excel-formula-common-errors.png\" alt=\"To double check formulas not working and math in Microsoft Excel, simply press CTRL+&#039; to reveal all formulas.\" class=\"wp-image-7619\" title=\"\"><figcaption class=\"wp-element-caption\">A summary of contractors that need to be paid.<\/figcaption><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Rather than do the math in our heads to determine if these numbers are accurate, let\u2019s take a quick, high-level peek at the formulas.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Press CTRL+`<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"700\" height=\"145\" src=\"https:\/\/beebole.com\/blog\/wp-content\/uploads\/2020\/11\/common-errors-in-excel-workbooks-700x145.png\" alt=\"After pressing CTRL+&#039; to reveal all formulas, here&#039;s an example of the formulas you&#039;d see and be able to make sure they&#039;re functioning properly.\" class=\"wp-image-7616\" title=\"\" srcset=\"https:\/\/beebole.com\/blog\/wp-content\/uploads\/2020\/11\/common-errors-in-excel-workbooks-700x145.png 700w, https:\/\/beebole.com\/blog\/wp-content\/uploads\/2020\/11\/common-errors-in-excel-workbooks-768x159.png 768w, https:\/\/beebole.com\/blog\/wp-content\/uploads\/2020\/11\/common-errors-in-excel-workbooks.png 1140w\" sizes=\"auto, (max-width: 700px) 100vw, 700px\" \/><figcaption class=\"wp-element-caption\">By pressing CTRL+`, you can reveal all of the formulas being used.<\/figcaption><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">And just like that, all of the formulas are revealed. The Hours and Expenses calculations look okay, but the Pay column is strange.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"253\" height=\"185\" src=\"https:\/\/beebole.com\/blog\/wp-content\/uploads\/2020\/11\/how-to-troubleshoot-microsoft-excel-workbook.jpg\" alt=\"A close-up look at the formulas once they&#039;ve been revealed by pressing CTRL+&#039; shows there is some unaccounted for amounts being added and subtracted.\" class=\"wp-image-7628\" title=\"\"><figcaption class=\"wp-element-caption\">Once the formulas have been revealed, you might have further questions.<\/figcaption><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Subtract \u20ac100 from Chana, and add \u20ac75 to Humberto?&nbsp;<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">While there might be legitimate reasons for this, the point is that we don\u2019t know what they are. This can cause confusion when it comes to understanding why Excel formulas may not be working correctly. We aren\u2019t sure whether these are corrections from previous payments or can be explained some other way. The bottom line, however, is that we need to press CTRL+` to return to the normal view, then contact the person who created the summary and:<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Find out what these adjustments are.<\/li>\n\n\n\n<li>If these are legitimate corrections, look for an area in the workbook to place such corrections and apply them to the Pay column by using formulas.<\/li>\n\n\n\n<li>Train that person away from the sin of hard-coded values in a spreadsheet.<\/li>\n<\/ol>\n\n\n\n<p class=\"wp-block-paragraph\">And if the adjustments aren\u2019t valid, we\u2019ve got a different problem entirely that likely needs to involve Human Resources.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">The art of understanding why Excel formulas aren&#8217;t working<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">When it comes to understanding an Excel workbook and diving into data that someone else has analyzed and summarized, there are many tools and techniques to ensure that formulas are working. The ones I\u2019ve highlighted here are <strong>quick ways to troubleshoot Excel data<\/strong>, ensure your reporting is as accurate as possible, and pinpoint some of the most common mistakes you (or your team) might be making.&nbsp;<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Excel is a powerful tool, but it&#8217;s made even more powerful when the data behind it is accurate to begin with. <a class=\"highlighted-link bbl-link-hs bbl-link-hs-v-1\" href=\"https:\/\/beebole.com\"><span>Beebole<svg width=\"17\" height=\"18\" viewBox=\"0 0 17 18\" fill=\"none\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\"><path fill-rule=\"evenodd\" clip-rule=\"evenodd\" d=\"M11.25 0.875H15.625C15.7908 0.875 15.9497 0.940848 16.0669 1.05806C16.1842 1.17527 16.25 1.33424 16.25 1.5V5.875C16.25 6.04076 16.1842 6.19973 16.0669 6.31694C15.9497 6.43415 15.7908 6.5 15.625 6.5C15.4592 6.5 15.3003 6.43415 15.1831 6.31694C15.0658 6.19973 15 6.04076 15 5.875V3.00833L4.81667 13.1917C4.69819 13.3021 4.54148 13.3622 4.37956 13.3593C4.21765 13.3565 4.06316 13.2909 3.94865 13.1764C3.83414 13.0618 3.76854 12.9074 3.76569 12.7454C3.76283 12.5835 3.82293 12.4268 3.93333 12.3083L14.1167 2.125H11.25C11.0842 2.125 10.9253 2.05915 10.8081 1.94194C10.6908 1.82473 10.625 1.66576 10.625 1.5C10.625 1.33424 10.6908 1.17527 10.8081 1.05806C10.9253 0.940848 11.0842 0.875 11.25 0.875ZM2.5 4.625C2.16848 4.625 1.85054 4.7567 1.61612 4.99112C1.3817 5.22554 1.25 5.54348 1.25 5.875V14.625C1.25 14.9565 1.3817 15.2745 1.61612 15.5089C1.85054 15.7433 2.16848 15.875 2.5 15.875H11.25C11.5815 15.875 11.8995 15.7433 12.1339 15.5089C12.3683 15.2745 12.5 14.9565 12.5 14.625V7.75C12.5 7.58424 12.5658 7.42527 12.6831 7.30806C12.8003 7.19085 12.9592 7.125 13.125 7.125C13.2908 7.125 13.4497 7.19085 13.5669 7.30806C13.6842 7.42527 13.75 7.58424 13.75 7.75V14.625C13.75 15.288 13.4866 15.9239 13.0178 16.3928C12.5489 16.8616 11.913 17.125 11.25 17.125H2.5C1.83696 17.125 1.20107 16.8616 0.732233 16.3928C0.263392 15.9239 0 15.288 0 14.625V5.875C0 5.21196 0.263392 4.57607 0.732233 4.10723C1.20107 3.63839 1.83696 3.375 2.5 3.375H9.375C9.54076 3.375 9.69973 3.44085 9.81694 3.55806C9.93415 3.67527 10 3.83424 10 4C10 4.16576 9.93415 4.32473 9.81694 4.44194C9.69973 4.55915 9.54076 4.625 9.375 4.625H2.5Z\"\/><\/svg><\/span><\/a> lets you plan hours and resources, monitor capacity, and track time \u2014 all from one place. <a href=\"https:\/\/beebole.com\/integrations\/excel\">That data can be exported straight into Excel thanks to Beebole&#8217;s add-in<\/a>, which pulls live report data into your workbook with on-demand refresh. No manual re-entry, no retyped totals, and one less place for the kind of &#8220;sins&#8221; this article just walked you through to creep in.<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"590\" height=\"386\" src=\"https:\/\/beebole.com\/blog\/wp-content\/uploads\/2026\/08\/Beebole-report-loader-with-excel-add-in.png\" alt=\"Beebole report loader with the Excel add-in for Beebole\" class=\"wp-image-15024\" title=\"\"><figcaption class=\"wp-element-caption\"><a href=\"https:\/\/beebole.com\/integrations\/excel\">Learn how to connect Beebole straight to Excel here.<\/a><\/figcaption><\/figure>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p class=\"wp-block-paragraph\">Tell me in the comments: What\u2019s been your biggest data snafu in Excel? How\u2019d you fix it?<\/p>\n\n\n\n<div  class=\"mx-auto bbl_suggested_post_block my-5\">\n\t<a class=\"bbl_sp_block-blockcontent align-items-center d-flex flex-column flex-md-row justify-content-center\" href=\"https:\/\/beebole.com\/blog\/excel-power-query-for-business-intelligence\" title=\"Excel Power Query: The 5 hacks for business intelligence you should have in your arsenal\">\n\t\t<img\n\t\t\talt=\"Excel Power Query: The 5 hacks for business intelligence you should have in your arsenal\"\n\t\t\tclass=\"d-block h-auto\"\n\t\t\tloading=\"lazy\"\n\t\t\theight=\"153\"\n\t\t\tsrc=\"https:\/\/beebole.com\/blog\/wp-content\/themes\/sage\/public\/images\/suggested-post.cad3bf.png\"\n\t\t\twidth=\"233\"\n\t\t\/>\n\t\t<div class=\"bbl_sp_block-text-col\">\n\t\t\t\t\t\t\t<div class=\"mb-1\"><div class=\"bbl_sp_block-label mb-3\">RELATED POST<\/div><\/div>\n\t\t\t\t\t\t<div class=\"bbl_sp_block-title\">Excel Power Query: The 5 hacks for business intelligence you should have in your arsenal<\/div>\n\t\t\t\t\t\t\t<div class=\"bbl_sp_block-button mt-3\">\n\t\t\t\t\tRead more\t\t\t\t\t<svg width=\"14\" height=\"14\" viewBox=\"0 0 14 14\" fill=\"none\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\">\n\t\t\t\t\t\t<path d=\"M5.25 10.5L8.75 7L5.25 3.5\" stroke=\"white\" stroke-width=\"1.16667\" stroke-linecap=\"round\" stroke-linejoin=\"round\" \/>\n\t\t\t\t\t<\/svg>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t<\/a>\n<\/div><div class=\"bbl-post-disclaimer\">The experts who have written or contributed to this article are independent from Beebole, and their contribution doesn't serve as endorsement for our company\/tool or their past\/present organizations, employers, or associates.<\/div>","protected":false},"excerpt":{"rendered":"<p>When it comes to working with data in Microsoft Excel, especially if it wasn\u2019t your data to begin with, things can get tricky quickly. Between Excel formulas not working, human error, and simply trying to understand someone else\u2019s thought process, there are a lot of ways checking and fixing an Excel workbook can go wrong. [&hellip;]<\/p>\n","protected":false},"author":26,"featured_media":7775,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"rank_math_title":"Excel formulas not working? 5 ways to troubleshoot data - By Oz Du Soleil","rank_math_description":"Excel formulas not working? 5 quick ways to troubleshoot data and review someone else's workbook. Ensure your report is accurate and correct.","footnotes":""},"categories":[123],"tags":[3989,4012],"class_list":["post-7605","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-productivity-time-management","tag-excel","tag-tutorials"],"acf":[],"_links":{"self":[{"href":"https:\/\/beebole.com\/blog\/wp-json\/wp\/v2\/posts\/7605","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/beebole.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/beebole.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/beebole.com\/blog\/wp-json\/wp\/v2\/users\/26"}],"replies":[{"embeddable":true,"href":"https:\/\/beebole.com\/blog\/wp-json\/wp\/v2\/comments?post=7605"}],"version-history":[{"count":22,"href":"https:\/\/beebole.com\/blog\/wp-json\/wp\/v2\/posts\/7605\/revisions"}],"predecessor-version":[{"id":15045,"href":"https:\/\/beebole.com\/blog\/wp-json\/wp\/v2\/posts\/7605\/revisions\/15045"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/beebole.com\/blog\/wp-json\/wp\/v2\/media\/7775"}],"wp:attachment":[{"href":"https:\/\/beebole.com\/blog\/wp-json\/wp\/v2\/media?parent=7605"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/beebole.com\/blog\/wp-json\/wp\/v2\/categories?post=7605"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/beebole.com\/blog\/wp-json\/wp\/v2\/tags?post=7605"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}