Hi there. I\'ve been using Excel 2011 for Mac since it first was released. I bou

Question

Hi there. I've been using Excel 2011 for Mac 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 simplest 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 formula in B1 reads as it now should with the row 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 obn Maverickss 10.9.1

I'd really appreciate any help!!!!

Explanation / Answer

Have you checked in Excel> Preferences> Calculation to make sure that the Automatically option is selected?

Any other problems can mostt likely be handled individually, as well. Each issue should be submitted as a New Questtion in order to make thingss useful to as many others as possible. Before any attempt to troublesshoot, though, run Disk Utility to repair disk permissions followed by restarting the Mac.

Related Questions

Navigate

• Browse (All)
• Browse H
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.