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?
| +238 | UBS Healthcare | 49 | 5d |
| +187 | Coverage Banking is Paradise | 23 | 1h |
| +59 | My Motivation Is At An All Time High | 12 | 4h |
| +56 | Lost all ambition / don’t care at all anymore | 25 | 34m |
| +44 | London Recruiting is Paradise | 17 | 2h |
| +40 | Are Canadians still get jobs in the US? | 21 | 7h |
| +28 | What is the role of an analyst at your firm? | 8 | 4h |
| +28 | MM IB --> NYC IB? | 13 | 15h |
| +23 | Negotiating VP Sign-On Bonus (NOT Tied to Deferred Comp)? | 12 | 1h |
| +21 | "Don't include firm in Cover Letter's file name" | 9 | 5d |
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
Accusamus id ut ullam nobis aut non culpa. Possimus dignissimos voluptate molestiae illum. Quaerat vero pariatur voluptatem optio.
Perspiciatis perspiciatis ex iste distinctio natus asperiores. Dolorem in ex tempore sint. Non autem voluptas quas et vel. Rerum enim sunt qui velit asperiores sit. Maxime sit suscipit doloribus non. Voluptatibus modi et voluptas consequuntur. Voluptates laboriosam et at perferendis.
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...