+ Reply to Thread
Results 1 to 23 of 23

Mirrored sheets

  1. #1
    Registered User
    Join Date
    09-18-2017
    Location
    Maarssen
    MS-Off Ver
    Office 2013 Mac
    Posts
    1

    Mirrored sheets

    Hello, I have s strange thing with my excel 2013 for Mac. Since last Friday the contents of all the sheets I open are mirrored. So upside down and from left to right.

    Excel it self is normal en word ppt note etc also. only within excel this occurs.

    I can not find a international setting for L2R or R2L and ctrl alt and up does not work

    the only thing I used last Thursday was a display adapter from DisplayPort to hdmi on a beamer but everything worked fine then. I had not installed any updates for office beyond last Wednesday

    I have completely deinstalled office cleaned afterwards and rebooted and installed office for the Mac 2013 again on the system. nothing changed, and then tested with all the updates needed, still no progress.

    my MacOS is High Sierra 10.13 public beta 9 build 17A360a on a 13 inch MacBook Pro mid 2012 with 256SSD 16Gb Ram


    I hope I have made myself clear in English because I am not a native speaker. and added all the info as well what I have done so far. The excels do work on all other systems without any problem and also on the MacBook Pro of my wive and son. Same config and OS so no Beta issue I guess.


    Schermafbeelding 2017-09-17 om 14.45.08.png

  2. #2
    Forum Expert
    Join Date
    11-26-2013
    Location
    Colac, Victoria, Australia
    MS-Off Ver
    Excel 2016
    Posts
    1,309

    Re: Mirrored sheets

    Very strange.

    Have your Country Settings been changed somehow?

  3. #3
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,396

    Re: Mirrored sheets

    Check this link. It sounds the same.

    https://exceltip2day.blogspot.com/20...n-problem.html
    Dave

  4. #4
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: Mirrored sheets

    one way:

    1.Open an Office program file, such as a Word document.
    2.On the File tab, choose Options > Language.
    3.In the Set the Office Language Preferences dialog box, in the Editing Language list, choose the Arabic dialect you want, and then choose Add.
    4.In the Choose Editing Languages table, make sure the newly added Arabic dialect is highlighted and then choose Set as Default.

    this is how to set right to left, maybe check this and remove / uncheck Arabic option

    or for more:
    type in bulb field (tell me what you want etc...) right to left phrase

  5. #5
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,899

    Re: Mirrored sheets

    I did that CTRL-ALT-UP thing by mistake once. Most odd!! It caused a lot of head-scratching and hand-standing!!

    This looks different as the Windows/Excel environment looks OK. It's just the workbook that seems to be inverted. I doubt if it's an Arabic sertting, as it's back to front as well as right to left....
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh

  6. #6
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,396

    Re: Mirrored sheets

    Quote Originally Posted by Glenn Kennedy View Post
    I did that CTRL-ALT-UP thing by mistake once. Most odd!! It caused a lot of head-scratching and hand-standing!!

    This looks different as the Windows/Excel environment looks OK. It's just the workbook that seems to be inverted. I doubt if it's an Arabic sertting, as it's back to front as well as right to left....
    Yes. I also found a setting in Display Settings > orientation (W10). But that's system wide. The link I posted only indicated Excel like OP did. Hmmm. Very odd.

    I can't get my current computer to respond to the CTRL-ALT-UP. My old one did.

  7. #7
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: Mirrored sheets

    Ctrl+Alt+Up (left side of keyboard)
    Ctrl+Alt+Up (right side of keyboard)
    Ctrl+Alt+PgUp
    Ctrl+Alt+PgUp (numeric keyboard)
    ...........................
    nothing happen

  8. #8
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: Mirrored sheets

    would be fine to see workbook not a picture

  9. #9
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,899

    Re: Mirrored sheets

    CTRL-ALT-UP is not doing anything on my laptop.... MY desktop is about 1500 km away, so I can't check it out. But, yes, a file would be nice...

  10. #10
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: Mirrored sheets

    Maybe it will be faster:
    • Program & Features
    • Microsoft Office blablabla
    • Right click and select change
    • In new window select Repair

  11. #11
    Registered User
    Join Date
    09-19-2017
    Location
    Belgium
    MS-Off Ver
    office for mac 2016
    Posts
    6

    Unhappy Re: Mirrored sheets

    Exactly the same problem here ...
    no idea what's causing this but can't solve it ...

    screen.png

  12. #12
    Registered User
    Join Date
    09-19-2017
    Location
    Belgium
    MS-Off Ver
    office for mac 2016
    Posts
    6

    Re: Mirrored sheets

    did you find a sloution yet to this problem ? I hace exactly the same issue ...

  13. #13
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,899

    Re: Mirrored sheets

    Please attach the sheet!!!!!


    Unfortunately the attachment icon doesn't work at the moment. So, to attach an Excel file you have to do the following: Just before posting, scroll down to Go Advanced and then scroll down to Manage Attachments. Now follow the instructions at the top of that screen.

  14. #14
    Registered User
    Join Date
    09-19-2017
    Location
    Belgium
    MS-Off Ver
    office for mac 2016
    Posts
    6

    Re: Mirrored sheets

    uploaded file ...
    Attached Files Attached Files

  15. #15
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: Mirrored sheets

    I don't have Arabic or Hebrew language installed and all looks correct
    in your picture version is different language.

  16. #16
    Registered User
    Join Date
    09-19-2017
    Location
    Belgium
    MS-Off Ver
    office for mac 2016
    Posts
    6

    Re: Mirrored sheets

    Neither do I, the language is set to plain english ... The same file opens correct on another mac with exactly the same software versions (Mac OSX High Sierra GM and Excel 15.39 (170915). So I don't understand what's going on. It must be a bug ...

  17. #17
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: Mirrored sheets

    Did you try fresh installation of the MS Office? or Repair option?

  18. #18
    Registered User
    Join Date
    09-19-2017
    Location
    Belgium
    MS-Off Ver
    office for mac 2016
    Posts
    6

    Re: Mirrored sheets

    yes, and on OSX there is no repair option available ...

  19. #19
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: Mirrored sheets

    run setup from your source of installation disk and you should see (maybe) this option.

    I don't know too much about Mac but maybe here you'll find something: http://www.officeformachelp.com/office/troubleshoot/
    Last edited by sandy666; 09-19-2017 at 02:45 PM.

  20. #20
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,899

    Re: Mirrored sheets

    It looks fine to me.... So go with sandy's suggestions. It's a local setting somewhere..

  21. #21
    Registered User
    Join Date
    09-19-2017
    Location
    Belgium
    MS-Off Ver
    office for mac 2016
    Posts
    6

    Re: Mirrored sheets

    OK, apparently it IS a bug in the latest version of the Office Insider Fast updates. When I reinstall and choose the Office insider slow updates, the problem dissapears ...
    So version 15.38.0 does work, 15.39.0 doesn't.

    to reinstall:

    first drag the microsoft excel app to the trash, then reinstall the excel pkg ...

  22. #22
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: Mirrored sheets

    Quote Originally Posted by edd-- View Post
    to reinstall:
    first drag the microsoft excel app to the trash, then reinstall the excel pkg ...
    this is not my melody

  23. #23
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,899

    Re: Mirrored sheets

    Old timers like me on 2010/2013 are OK then... Wooo Hooo!!

    At least you got sorted.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. VBA for Multiple Two Way Mirrored Cells
    By shp025 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-08-2017, 11:50 AM
  2. Two-way mirrored cells question
    By jdeviant in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-10-2016, 09:05 PM
  3. Linked/mirrored Data Validation
    By mcayea in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 03-12-2014, 01:09 PM
  4. Mirrored cells
    By Aivaras in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-15-2013, 04:33 AM
  5. Creating a new row beneath the relevant row with mirrored data except for last few..
    By rastafasta in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-04-2012, 11:48 PM
  6. Building a mirrored notification sheet?
    By Bscott05 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-18-2010, 08:36 PM
  7. mirrored array/matrix
    By hierarchii in forum Excel General
    Replies: 3
    Last Post: 08-05-2005, 06:05 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1