10
Excel verliert die Formel, behält aber den Wert
Hallo zusammen,
eine Kollegin hat das Problem, dass sie in einer Datei (kein generelles Problem) Zellen hat, die eigentlich durch eine Formel berechnet werden.
Wenn sie nach dem Drücken auf "Enter" wieder in die Zelle geht, wird nur noch das Ergebnis angezeigt und nicht mehr die Formel.
Der Wert ersetzt also die Formel.
Gibt es eine Option für die Dateien?
eine Kollegin hat das Problem, dass sie in einer Datei (kein generelles Problem) Zellen hat, die eigentlich durch eine Formel berechnet werden.
Wenn sie nach dem Drücken auf "Enter" wieder in die Zelle geht, wird nur noch das Ergebnis angezeigt und nicht mehr die Formel.
Der Wert ersetzt also die Formel.
Gibt es eine Option für die Dateien?
Share on Facebook
Share on Twitter
Share on Reddit
Share on LinkedinPlease also mark the comments that contributed to the solution of the article
Content-Key: 315219
Url: https://administrator.de/contentid/315219
Printed on: April 25, 2024 at 16:04 o'clock
10 Comments
Latest comment
Hi,
is this a macro sheet ? If yes, check all macros in the worksheet code areas if VBA code is replacing the formulas with it's result.
Regards
is this a macro sheet ? If yes, check all macros in the worksheet code areas if VBA code is replacing the formulas with it's result.
Regards
Thank you for that advice. How can I easiely see if there is a macro?
If your file has no *.xlsm** extension you have no macros. If it's *.xlsm then press
ALT-F11 to open the VBA editor and double click on the names of the tables and the modules on the left side to see if there are macros that autostart if something is changed in a sheet.
There are no macros!
Also check if other template projects are visible in the VBA editor, and make sure all addins are disabled (start Excel in safe mode for a test).
No template projects or addins
Create a new windows userprofile and test.
There is no problem with a different windows userprofile.
But I still did NOT test it with the same user, I only checked if my userprofile also got this problem.
But I still did NOT test it with the same user, I only checked if my userprofile also got this problem.
You're confusing me, does this problem only exist in one specific file or all files of this user?
I don't know an option which replaces formulas with it's result, perhaps the file has some restriction applied to it.
I don't know an option which replaces formulas with it's result, perhaps the file has some restriction applied to it.
I just checked the file with a different user on a different computer. I will check it witch a different user on the original computer and see what will happen.
