ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Formulae not updating (https://www.excelbanter.com/excel-discussion-misc-queries/197471-formulae-not-updating.html)

Pivot Man[_2_]

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