Missing Formula in Cell Again

[sdruley]

The problem with the missing formula in a cell has been haunting me for the last 2 months. I have heard of all of the possible causes but none of the solutions have helped me.
I wrote a letter to Microsoft asking that some resources be put on the issue. It would seem that you could have the best spreadsheet on the market, but formulas disappearing would be a show stopper.
Does anyone know here if this problem has been finally resolved? Your time is appreciated.

 

[RoryA]

What have you tried? What exactly do you mean by missing - is the cell left empty, or replaced by a value?

 

[sdruley]

What have you tried? What exactly do you mean by missing - is the cell left empty, or replaced by a value?

Rory, I hope you are doing well.
My operating parameters are as follows:
1) Windows 10
2) One workbook
3) Two worksheets
4) VBA to bring in data from a text file every 15seconds on sheet2

[FONT=Calibri][SIZE=3][COLOR=#000000]Sub BridgeToSheet(c00, c01, y, e)[/COLOR][/SIZE][/FONT]
[FONT=Calibri][SIZE=3][COLOR=#000000]ReDim SP(y, 4)[/COLOR][/SIZE][/FONT]
[FONT=Calibri][SIZE=3][COLOR=#000000]   Open c00 & c01 For Input As #1[/COLOR][/SIZE][/FONT]
[FONT=Calibri][SIZE=3][COLOR=#000000]     sn = Split(Input(LOF(1), 1), vbCrLf)[/COLOR][/SIZE][/FONT]
[FONT=Calibri][SIZE=3][COLOR=#000000]   Close[/COLOR][/SIZE][/FONT]
[FONT=Calibri][SIZE=3][COLOR=#000000]   For J = UBound(sn) - y To UBound(sn) - 1[/COLOR][/SIZE][/FONT]
[FONT=Calibri][SIZE=3][COLOR=#000000]     sq = Split(sn(J), ",")[/COLOR][/SIZE][/FONT]
[FONT=Calibri][SIZE=3][COLOR=#000000]      For jj = 0 To UBound(sq)[/COLOR][/SIZE][/FONT]
[FONT=Calibri][SIZE=3][COLOR=#000000]          SP(J - UBound(sn) + y, jj) = sq(jj)[/COLOR][/SIZE][/FONT]
[FONT=Calibri][SIZE=3][COLOR=#000000]      Next[/COLOR][/SIZE][/FONT]
[FONT=Calibri][SIZE=3][COLOR=#000000]   Next[/COLOR][/SIZE][/FONT]
[FONT=Calibri][SIZE=3][COLOR=#000000]   Sheets("NEWPHARAOH").Cells(1, e).Resize(y, UBound(sq) + 1) =SP[/COLOR][/SIZE][/FONT]
[FONT=Calibri][SIZE=3][COLOR=#000000]End Sub[/COLOR][/SIZE][/FONT]

5) A for next loop to
a. bring in data from the Chicago MercantileExchange on sheet 1
b. process 30 algorithms
c. cycle time = 0.78 seconds
6) In calculation automatic
7) Affected cells are formatted “General”
8) No user forms
9) No code is specific to the worksheet
What does the failure look like?
1) Confined to sheet2 and not sheet1
2) When I accidently leave one of the data cellsselected, I lose everything in the cell
3) Randomly other cells, not selected, on sheet 2will lose their formula but the static value remains
4) Occurs about every 10 minutes
Steve

 

[RoryA]

Does it happen in Safe Mode?

You refer to "the problem" as though you think it's a known bug. Do you have a basis for that? It's certainly not one I've heard of.

 

[sdruley]

<< unavailable video removed >>

I put together a video of how the formula in column B converts to a value