+ Reply to Thread
Results 1 to 2 of 2

Columns change size when emailing excel doc from one computer to another

  1. #1
    Registered User
    Join Date
    03-31-2011
    Location
    Dallas, TX
    MS-Off Ver
    Excel 2010
    Posts
    1

    Question Columns change size when emailing excel doc from one computer to another

    HI all.
    I need some help with a very bothersome problem we are having at our office. Our CFO uses MS Excel 2008 for Mac and another partner is using MS Excel 2010 for windows. When the partners opens up a spreadsheet sent from the CFO (mac), all the columns have changed in size causing the data to be displayed with #####s. This only seems to happen when the partner receives spreadsheets from the CFO (he doesn't have the problem when he gets spreadsheets from other people).

    Does anyone have suggestions on what we can do to fix this problem? Your help is greatly appreciated as this is very frustrating for the partner!!

    Thanks
    ~Jan

  2. #2
    Valued Forum Contributor jwright650's Avatar
    Join Date
    12-10-2010
    Location
    Va, USA
    MS-Off Ver
    Excel 2003, Excel 2010
    Posts
    606

    Re: Columns change size when emailing excel doc from one computer to another

    Can't use macros on a Mac...hmmm.

    Otherwise I would say that you could add this to the Worksheet's Activate event

    Please Login or Register  to view this content.
    I'm not sure how to handle a Mac OS


    Manually, you would have open the workbook, select the uppermost left corner of the spreadsheet to select the entire spreadsheet, then double click in between the column markers to autofit all columns to the correct widths in the entire spread sheet, and you can also do the samething if the rows are not all the same height.
    Life is like a roll of toilet paper. The closer it gets to the end, the faster it goes.
    John Wright

+ 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