• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Screwy Cells

ericlind

New Member
Hey Folks,


I reuse a couple of spreadsheets every day; both of which are supplied with new data each day. The problem I'm having now is that Excel isn't updating the results of my calculations.


So for example if the first cell in the column is calculated as 123, and I double click the handle through the entire column, every cell in the column says 123, instead of whatever the calculated value should be.


I think it's perhaps a problem with my macros worksheet, but is there a simple fix for this?


My current solution is to F2 and Enter on every affected cell, but that's a pain after the first 100 or so cells.


Thanks,


Eric~
 

keymaster

New Member
Looks like you have set formula calculation to "manual" from "automatic" Go to tools>options and change the spreadsheet calculation mode to "automatic" from "calculation" tab. (in excel 2007, go to formulas ribbon and adjust calculation options).. If the problem persists, it could be due to macro. You can overcome this by selecting the range of cells and pressing F9 to recalculate the values. Or may be correct the macro...
 
Top