Excel not calculating formulas

  • Thread starter Thread starter Karthik
  • Start date Start date
K

Karthik

Hi All

I have been using excel for few years now but have never had this
problem... Wonder if anyone has any tips on my problem.

I have a file which has 15 sheets and the 15th sheet is sum of the
remaining sheets. In all I have used 70 columns and 250 rows in all
sheets. The problem is that the 15th sheet (which is a sum sheet) is
not getting updated once the changes are effected on dependant sheets.

I have checked and rechecked the claculation mode to be in Automatic
and also switched between Automatic and Manual calculation mode several
times.
Restarted Excel as well as my comp several times.
Tried using F9 key......

all this but the sum would not change. And I am forced to go and hit
the F2 key and then press Enter Key for each of the cells in the sum
sheet and only then the valuse get updated.

Has anyone gott an I dea as to what might be wrong...

Thanks in advence
Karthik Bhat
 
Hi

Found the same behaviour when using user functions defined in VBA.
I use simple workaround: removing a row from a sheet forces Excel t
calculate all formulas. I simply wrote a macro that goes to the las
cell in the sheet, then moves activecell one row down and remove activ
row. I assign it to the button called 'DO Calculate'. It is quite messy
I was in the hurry writing it ;). It also returns to active cel
afterward.


Do anyone have an idea how to fix it permanently, some option i
Excel?



Sub RemoveLastRow()

startx = ActiveCell.Column
starty = ActiveCell.row
backtostart = Cells(starty
startx).AddressLocal(RowAbsolute:=False, ColumnAbsolute:=False)

ActiveCell.SpecialCells(xlLastCell).Select
x = ActiveCell.Column
y = ActiveCell.row
newaddr = Cells(y + step, x).AddressLocal(RowAbsolute:=False
ColumnAbsolute:=False)
Range(newaddr).Activate

row = ActiveCell.row
rowStr = StrConv(row, 1)

removeme = rowStr + ":" + rowStr

Rows(removeme).Select
Selection.Delete Shift:=xlUp
Range(backtostart).Activate

End Su
 
Back
Top