Formulas not calculating periodically
in [General]
|
From: amted88 on 20 May 2010 09:30 I have Office 2003, this started a couple of weeks ago that simple formuls like Sum or =A1+A2, etc, will not calculate. These are worksheets that work when I have them open and then a little while later will not work when I open them again. I can close and not save and then try to open them again and the formulas will work the next time (sometimes I have to open and close it 4 or 5 times before it works). It seems to be happening more frequently now. I checked that autocalculate is checked. Even hitting F9 will not work.
From: MimiS on 20 May 2010 10:11 Could be a virus on your computer or in the Excel files. "amted88" wrote: > I have Office 2003, this started a couple of weeks ago that simple formuls > like Sum or =A1+A2, etc, will not calculate. These are worksheets that work > when I have them open and then a little while later will not work when I open > them again. I can close and not save and then try to open them again and the > formulas will work the next time (sometimes I have to open and close it 4 or > 5 times before it works). > > It seems to be happening more frequently now. > > I checked that autocalculate is checked. Even hitting F9 will not work. > >
From: amted88 on 21 May 2010 08:43 We have McAfee running constantly. Would uninstalling and re-intalling Excel help? what do you think? "MimiS" wrote: > Could be a virus on your computer or in the Excel files. > > "amted88" wrote: > > > I have Office 2003, this started a couple of weeks ago that simple formuls > > like Sum or =A1+A2, etc, will not calculate. These are worksheets that work > > when I have them open and then a little while later will not work when I open > > them again. I can close and not save and then try to open them again and the > > formulas will work the next time (sometimes I have to open and close it 4 or > > 5 times before it works). > > > > It seems to be happening more frequently now. > > > > I checked that autocalculate is checked. Even hitting F9 will not work. > > > >
From: Niek Otten on 21 May 2010 09:56 I'd try reconstructing the calculation dependency tree; press CTRL+ALT+SHIFT+F9. Note that Excel has one setting for automatic or manual calculation for all workbooks open in that instance of Excel. The first workbook opened determines the setting. -- Kind regards, Niek Otten Microsoft MVP - Excel "amted88" <amted88(a)discussions.microsoft.com> wrote in message news:4BF5A967-F6D6-4505-87EA-6064C2FB27B0(a)microsoft.com... > We have McAfee running constantly. Would uninstalling and re-intalling > Excel > help? what do you think? > > "MimiS" wrote: > >> Could be a virus on your computer or in the Excel files. >> >> "amted88" wrote: >> >> > I have Office 2003, this started a couple of weeks ago that simple >> > formuls >> > like Sum or =A1+A2, etc, will not calculate. These are worksheets that >> > work >> > when I have them open and then a little while later will not work when >> > I open >> > them again. I can close and not save and then try to open them again >> > and the >> > formulas will work the next time (sometimes I have to open and close it >> > 4 or >> > 5 times before it works). >> > >> > It seems to be happening more frequently now. >> > >> > I checked that autocalculate is checked. Even hitting F9 will not >> > work. >> > >> >
From: bala_vb on 21 May 2010 12:35 amted88;954921 Wrote: > I have Office 2003, this started a couple of weeks ago that simple > formuls > like Sum or =A1+A2, etc, will not calculate. These are worksheets that > work > when I have them open and then a little while later will not work when > I open > them again. I can close and not save and then try to open them again > and the > formulas will work the next time (sometimes I have to open and close it > 4 or > 5 times before it works). > > It seems to be happening more frequently now. > > I checked that autocalculate is checked. Even hitting F9 will not > work. just workaround, to have calculation untill investigation on virus issue try this code, go to VBE, double click on "this workbook" and copy this code the below code forcely makes excel to calcuate whenever you open excel and activate any sheet. Private Sub Workbook_Open() Application.Calculation = xlCalculationAutomatic End Sub Private Sub Workbook_SheetActivate(ByVal Sh As Object) Application.Calculation = xlCalculationAutomatic End Sub all the best -- bala_vb
|
Pages: 1 Prev: how do i insert a watermark in spreadsheet? Next: Save print settings |