+ Reply to Thread
Results 1 to 2 of 2

Formatting changes when opening spreadsheet on other computer

Hybrid View

  1. #1
    Registered User
    Join Date
    03-27-2019
    Location
    Canada
    MS-Off Ver
    2016
    Posts
    1

    Formatting changes when opening spreadsheet on other computer

    Situation:

    1. There are 3 of us in our office.
    2. We all use Window 10.
    3. Two have Office 365 licences, I have a Office 2016 Small Business license.
    4. Our master spreadsheets use specific column widths and line heights.

    Problems:

    1. One of the people with Office 365 has the following problem since March 19, 2019: his Excel 2016 does not seem to recognize all cells formatted as "Number, 2 decimals, negative numbers in parentheses and in red, with separator for thousand". These cells appear in the personalized model (# ##0,00_);[Red](# ##0,00).

    2. Some column widths and line heights seem to change willy nilly from one computer to another. We wish them to remain as saved and not be modified every time spreadsheets are opened on a different computer.

    I thank you for any insights you could bring on these very frustrating problems.

  2. #2
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,266

    Re: Formatting changes when opening spreadsheet on other computer

    Hi rcousineau and welcome to the forum,

    Microsoft has been changing the features with shared workbooks lately. I don't believe the old version will support this new change. Read about it at:
    https://support.office.com/en-us/art...1-6C259303FE05

    If this doesn't help then keep asking and someone here will have a better suggestion.
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

+ 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. Macro opening new workbooks only on one computer!
    By NatalieEC in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-27-2015, 12:17 AM
  2. Format not staying when opening on different computer
    By doran79 in forum Excel General
    Replies: 4
    Last Post: 03-06-2014, 08:37 PM
  3. Macro to not allow opening of file only on certain computer if it is already opened
    By Repent34 in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 04-04-2011, 05:41 PM
  4. Hiding columns upon opening on another computer
    By simonwilliams in forum Excel General
    Replies: 3
    Last Post: 06-22-2009, 11:38 AM
  5. Problem with opening at other computer
    By kaczakicha in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-19-2009, 04:39 AM
  6. [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
  7. OPENING EXCEL FREEZES COMPUTER
    By Lindsay Graham in forum Excel General
    Replies: 5
    Last Post: 02-14-2005, 08:06 PM

Tags for this Thread

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