Hello Excel experts!

I'm reaching my limits at this point:


I received a table in which the 1st row is fixed (ok) and has content in cells.

However, when I try to change the content in one of the cells in line 1 (m1),
will either be 0 instead of the content of a reference,
or the old content again (here the text: "column 1")
shown.

I tried to insert an empty cell from another folder, no success.

I turned off in the options: options > forms > use table names in formula

doesn't help either.

What makes the cell so resistant?

i atached the sheet with cell m1

Thanks for any help or direction, where this behaviour is defined for the cell !

stan

Attached Files

240828-zelle m1 nicht löschbar.xls (87.5 KB, 8 views)