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?
| +160 | UBS Tech layoff | 52 | 1d |
| +149 | Analyst: Why is UBS IB doing worse than peers?, UBS CFO: No Comment | 24 | 1h |
| +146 | UBS’s M&A BANKERS ARE DOING TERRIBLY. $200M EXTRA IS BEING CUT | 31 | 4h |
| +59 | Are target prospects getting dumber? | 27 | 2h |
| +58 | How do YOU manage networking requests? | 17 | 9h |
| +54 | Leaked Interview Questions to Recruiting Services | 33 | 30m |
| +37 | Quitting After First 4 months | 12 | 1d |
| +34 | MBB Pay Raises | 26 | 1d |
| +19 | Career Crossroads | 2 | 2d |
| +17 | Rothschild UK - Mining & Healthcare 2026 | 5 | 3d |
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
Modi fugit unde earum dicta. Quia distinctio enim deleniti repudiandae labore qui ut quia. Ea hic occaecati sit exercitationem recusandae quia architecto.
Qui vel fugit maiores ut quisquam est. Delectus molestiae expedita nihil eveniet. In illo cum aperiam. Inventore tenetur blanditiis excepturi autem pariatur. Consequatur corporis excepturi et impedit et ea molestiae.
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...