+ Reply to Thread
Results 1 to 5 of 5

Format not staying when opening on different computer

  1. #1
    Registered User
    Join Date
    08-02-2013
    Location
    Chillliwack BC
    MS-Off Ver
    Excel 2011 Mac
    Posts
    23

    Format not staying when opening on different computer

    Hi,

    Not even sure how or what to search for this problem. But pretty simple (I hope) I have created a file on a 24" iMac, but when i open it on a smaller laptop the cell sizing is not the same and i cannot see the full cells or the numbers in it which is a pain, because i have someone else working on the file and i have it locked so they can't see the data unless i unlock the sheet which is something i don't want to do.

    I can explain more if this does not make sense

    thanks

  2. #2
    Forum Guru Olly's Avatar
    Join Date
    09-10-2013
    Location
    Darlington, UK
    MS-Off Ver
    Excel 2016, 2019, 365
    Posts
    6,249

    Re: Format not staying when opening on different computer

    Make your columns wider, so the numbers are visible at a lower zoom level / resolution.

    Or check the option to still allow column formatting, when you protect the sheet.
    let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source

    If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE

    Walking the tightrope between genius and eejit...

  3. #3
    Registered User
    Join Date
    08-02-2013
    Location
    Chillliwack BC
    MS-Off Ver
    Excel 2011 Mac
    Posts
    23

    Re: Format not staying when opening on different computer

    The numbers do not disappear when i changed the zoom on the big computer. so not sure how i would set it up to match in the small.

    Perhaps i should have said it is not keeping the formatting of the columns and rows. When i have a row that has wrapped text of 2 or more line i cannot read anything as well as the columns turn the numbers to xxxx because they are to narrow on the smaller laptop. Is there no way to have the formatting conform to the screen size??

  4. #4
    Registered User
    Join Date
    08-02-2013
    Location
    Chillliwack BC
    MS-Off Ver
    Excel 2011 Mac
    Posts
    23

    Re: Format not staying when opening on different computer

    Not to mention I have 20+ pages that are locked, with 20 workbooks to deal with so it would be a massive job to go and unlock and relock all of that

  5. #5
    Forum Guru Olly's Avatar
    Join Date
    09-10-2013
    Location
    Darlington, UK
    MS-Off Ver
    Excel 2016, 2019, 365
    Posts
    6,249

    Re: Format not staying when opening on different computer

    I've given you a method to fix it. The formatting is not changing.

+ 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. format not staying same
    By ricklyne in forum Excel General
    Replies: 5
    Last Post: 10-26-2010, 02:47 AM
  2. Hiding columns upon opening on another computer
    By simonwilliams in forum Excel General
    Replies: 3
    Last Post: 06-22-2009, 11:38 AM
  3. Problem with opening at other computer
    By kaczakicha in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-19-2009, 04:39 AM
  4. [SOLVED] Opening an excel file on another computer changes the setup on fil
    By Viviana in forum Excel General
    Replies: 3
    Last Post: 11-29-2005, 04:55 PM
  5. OPENING EXCEL FREEZES COMPUTER
    By Lindsay Graham in forum Excel General
    Replies: 5
    Last Post: 02-14-2005, 08:06 PM

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