Free Microsoft Excel 2013
Quick Reference
Free Microsoft 2013 Quick Reference Guide

Free Microsoft Excel 2013 Quick Reference

why formulas have stopped working in Excel?

My formulas in Excel have suddenly stopped working. I have virus checked and
repaired then reinstalled my Office 2003 but to no avail. Please can anyone
help?
Thanks Jude


Post your answer or comment

comments powered by Disqus
I have used the same Excel 2003 workbook for many years, and all of a sudden
the formulas just stopped working. I can re-enter the formula, but it will
not calculate?

I have several spread sheets that I have been using for about 2 years and suddenly the formulas have stopped working. I have reloaded the entire Office program hoping this might help but it hasn't. I can see the formula in the cell however excel cannot see, if I rewrite the formula it will work for that time only, meaning if I close the spread sheet and re-open again it doesn't work.

Any insight you can offer would be appreciated.

Hi,

I have the following formula that works in Excel 2003 but doesn't work in Excel 2000. Is there something else I could use. I think it is the LEN part.

Code:


Formulas have been working but suddenly they will not add or subtract unless
we click on the target cell. This happens in all excel files even in new
worksheets.

Ok, this is kind of a big problem. I have been working on a workbook, and all of a sudden, my keyboard no longer worked in Excel. No shortcuts, no CTRL+C, no CTRL+V, no CTRL+S, no CTRL+A, no F12 to save, no letters, no numbers.... The only button that is working is my ALT key, and I use the other letter keys just fine to navigate after pressing ALT.... But that's it!

It's very strange, and a bit frustrating. I have still been able to work on it, thank goodness, because I can still write in Word, and I can still write more code in the Visual Basic window, and I can still click the buttons I create under the Developer... but it's still frustrating to not be able to type a thing in any of the cells, formula bar, or be able to use any of the shortcuts. And now when I tried to close it, I can still select everything else, and I can close this workbook, but it won't close Excel. It's acting very strange....

I'll restart my computer, and that's fine, but if anyone knows of a solution so I can better deal with it if it happens again, PLEASE let me know!

Thanks so much,

dcobia

Both enter keys have stopped working in Excel
at about the same time the tab button started jumping multiple columns when pressed, eg column A to P, fixed the tab button issue by going into Excel tools>Options menu and selecting the Transition tab and deselecting the "Transistion navigation Keys" box
but the enter keys are still not working
anyone have any ideas?

I recently switched from Excel 97 to Excel 2003.

When I open one of my spreadsheets created with Excel 97, all the the
cells in columns B display #NAME?. There is also a green triangle in
the upper left corner of each cell.

The formula in each of the cells of column B is a variation on
=QuarterNum(D642). This appears in cell B642. Column D has dates in
it, and column B has quarter numbers. The formula in cell B642 is
supposed to compute the quarter number based on the date in cell D642.

This works when I open the file with Excel 97.

How may I fix the file so it will work in Excel 2003?

Will in Seattle
a.k.a. "Clueless"

I recently switched from Excel 97 to Excel 2003.

When I open one of my spreadsheets created with Excel 97, all the the
cells in columns B display #NAME?. There is also a green triangle in
the upper left corner of each cell.

The formula in each of the cells of column B is a variation on
=QuarterNum(D642). This appears in cell B642. Column D has dates in
it, and column B has quarter numbers. The formula in cell B642 is
supposed to compute the quarter number based on the date in cell D642.

This works when I open the file with Excel 97.

How may I fix the file so it will work in Excel 2003?

Will in Seattle
a.k.a. "Clueless"

Is there a feature that switches Right-Clicking on and off?

Right-Click has suddenly stopped working in Excel 07 although works fine in
other Office 07 programs.

How do I get it to operate again?

i have an excel file that the formulas, very simple addition, have stopped
working. when i re-enter new formulas, they do not change when i change the
other parts.

Hi I really hope you can help me.

I work with excel every day but recentely after a spell of being away from the office all of the formulas in my main excel program have 'switched off' when I enter the data they do not calculate although the formulas are still there, the only way I know to activate them is to re-type them in and as there are over 100 sheets with these formulas it will take me ages to do this.

