+ Reply to Thread
Results 1 to 5 of 5

Column Width Not Staying Adjusted

  1. #1
    Registered User
    Join Date
    10-01-2014
    Location
    United States
    MS-Off Ver
    2007, 2010
    Posts
    5

    Column Width Not Staying Adjusted

    When I open the Excel file on a new computer, not all of the column width adjustments are transferring. How do I fix this?

  2. #2
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,448

    Re: Column Width Not Staying Adjusted

    You could record a macro to set the column widths.

    Simplest way is to start the macro recorder and record a macro using the name "Auto_Open"

    then record yourself setting the column widths.

    Stop the recorder.

    The macro will run when the workbook is opened and will reset the widths.

  3. #3
    Forum Expert Whizbang's Avatar
    Join Date
    08-05-2009
    Location
    Greenville, NH
    MS-Off Ver
    2010
    Posts
    1,395

    Re: Column Width Not Staying Adjusted

    Do you have a pivot table or some other data connection or active content? Pivot Tables have an option to auto adjust column widths.

    How are you setting the column widths?

  4. #4
    Registered User
    Join Date
    10-01-2014
    Location
    United States
    MS-Off Ver
    2007, 2010
    Posts
    5

    Re: Column Width Not Staying Adjusted

    I'm setting them by dragging them.

  5. #5
    Forum Expert Whizbang's Avatar
    Join Date
    08-05-2009
    Location
    Greenville, NH
    MS-Off Ver
    2010
    Posts
    1,395

    Re: Column Width Not Staying Adjusted

    Are you emailing the file to the other terminal?

    I've noticed when opening a file from Outlook, it will sometimes open a cached/temp version of the file rather than the updated version. If you are opening it from Outlook, try saving it to the desktop or some other location and open it from there.

+ 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. Replies: 2
    Last Post: 07-30-2014, 11:13 AM
  2. How to move to specified column staying on same row
    By Launchnet in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 06-02-2010, 06:44 PM
  3. [SOLVED] Set Column Width Based On Total Width Of Other Columns
    By rayneraingoaway in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-28-2006, 06:10 PM
  4. Replies: 1
    Last Post: 12-05-2005, 12:00 PM
  5. wrap text/row width adjusted - no text
    By Julianne in forum Excel General
    Replies: 1
    Last Post: 05-21-2005, 11:07 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