A model of mine has this issue where unless I have formulas on full / automatic (I like to keep them on partial / automatic except data tables), I get these weird lines on cells unless I save the file. See below screenshot. What's weird is that these aren't even data tables, just normal sum formulas, so the data does change, the lines just don't go away.
This issue is specific to this one file; all others are normal. Anyone know how to fix?
| +202 | UBS Accused of Favoring H-1B Workers While Cutting U.S.-Born Employees | 50 | 13h |
| +105 | IB Energy Drink Tier List / Ranking | 72 | 14m |
| +88 | PJT M&A Group Selection 2026 | 13 | 1d |
| +81 | ONLY THESE BANKS OR YOU STRUCK OUT | 28 | 12h |
| +39 | Firm Thinks I'm Lying About Offer | 17 | 1m |
| +38 | Feedback for internship first desk at IBD BB - personal fit, "don't be too confident" | 28 | 1h |
| +29 | Does BofA still pay its associates rat pellets? | 14 | 1d |
| +29 | Stay at Weak Dealflow Team or Lateral? | 7 | 1h |
| +19 | Updated JPM Group Rankings | 31 | 14h |
| +19 | VP Deal Origination Credit | 2 | 1d |
Career Resources
Get instant access to lessons taught by experienced private equity pros and bulge bracket investment bankers including financial statement modeling, DCF, M&A, LBO, Comps and Excel Modeling.
File > Options > Formula > Scroll down to “Error checking rules” > Uncheck “Cells containing stale value”
I think this was added and/or was turned on as default in an Office update in the last year
Nemo deserunt et voluptas animi in voluptatem. Quo quae aut ea quia. Saepe eveniet beatae ut eos.
Libero id similique maxime sapiente sunt. Explicabo quidem iste ab dolorem excepturi facilis. Reprehenderit qui soluta nihil ad perspiciatis ad placeat. Nam et dolorem id et. Eius necessitatibus reprehenderit autem.
Repellat voluptas quia expedita velit repudiandae quia. Autem totam placeat eos assumenda voluptatem sed velit. Sequi consequatur minima soluta quis eveniet. Veniam earum quo ea. Quam atque necessitatibus et aliquam consequatur vel deserunt.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...