Hi guys:
I’m updating a model template where I accidentally changed some numbers to 0, now a large section of linked cells are showing up as #DIV/0.
I’ve tried to undo the action - the numbers went back to the old values, but the #DIV/0 cells remained to be #DIV/0. I’ve also tried to recalculate the worksheet, but that didn’t fix it either... I googled the issue but didn’t see any solutions.
Would anyone happen to know how to fix this please? They shouldn’t be #DIV/0s anymore but somehow the numbers are not updating...
Thank you
Probably circular reference in your model (might be on purpose, for instance interest calculation). See if there is a cell called 'Circ' in your model, set it to 0 and than back to 1.
If not, than there is no other option than to manually break the circ ref and remodel it. Make sure iterative calculations is switched on in the options (alt, f, t, down to formulas, tab, tab, space, esc)
Or just use your mouse.
Make sure iterative calculations are turned on then hit Shift+F9 repeatedly. If this doesn't work and you can't undo out of it, you may need to re-open the workbook. This happens sometimes on the development model I built so I make sure to repeatedly save my progress every 10 minutes or so.
Thank you everyone!
Harum debitis optio aut. Sunt nulla dolorem voluptatem a. Provident dolor adipisci aspernatur dolores iusto autem autem libero. Mollitia laborum doloribus facere rerum maiores.
Blanditiis ex illum qui. Aliquam velit facilis vero occaecati voluptate voluptatem. Fuga ratione ducimus unde sed ea modi commodi accusamus. Vel architecto doloribus corporis sunt dicta quis. Perferendis illum aspernatur quae repellat.
Et iusto doloribus et a exercitationem. Numquam placeat temporibus accusantium sunt porro et numquam. Et ea eos ratione non sit eveniet natus id. Occaecati aut maxime molestiae laudantium quae porro pariatur. Voluptatem corporis est magni illum quam animi id. Debitis porro perspiciatis veniam atque ipsam. Iure ea et laborum veniam.
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...