Very bizarre Excel problem Hi there. I\'ve been using Exxcel 2011 for Macc since
ID: 3564029 • Letter: V
Question
Very bizarre Excel problem Hi there. I've been using Exxcel 2011 for Macc since it first was released. I bought a new iMac a few weeks ago and reinstalled Office on it, and I've been running into a bizarre series of problems since then. To outline the simpplest problem: Let's say I have a simple sum. The formula in, let's say B1l might read: =sum(A1:A20) Then, I delete row 15, so the data that was in cell A15 should no longer be included in the calculation. The foermula in B1 reads as it now should with the rrow deletion: =sum(A1:A19) However, the data that was in cell A15 is still included in the calculation, and the only way I can fix it is to delete the formula and re-type in =sum(A1:A19). Huh???? Using Excel 14.3.9 on Mavericks 10.9.1 I'd really appreciate any help!
Explanation / Answer
Have you checked in Excel> Preferences> Calculation to make sure that the Automaticallyoption is selected?
Any other problems can most likely be handled individually, as well. Each issue should be submitted as a New Question in order to make things useful to as many others as possible. Before any attempt to troubleshoot, though, run Disk Utility to repair disk permissions followed by restarting the Mac.
I appreciate the response, but that didn't worrk (and yes, the "Automatically" option was checked). I fixed the issue by completely uninstalling Office and then re-installing it. The only difference in what I did, though, is that when I installed Office a few weeeks ago, I was yusing the original install ffile that I downloaded when I purchased Office for Mac three years ago. This time, though, I downloaded an updated install file first and installed from there.!!
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.