Excel not calculating formulas

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,

What version of Excel are you using? Are you using any user defined
functions?

I found the following in a Google groups search on "excel formulas do not
calculate":

http://groups.google.com.au/group/mi...7fee234aa2f9bf

http://groups.google.com.au/group/mi...7fee234aa2f9bf

http://groups.google.com.au/group/mi...a5c1e56b899e4a

Hope this helps.

Sean


"Karthik" <karthik.bhat@db.com> wrote in message
news:1143779119.113457.304540@v46g2000cwv.googlegroups.com...
> 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 to calculate all formulas. I simply wrote a macro that goes to the last cell in the sheet, then moves activecell one row down and remove active 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 cell afterward.


Do anyone have an idea how to fix it permanently, some option in 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 Sub