Forum Discussion
Excel adding
- Just check your calculation is set to automatic. Via The formulas tab
I cannot tell you how much I appreciate your quick helpful response. It was direct and solved my issue which kept me awake last night. How the setting got changed, I have no clue, but your information was spot on! Again, thank you so much!!
Neal
- You’re welcome Bruce, sometimes it can get turned off by opening a file and running a macro that isn’t set up quite right, or a crash triggered by an addin.
Totally get that and it certainly is a possibility in this case. Really appreciate your help. I have a number of semi-serious sheets that would be hard to lose the functionality on. I realized it was global to excel so restoring a saved file would not help. Thanks again. Stress level dropped immediately!!
By the way, just curious, have you ever seen a large spreadsheet suddenly get a large gap in the lines, as if a line was enlarged 50-to 100 times its normal one line height size? This is rare. It is always blank and the lines below it are always there and any formula still works. Trying to manually resize it does not always work nor does deleting it, though one of the two generally works eventually. No big deal or panic as it has yet to cause a permanent issue. Just wondering...
Thanks again so much!!
Neal
