+ Reply to Thread
Results 1 to 3 of 3

Emailing a spreadsheet changes the formatting

  1. #1
    Registered User
    Join Date
    08-20-2014
    Location
    Midland, TX
    MS-Off Ver
    2011 for Mac
    Posts
    2

    Emailing a spreadsheet changes the formatting

    When I attach a 1 page spreadsheet to an email and send it to my boss, the spreadsheet is no longer on one page when he opens it. What causes this and how can I fix it on my end or fix it from his end to keep the same format?

  2. #2
    Valued Forum Contributor
    Join Date
    01-19-2012
    Location
    Barrington, IL
    MS-Off Ver
    Excel 2007/2010
    Posts
    1,211

    Re: Emailing a spreadsheet changes the formatting

    If one of you is using Excel 2007 or newer, and the other is using Excel 2002 or older, that would do it.

    Excel changed dramatically between version 2002 and 2007, a lot of new features, functions, and formats

    For example, if your sheet has more than 16.5k Rows, it won't fit on a single Excel 2002 sheet.
    You should hit F5, because chances are I've edited this post at least 5 times.
    Example of Array Formulas
    Quote Originally Posted by Jacc View Post
    Sorry, your description makes no sense. I just made some formula that looks interesting cause I had nothing else to do.
    Click the * below on any post that helped you.

  3. #3
    Registered User
    Join Date
    08-20-2014
    Location
    Midland, TX
    MS-Off Ver
    2011 for Mac
    Posts
    2

    Re: Emailing a spreadsheet changes the formatting

    Thanks, Speshul, for the reply. I believe my boss does have 2007 or newer version of Excel, and I have Office 2011 for Mac. He does still use AOL for his email and I use Yahoo (via Outlook). I have tried saving my spreadsheets in the XLS and the XLSX format. Neither seem to fix the problem and the XLSX format caused more problems. My spreadsheets are usually very small (500 rows or less). Does any of this information help in determining the problem?

+ 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. Emailing Spreadsheet
    By Stuie in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-14-2007, 03:49 PM
  2. [SOLVED] Emailing a spreadsheet
    By Chip Smith in forum Excel General
    Replies: 1
    Last Post: 06-07-2006, 03:00 PM
  3. emailing a whole spreadsheet
    By AmyTaylor in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 02-17-2006, 07:25 AM
  4. Emailing a form from a spreadsheet
    By daiblackburn in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-07-2005, 05:05 AM
  5. VBA for emailing spreadsheet
    By wutango in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-17-2005, 05:53 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