My Excel spreadsheets are upside down need help.

Discussion in 'Technical Corner' started by ebetancourt, Dec 13, 2019.

  1. ebetancourt

    ebetancourt Line Up and Wait

    Joined:
    Feb 12, 2010
    Messages:
    572
    Location:
    Middle Tennessee
    Display Name:

    Display name:
    Ernie
    So... I upgraded my Mac OS. Everything seemed fine, then I tried to create a new Excel spreadsheet. The text is upside down! Beyond that the lines are in groups bottom to top. Typing in a cell doesn’t mean that’s where it will stay where you put. other incomprehensible behavior.

    My old spreadsheets print normally though.

    is Microsoft trying to tell me my installed apps need to be upgraded to the cloud? Is there a switch I’m missing?
     
  2. SixPapaCharlie

    SixPapaCharlie May the force be with you

    Joined:
    Aug 8, 2013
    Messages:
    14,569
    Display Name:

    Display name:
    6PC
    Flip the monitor
     
    Tantalum and bflynn like this.
  3. AggieMike88

    AggieMike88 Touchdown! Greaser! PoA Supporter

    Joined:
    Jan 13, 2010
    Messages:
    18,981
    Location:
    Denton, TX
    Display Name:

    Display name:
    The original "I don't know it all" of aviation.
    Can you provide a screen shot of what you are seeing?
     
  4. IK04

    IK04 Pattern Altitude

    Joined:
    Nov 6, 2018
    Messages:
    2,237
    Location:
    Copperas Cove, Texas
    Display Name:

    Display name:
    LNXGUY
    You have the Australian version.
     
    Tantalum and Spring Ford like this.
  5. Let'sgoflying!

    Let'sgoflying! Touchdown! Greaser! PoA Supporter

    Joined:
    Feb 23, 2005
    Messages:
    18,355
    Location:
    west Texas
    Display Name:

    Display name:
    Dave Taylor
    I just read where an update of the software fixed others’ with a similar problem (theirs was USD and backwards.)
     
  6. Skyrys62

    Skyrys62 En-Route

    Joined:
    Apr 5, 2017
    Messages:
    2,996
    Location:
    hopefully not at work
    Display Name:

    Display name:
    Meet the Fokkers
    Well if you were upside down on your loans, you just got out of debt!



    okay, not as good as playing the country music record backward...but I tried.
     
    Last edited: Dec 14, 2019
  7. Spring Ford

    Spring Ford Pre-takeoff checklist

    Joined:
    Jul 11, 2018
    Messages:
    472
    Display Name:

    Display name:
    SpringFord
  8. AggieMike88

    AggieMike88 Touchdown! Greaser! PoA Supporter

    Joined:
    Jan 13, 2010
    Messages:
    18,981
    Location:
    Denton, TX
    Display Name:

    Display name:
    The original "I don't know it all" of aviation.
    At least it's not the Slavic version.... where it uses Reverse POLISH notation
     
    Spring Ford likes this.
  9. IK04

    IK04 Pattern Altitude

    Joined:
    Nov 6, 2018
    Messages:
    2,237
    Location:
    Copperas Cove, Texas
    Display Name:

    Display name:
    LNXGUY
    That's a calculated response!
     
    Skyrys62 likes this.
  10. Morgan3820

    Morgan3820 En-Route

    Joined:
    Jun 29, 2013
    Messages:
    2,590
    Location:
    New Bern, NC
    Display Name:

    Display name:
    Reno
    I love computers
     
  11. Skyrys62

    Skyrys62 En-Route

    Joined:
    Apr 5, 2017
    Messages:
    2,996
    Location:
    hopefully not at work
    Display Name:

    Display name:
    Meet the Fokkers
    Spreadsheets are like babies.... they can be fussy as heck if they don't like the formula.
     
  12. ebetancourt

    ebetancourt Line Up and Wait

    Joined:
    Feb 12, 2010
    Messages:
    572
    Location:
    Middle Tennessee
    Display Name:

    Display name:
    Ernie
    The simple solution worked; scroll to an area of the spreadsheet with all blank cells. Apparently it has to be done for each spreadsheet though. I suspect that sooner or later I'm going to have to upgrade to the cloud version of office. I already lost use of Outlook some time ago.

    Having started three successful software companies in my weird life, I can say that in my opinion most software programmers have no concept of risk management. "If I wrote it, it will work..."

    It was mostly fun working with all of them though. Thinking about the next five to ten years in that world makes me a little sad that I am retired. What a ride it's going to be.
     
  13. flight2000

    flight2000 Pre-takeoff checklist

    Joined:
    Oct 4, 2009
    Messages:
    382
    Location:
    Richmond, VA
    Display Name:

    Display name:
    flight2000
    I simply updated Office for Mac (not to the cloud version) and my spreadsheets no longer flip upside down when I open them. Whatever Apple did during their recent upgrades really messed with MS Office. No issues since I did the updates. My current version of Excel is 16.16.16 (191111).

    Open up excel -> hit the Help tab -> Check for updates. That's the route I took to fix mine. I'm currently on Catalina 10.15.1 if that helps any.

    Cheers,
    Brian
     
  14. ebetancourt

    ebetancourt Line Up and Wait

    Joined:
    Feb 12, 2010
    Messages:
    572
    Location:
    Middle Tennessee
    Display Name:

    Display name:
    Ernie
    FWIW, I'm on C 10.15.2. I upgraded Office and now Excel works excellently. Outlook still doesn't work with Mac OS. The scrolling solution was necessary for new spreadsheets as well, so I upgraded. Hopefully it will all continue to work
     
  15. Spring Ford

    Spring Ford Pre-takeoff checklist

    Joined:
    Jul 11, 2018
    Messages:
    472
    Display Name:

    Display name:
    SpringFord
    Where do you see the fun happening? AI? Cloudiness? Mobile?
     
  16. MuseChaser

    MuseChaser Pattern Altitude

    Joined:
    Feb 23, 2019
    Messages:
    2,039
    Location:
    Central NYS
    Display Name:

    Display name:
    MuseChaser
    OpenOffice or LibreOffice.....for years. Never looked back. Reads, edits, and saves in any MS file format you wish.
     
    IK04 likes this.
  17. ebetancourt

    ebetancourt Line Up and Wait

    Joined:
    Feb 12, 2010
    Messages:
    572
    Location:
    Middle Tennessee
    Display Name:

    Display name:
    Ernie
    Add Quantum and all the biotech stuff. Electricity storage, fusion,
    The folks who combine that stuff creatively will be the heros of the future.
     
    Spring Ford likes this.