Results 1 to 7 of 7
  1. #1
    2 Star Lounger
    Join Date
    Apr 2004
    Location
    Jacksonville, Florida, USA
    Posts
    117
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I'm working on Excel 2003 (go ahead and laugh) in the office. I need to email large spreadsheets (not the entire workbook) around the country. I know of the truncation problem when there are more than 255 characters in a single cell, but I'm having all sorts of things truncate, even when the character count is below 255. I've clicked on the tab and copied that way, and I've tried copying the entire spreadsheet into another instance of Excel and sending that as an email attachment, but I still get inconsistent results. Is there a foolproof method for emailing (using a similar vintage Outlook) large (say 100 rows, 15 columns) spreadsheets reliably? Thanks in advance.

  2. #2
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,823
    Thanks
    135
    Thanked 482 Times in 459 Posts
    What about first making a copy of the workbook, then deleting any irrelevant sheets, rows and columns etc from the copied workbook, and then sending that.

    It would get rid of any truncate issues.

    zeddy

  3. #3
    5 Star Lounger
    Join Date
    Dec 2009
    Location
    East Coast, USA
    Posts
    993
    Thanks
    8
    Thanked 43 Times in 43 Posts
    How about copying the sheet into a blank workbook, then Zip it and send it?

  4. #4
    New Lounger
    Join Date
    Dec 2009
    Location
    Wilmington, DE, USA
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts
    To avoid truncation, first create a blank workbook with the number of worksheets you need. Then go to the source worksheet, Select the sheets you want to copy. Do this by holding down the control key and clicking on the sheet tabs. If you want all sheets, right click and select all sheets. Then select all cells on the first sheet by clicking on the box immediately above the row 1 label and left of the column A label. Do a copy. Then go to the first sheet in the destination workbook and click on column A. No need to select sheets. Now do a paste. The paste will be done and multiple sheets selected. Right click on the sheet tab and select ungroup.

    If you are copying charts, the chart references will be back to the original workbook. Save the destination workbook. Then do edit links, select the source workbook and change links to the destination workbook.

    Bob Flanagan
    www.add-ins.com

  5. #5
    New Lounger
    Join Date
    Jun 2010
    Location
    Damascus, MD, USA
    Posts
    9
    Thanks
    1
    Thanked 2 Times in 2 Posts
    I'm not laughing--I use Office 2000.

    I suggest you copy the entire file first. In Windows Explorer or equivalent, you can Ctrl-C and Ctrl-V, or you can Ctrl-drag (even within the same folder).

    Next, open the new file, edit it down to just what you wish to send, and save and close it. You may choose to break external links while editing it.

    Then, ZIP the new file using WinZIP or one of its free alternatives (I've been using jZIP for a long time), adding a password if you wish.

    Finally, send the ZIPped file and, separately, communicate any password to the recipients.

  6. #6
    New Lounger
    Join Date
    Jul 2010
    Location
    Richardson, TX
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Try using LargeFilesASAP.com
    Free service for single file transfer. You upload the file and the recipient's email. LargeFiles sends an email to the recipient telling them where the file is located on the Internet.

  7. #7
    New Lounger
    Join Date
    Dec 2009
    Location
    Hollywood, CA 90068 USA
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts
    www.YouSendIt.com also allows you to send up to 100mb files.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •