Excel Issue After Update to MacOS Mojave

Question

Level 1

8 points

Excel Issue After Update to MacOS Mojave

I upgraded to Mojave two days ago, and when using MS Excel today I ran into a snag.

When I copy down a formula, it also copies down the result from the original cell. The cell references are not unchangeable (e.g. $A$1, but A1). I have to click in each cell with the formula to have it update to the actual calculated result.

Does anyone else have this experience, and is there a fix/workaround? I did not experience this problem before the update and I use Excel nearly every day.

Thanks.

MacBook Pro (Retina, 15-inch, Mid 2015), macOS Mojave (10.14.1)

Posted on Nov 11, 2018 10:58 AM

Reply

Answer 1

Airwin33 Author

Level 1

8 points

Nov 12, 2018 10:14 AM in response to mefromwestsussex

I had to upgrade to version 2016 earlier this year, because I couldn’t perform the functions I needed to do for one of my college classes. Unfortunately, even after the update there are still many functions Excel can’t do. As it turns out, my Googling revealed the issue you mention, so I would have had to upgrade anyway (even MS stopped supporting 2011 last year). It is my understanding that no 32-bit applications are supported with Mojave. Easy to double-check in the “about Apple” area.

Reply

Answer 2

Airwin33 Author

Level 1

8 points

Nov 11, 2018 12:20 PM in response to BobTheFisherman

Thanks for the link. This solution did not come up when I did a search. I just verified that the Office updates fixed the problem.

Reply

Answer 3

Nov 12, 2018 1:19 AM in response to Airwin33

Hi Airwin33 - my Office didn't work at all under Mojave (it was 2011!) and I've had to upgrade. I've gone the 365 route but think 2016 is fine. 365 resets all my carefully ordered column widths in Excel but that's a MS problem not Apple.

Reply

Answer 4

Nov 11, 2018 11:33 AM in response to Airwin33

Microsoft Office support for macOS 10.14 Mojave - Office Support

Microsoft Community

Reply

Excel Issue After Update to MacOS Mojave

Similar questions