I’m building a spreadsheet that contains formulas. So far, I have formulas that use the built-in SUM function, i.e.: “=SUM(C5:C20)”, and other formulas that multiply the values in two cells together, i.e.: “=(C5*E5)”. The spreadsheet gets generated, and all the values showing up look correct. I’m able to select cells (with the mouse pointer or the arrow keys) that have a value or contain a formula utilizing the SUM function. However, when I try to select a cell that has a formula utilizing multiplication, I get an “EXCEL.EXE Application Error” dialog box with the following message:
The instruction at “0x3008a214” referenced memory at “0xd05bbfc8”. The memory could not be “read”.
I get this error consistently. I’ve even saved the web-generated Excel file offline, and opened it offline, and get the same error message.
What might be wrong?
P.S.: Here’s a code snippet that shows how I’m populating the cells with values and formulas:
'Populate the Merch Stands section of the report
For i As Int16 = 0 To dtMerchStands.Rows.Count - 1
For j As Int16 = 0 To dtMerchStands.Columns.Count - 1
Select Case j
Case 2, 4, 5, 6, 7
newCells(currentRow, j).Style = styleDecimal
Case Else
newCells(currentRow, j).Style = styleDefault
End Select
newCells(currentRow,
j).PutValue(dtMerchStands.Rows(i)(j))
formula = “=(C” & (currentRow + 1) & “*E” & (currentRow + 1) & “)”
newCells(currentRow, 9).Style = styleDecimal
newCells(currentRow, 9).Formula = formula
formula = “=(C” & (currentRow + 1) & “*F” & (currentRow + 1) & “)”
newCells(currentRow, 10).Style = styleDecimal
newCells(currentRow, 10).Formula = formula
formula = “=(C” & (currentRow + 1) & “*G” & (currentRow + 1) & “)”
newCells(currentRow, 11).Style = styleDecimal
newCells(currentRow, 11).Formula = formula
formula = “=(C” & (currentRow + 1) & “*H” & (currentRow + 1) & “)”
newCells(currentRow, 12).Style = styleDecimal
newCells(currentRow, 12).Formula = formula
Next
currentRow += 1
Next
'Insert Merch Stands section summary items
formula = “=SUM(C5:C” & (currentRow - 1) & “)”
newCells(currentRow, 2).Style = styleDecimal
newCells(currentRow, 2).Formula = formula
formula = “=SUM(J5:J” & (currentRow - 1) & “)”
newCells(currentRow, 9).Style = styleDecimal
newCells(currentRow, 9).Formula = formula
formula = “=SUM(K5:K” & (currentRow - 1) & “)”
newCells(currentRow, 10).Style = styleDecimal
newCells(currentRow, 10).Formula = formula
formula = “=SUM(L5:L” & (currentRow - 1) & “)”
newCells(currentRow, 11).Style = styleDecimal
newCells(currentRow, 11).Formula = formula
formula = “=SUM(M5:M” & (currentRow - 1) & “)”
newCells(currentRow, 12).Style = styleDecimal
newCells(currentRow, 12).Formula = formula
'Push the workbook down to the client
newExcel.Save(“CompartmentBasis.xls”,
SaveType.OpenInBrowser, FileFormatType.Excel2000, Response)