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?
| +283 | UBS Tech MD hires Son (from no-name college) as an Intern | 49 | 16h |
| +166 | WTF IS THIS COMPETITON | 59 | 1d |
| +124 | Is banking in the south more sustainable? | 29 | 11h |
| +101 | The Intern Starter Pack | 17 | 3h |
| +76 | Current State of the League Tables | 28 | 1d |
| +60 | [Official] 2026 IB Analyst Bonus Megathread (with 2025 Consolidated Pay and Perks/Benefits) | 11 | 8h |
| +51 | Perella Weinberg to Cut 10% of Workforce, Including Partners | 33 | 4h |
| +40 | UBS Groups Ranked by Future Outlook | 20 | 2d |
| +32 | PWP Layoffs????? | 18 | 4d |
| +32 | UVA McIntire vs Cornell Dyson for IB | 19 | 6h |
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
Quos rerum molestias eius atque nemo. Adipisci voluptatem aut ducimus aspernatur ut. Sed sed earum libero autem necessitatibus maiores culpa. Iste iusto ea ea tempora.
Blanditiis mollitia eaque quisquam aut dolores est quia. Neque id ullam ducimus. Dolor et fugit sed voluptatibus iste doloribus. Ut autem eum error et cupiditate. Iste et nobis dolorem porro veniam recusandae dolorem ex.
Sed dicta architecto non provident earum eum delectus. Et ea distinctio magnam eos qui. Id ipsum quis voluptatem culpa dolores quo asperiores. Laudantium eligendi excepturi quibusdam labore aliquid dolor.
Sit mollitia dolor occaecati delectus minus non doloribus. Ipsa libero illum impedit dolorem dicta. Praesentium eaque animi odio voluptate.
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...