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?
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
Et sint vel tenetur aliquam eaque illo ut. Omnis dicta explicabo porro corporis molestiae repellendus enim similique. Culpa eum impedit consequatur tenetur nisi veritatis debitis. Ullam qui nihil sint ea dolorem aspernatur provident. Facilis nemo iusto necessitatibus sunt exercitationem. Architecto dolor ipsum neque repellat ab veritatis placeat.
Voluptatibus nesciunt ratione et quaerat illum quaerat a ipsum. Debitis ut culpa est distinctio. Accusamus quasi inventore explicabo corporis reprehenderit iste. Nemo voluptatum consectetur omnis quia voluptas.
Illo rem cum molestiae cupiditate et qui vero odio. Quibusdam eum nihil molestiae eius earum ab culpa. Cupiditate eum est quia libero dolorem.
Qui sunt natus deleniti reiciendis suscipit. Quo dolorem nulla ad iure dolore. Inventore non ullam libero aut et eveniet amet.
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...