ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   won't update formula (https://www.excelbanter.com/excel-programming/361296-wont-update-formula.html)

Dirk Nachbar

won't update formula
 
All

I just have the strangest thing happening to me. I fill in a formula
and then copy it across but Excel won't update the values, so that the
whole column has the value of the first row, which shouldn't be. I am
to lazy to press enter F2 and enter thousand times and was wondering if
you know what could be the cause of this.

Dirk


[email protected]

won't update formula
 
Manual calculation? Absolute cell references instead of relative ones?



All times are GMT +1. The time now is 07:23 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com