permanent

I have a workbook where whenever I click save the graphs disappear but when i close and open the file again they are there again. I have read up on it and there are workarounds but I would like a permanent fix. Anyone know a way around this...

Hello, I'm working on a primitive inventory sheet and came across this: https://www.mrexcel.com/forum/excel-questions/141057-negative-value-pop-up-warning.html From here: Private Sub Worksheet_Calculate() For Each cell In Range("B5:B16") If cell.Value < 0 Then MsgBox ("Warning: Negative...

This is a new behavior I can't explain. I have no macros (that I am aware of), no add-ons, and am using workbooks that I've had for months. I often test changes to data or formulas to see what might happen then close the file without saving so no permanent changes are made. Now, when I...

Is there a way to establish a "party line" of cells, all connected with formulae that cannot be over-written? In other words, is there a way to establish a circular reference of formulae that cannot be broken by changing one of the cells in the circular reference from a formula to a value? In...