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)

Turn off FILTERING. Right Click ... Delete ... Table Columns.

thanx, did it.

"spalte1" is gone.

but then,
when i place a formula "=l5" (where a simple value is enetered) in this cell,

the result = 0, not the value of l5,

and then , when i delete the formula, "spalte1" appears again there....

i just do not understand this feature..,..

stan

I believe your workbook may have created some type unseen error or corruption.

I copied row one into a new, clean workbook and things seem to work fine.

???

Cell M1 is a column header of a table (a proper Excel Table (called Tabelle1 in your file)). You're not allowed to use formulae in the header of such a table. Each header of such a table must contain something (cannot be blank). If it is blank, Excel assigns a name to it; Spalte1 in german, Column1 for an english locale. Try to delete any other column header and you'll get Spalte2 etc. Right-clicking the header (or any cell in a table column) and choosing Delete|Table Columns deletes the table column (cells to the right move to the left) and column M is no longer part of the table, so you can put what you like in M1.

I have no idea why, when you try to put a reference to another cell (eg. =W5) it returns plain value 0 (even if there is something else in W5). I can understand it removing the formula, but not why it puts in a 0 (if you try and do that again with another header it puts in 02 etc.).

If your .xls file uses macros you could write a macro to change the headers automatically.

just aying thanx to everyone.

the solutiON AT LEAST WAS CONVERTING THETABLE FROM A NEW FORMAT TO STANDRD SHEET (context)

stan

Please mark thread closed ( see Thread Tools). Thx

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post