+ Reply to Thread
Results 1 to 2 of 2

Column Widths Display differently on different computers

Hybrid View

  1. #1
    Registered User
    Join Date
    06-17-2013
    Location
    NC
    MS-Off Ver
    Excel 2007
    Posts
    1

    Column Widths Display differently on different computers

    Scenario: Two computers running Windows 7 (64-bit Professional) with Excel 2007, same processor, same hard drive, same memory, same everything except the monitors - see below
    Computer 1: HP LA2006x monitor (20" viewable diagonal) @ 1600x900 resolution, 91.79 PPI
    Computer 2: HP LA2206x monitor (21.5" viewable diagonal) @ 1920x1080 resolution, 102.46 PPI

    We have an Excel spreadsheet that the column widths on columns A through K must equal exactly 6, 1, 6, 1, 8, 1, 13, 2, 8, 1, and 35 respectively in order for the data to be imported into another program. These exact column widths are set on Computer 1 and the .xslx file is saved to a network location.

    Computer 2 opens the .xslx file from the exact same network location. The column widths display as 5.86, 0.92, 5.86, 0.92, 12.84; not the exact columns listed above. So if anyone needs to export the data from Computer 2, they have to manually adjust the column widths or run a macro to auto adjust the column widths.

    My question, is there anything I can do on Computer 1 or Computer 2 to make it so the column widths are saved and open correctly no matter which one is saving and which one is opening? The 20" monitor on computer 1 cannot display the 1920x1080 resolution... already tried that.

    I found this article on Microsoft's website that describes how column widths are determined, but this doesn't help me when everything is the same except for the monitor size and as a result the screen resolution:

    http://support.microsoft.com/kb/214123

  2. #2
    Registered User
    Join Date
    01-26-2017
    Location
    Stafford
    MS-Off Ver
    2013
    Posts
    1

    Re: Column Widths Display differently on different computers

    Where you ever able to get a resolution to this issue? I'm having this issues with various computers all running Excel 2013.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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