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?
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?
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
Click the * below on any post that helped you.
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?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks