E-mailing large Excel spreadsheets

Topic

New Reply

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.

Reply | Quote

Replies

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

Reply | Quote

How about copying the sheet into a blank workbook, then Zip it and send it?

Reply | Quote

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
http://www.add-ins.com

Reply | Quote

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.

Reply | Quote

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.

Reply | Quote

http://www.YouSendIt.com also allows you to send up to 100mb files.

Reply | Quote