Any ideas how this happened? Or how I can correct it? Also how can I 'lock' my program to stop other people from using it while I am away?

Thank you, Dawn

Can someone help me figure out why this macro works in Excel 2003 and not in Excel 2000

I developed these worksheets on my computer which has Excel 2003. They need to run on another computer that uses Excel 2000.

I'll appreciate any help I can get on this. The sooner, the better

Private Sub Workbook_Open(
' Documented: http://www.mvps.org/dmcritchie/excel/insrtrow.ht
' Insert Rows -- 1997/09/24 Mark Hill
'Dim vRows As Intege
' row selection based on active cell -- rev. 2000-09-02 David McRitchi
Cells(65536, ActiveCell.Column).End(xlUp).EntireRow.Selec
' ActiveCell.EntireRow.Select 'So you do not have to preselect entire r
vRows =

' If vRows 1 The
' vRows = Application.InputBox(prompt:=
' "How many rows do you want to add?", Title:="Add Rows",
' Default:=1, Type:=1) 'type 1 is numbe
' If vRows = False Then Exit Su
' End I

'if you just want to add cells and not entire row
'then delete ".EntireRow" in the following lin

'rev. 2001-01-17 Gary L. Brown, programming, Grouped sheet
Dim sht As Worksheet, shts() As String, i As Intege
ReDim shts(1 To Worksheets.Application.ActiveWorkbook.
Windows(1).SelectedSheets.Count
i =
For Each sht In
Application.ActiveWorkbook.Windows(1).SelectedShee t
Sheets(sht.Name).Selec
i = i +
shts(i) = sht.Nam

Selection.Resize(rowsize:=2).Rows(2).EntireRow.
Resize(rowsize:=vRows).Insert Shift:=xlDow

Selection.AutoFill Selection.Resize(
rowsize:=vRows + 1), xlFillDefaul

On Error Resume Next 'to handle no constants in range -- John McKee 2000/02/0
' to remove the non-formulas -- 1998/03/11 Bill Manvill
Selection.Offset(1).Resize(vRows).EntireRow.
SpecialCells(xlConstants).ClearContent
Next sh
Worksheets(shts).Selec

End Su

Thank

Leslie Barberi

Text to speech in Excel stopped working.
Have Sapi 4
Have lhsp
Have TTS3000
Get message when opening speech propetries that
"The requested task cannot be carried out because the necessary engine could
not be created. Please select a different engine and/or a differnt audio
device"
however there is only one engine listed in speech properties - "Microsft
English ASR Version 5 Engine"?????

Text to speech in Excel stopped working.
Have Sapi 4
Have lhsp
Have TTS3000
Get message when opening speech propetries that
"The requested task cannot be carried out because the necessary engine could
not be created. Please select a different engine and/or a differnt audio
device"
however there is only one engine listed in speech properties - "Microsft
English ASR Version 5 Engine"?????

I have a workbook with a number of sheets. The formula's in the sheets have stopped working. Also the paste links have stopped working.

I have simple formula's like =A1 + A7 and then totals of columns.

The formula's are still in the sheets (ctrl ` shows me they are there). I have to click on the cell that the formula should have changed, then click in the tool bar at the top where the formula is show, then hit return to make the change. I have to do this all over the work book, even where I have a paste link.

I do not have other work books open, and have been struggling to find why this is doing this for a number of days. I would appreciate any suggestions, or point me in the direction of any telephone help within the UK that I can get.

Many thanks for any help in advance

Edit / Move or Copy Sheet function stopped working. Tried to copy a 60
column 250 row worksheet to another workbook, ten to a new blank workbook.
Have done exactly this process with exactly this workbook to the exact same
recipient workbook in the recent past. Sheet I want to copy is the "
control" or fixed sheet. I have made some minor additions to it since last
time I copied & it worked. Sheet is protected - never mattered before.

Was able to copy a smaller sheet from the recipient workbook above to a new
workbook which would indicate size or ??? may be the hangup.

I am wanting to import data from a table in Access, which I've done, but need
the numbers to work in Excel formulae. The numbers are importing fine, but
the calculations are not happening, unless I go in to the Excel worksheet and
retype the numbers...then the formula will work...but this is redundant any
ideas how to format the data? or to prepare the data prior to importation? I
need this data to import and display without having to re-key the data.
Thanks for the insight.

The file was originally created in Excel 97. There are no macros, no vb code anywhere. There are formulas that are placed in cell "V5" and "Q5". The cell "O22" is somehow linked to these two formulas. From cell O22, if you execute the hot keys "control-D", it will execute the formula in cell "V5", and "control-I" will execute the "Q5" formula. The formulas take all of the data listed in column "R", calculates it and then displays it under column "O22" and below.

These shortcut hotkey commands do not work with Excel 2000 & 2002.

Any ideas on this one?

I want to add the total hours worked in excel that I book for the month for
example:

A B C
Start Time End Time Total
08:00 16:00 08:00
08:00 14:30 06:30
08:00 15:00 09:30
Total 00:45
It stop at 23:59 and I want it to go on like a total sum, wat formula must I
use to do my total sum calc for my time? please help

Frankie
e-mail: frankiedeconing@harmony.co.za

Hi. I have a spreadsheet with several drop down lists. The code posted below, for allowing multiple selections in one cell, works in Excel 2003 however it does not seem to work with Excel 2007. Any idea as to why?

Option Explicit

Private Sub Worksheet_Change(ByVal Target As Range)
Dim rngDV As Range
Dim oldVal As String
Dim newVal As String
If Target.Count > 1 Then GoTo exitHandler

On Error Resume Next
Set rngDV = Cells.SpecialCells(xlCellTypeAllValidation)
On Error GoTo exitHandler

If rngDV Is Nothing Then GoTo exitHandler

If Intersect(Target, rngDV) Is Nothing Then
   'do nothing
Else
  Application.EnableEvents = False
  newVal = Target.Value
  Application.Undo
  oldVal = Target.Value
  Target.Value = newVal
  If Target.Column = 3 Then
    If oldVal = "" Then
      'do nothing
      Else
      If newVal = "" Then
      'do nothing
      Else
      Target.Value = oldVal _
        & ", " & newVal
      End If
    End If
  End If
End If

exitHandler:
  Application.EnableEvents = True
End Sub


Edit / Move or Copy Sheet function stopped working. Tried to copy a 60
column 250 row worksheet to another workbook, ten to a new blank workbook.
Have done exactly this process with exactly this workbook to the exact same
recipient workbook in the recent past. Sheet I want to copy is the "
control" or fixed sheet. I have made some minor additions to it since last
time I copied & it worked. Sheet is protected - never mattered before.

Was able to copy a smaller sheet from the recipient workbook above to a new
workbook which would indicate size or ??? may be the hangup.

I have the following code in an excel 2000 spreadsheet:

Private Sub CommandButton1_Click()

For Each cell In Range("c5:H32")
cell.Interior.ColorIndex = 0
Next cell

End Sub

But it does not work in Excel 97.

Any ideas why? I get run time error 1004

Ian,

I got in excel a matrix with 25 percentages (B26:F30)
100,0,0,0,0
0,100,0,0,0
0,0,100,0,0
0,0,0,100,0
0,0,0,0,100
and in a row 5 times a value of 100% (F6:F10).
I need as output the value 125.

Originally this value was found with the following excel formula

=MMULT(MMULT(TRANSPOSE(F6:F10),MINVERSE(B26:F30)),F6:F10)

But when I try this in excel 2007 I get no value error. I think some adjustments have to be made to the formula.

Thanks in advance!

Hello,

can someone help me work out a formula which will work in VB please..

Excel formula is

=SUMPRODUCT(--(A1:A1000="DA"),--(B1:B1000="A000"),D1:D1000)

Which is basically Sum all the values in range D1:D1000 if the cell in column A = "DA" and cell in column B = "A000".

Formula works fine in the spreadsheet but cannot get the equivalent formula to work in VB. Here is my effort (Which returns the error "Type Mismatch")

MsgBox _
Application.WorksheetFunction. _
SumProduct(--(Range("A1:A1000") = "DA"), --(Range("B1:B1000") = "A000"),
Range("D1:D1000"))
Any help would be greatly appreciated.

John


No luck finding an answer? You could always try Google.