Excel displays upside down
10/12/20 Filed in: Microsoft Office
Excel spreadsheets open upside down and how to fix?
___________
Definitely a very rare and bizarre problem but not unheard of. As you've probably discovered, scrolling to the bottom of the spreadsheet then back up usually forces a correct redraw of the data but that is only temporary. To try to solve this for good, first thing you want to do is make sure you have the latest version of Office.
To update Office to the latest version, first open either Word, Powerpoint, or Excel then, under the Menu bar, select "check for updates". For the super geeky, you can find the updater at Library/Application Support/Microsoft/MAU2.0/Microsoft AutoUpdate
Once the Updater App launches, be sure to check the box in the bottom left to just keep Office up to date automatically.
To make matters more complicated, Apple is in the middle of a transition to the new M1 chip which means all applications have to be re written specifically for that chip. Office has not yet released an M1 version so that means it's running via a translator called "Rosetta 2". It's invisible to you but important to know just in case the upside down issue is related. Doubtful it is because the upside down issue existed prior to the M1 chip being released. Just worth mentioning.
If neither of these things works then the next thing to try would be to remove some of the cache files associated to Office. Depending on your level of ability it may be better to have me remove those. Run the updates first and if you still need assistance, I can remote in via Zoom of course.
___________
Definitely a very rare and bizarre problem but not unheard of. As you've probably discovered, scrolling to the bottom of the spreadsheet then back up usually forces a correct redraw of the data but that is only temporary. To try to solve this for good, first thing you want to do is make sure you have the latest version of Office.
To update Office to the latest version, first open either Word, Powerpoint, or Excel then, under the Menu bar, select "check for updates". For the super geeky, you can find the updater at Library/Application Support/Microsoft/MAU2.0/Microsoft AutoUpdate
Once the Updater App launches, be sure to check the box in the bottom left to just keep Office up to date automatically.
To make matters more complicated, Apple is in the middle of a transition to the new M1 chip which means all applications have to be re written specifically for that chip. Office has not yet released an M1 version so that means it's running via a translator called "Rosetta 2". It's invisible to you but important to know just in case the upside down issue is related. Doubtful it is because the upside down issue existed prior to the M1 chip being released. Just worth mentioning.
If neither of these things works then the next thing to try would be to remove some of the cache files associated to Office. Depending on your level of ability it may be better to have me remove those. Run the updates first and if you still need assistance, I can remote in via Zoom of course.
Sells Consulting email