Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formulae: Paste value formulae after doing an average operation | Excel Discussion (Misc queries) | |||
Help with formulae | New Users to Excel | |||
repost; Automatically updating formulae in multiple sheets | Excel Discussion (Misc queries) | |||
Searching TEXT in formulae, rather than results of formulae | Excel Worksheet Functions | |||
When updating a worksheet, how do I create a link updating the sa. | Excel Worksheet Functions |