![]() |
Formulae not updating
Hello, I am having a really odd problem. I have about 4 workbooks that are
linked to each other. I always open all 4 at the same time. The files reference each other. One is a sales forcast one is an expense forecast one in a headcount summary and one is a financial model (P&L, BS and cash) Calculations are set to automatic. For whatever reason, the formulae have stopped updating automatically. A change to the expense forecast is not flowing through to the Income statement. I have to go into the cell and click on the formulae and hit return for the cell to update. There are no circular references, nothing all that fancy.. I am stumpled. I have tried updating all links...no effect. I am also noticing that the Calculate message is always at the bottom of the worksheet...even right after i manually recalc. Any ideas? Thanks |
All times are GMT +1. The time now is 04:20 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com