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

repaired then reinstalled my Office 2003 but to no avail. Please can anyone

help?

Thanks Jude

- WHY DO FORMULAS STOP WORKING IN EXCEL
- Formulas has stopped working
- Formula doesn't work in Excel 2000
- Formulas do not work in excel.
- Keyboard stopped working in Excel
- Enter Keys Stopped Working Only In Excel
- Excel 97 formula doesn't work in Excel 2003
- Excel 97 formula doesn't work in Excel 2003
- Right-Click not working in Excel 2007. Works in other Office 07 pr
- Why do formulas stop working in an excel file?
- Formulas have stopped working
- Macro working in Excel 2003; not working in Excel 2000
- Text to speech stopped working in excel
- Text to speech stopped working in excel
- Help needed - Formula's stopped working.
- Edit / Move or copy sheet stopped working in Excel 2003
- How do I format data from access to work in excel calculations?
- Excel 97 formula unable to work in Excel 2002
- Sum total hours worked in excel
- Code for Multiple Selection Drop Down Works in Excel 03 but not 07
- Edit / Move or copy sheet stopped working in Excel 2003
- Cell.interior.colorindex - does not work in Excel 97
- Excel 97 formula doesn't work in Excel 2007
- Formula works in Excel but not VB

the formulas just stopped working. I can re-enter the formula, but it will

not calculate?

Any insight you can offer would be appreciated.

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:

we click on the target cell. This happens in all excel files even in new

worksheets.

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

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?

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"

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"

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?

working. when i re-enter new formulas, they do not change when i change the

other parts.

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

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

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"?????

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 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

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.

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.

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

Any ideas on this one?

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

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

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.

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,

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!

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.