Help! Blank rows??

[bmiesle]

Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel I create many data tables in MS Excel for Mac 2008 files which I share with my co-workers. I specifically save the Mac Excel files as windows comma delimited files (.csv) and email to them. When my co-workers open the .csv In Windows Excel 2007 the file shows inserted blank rows between each and every row of data that's in the worksheet. Why does the conversion from Mac Excel to Windows Excel 2007 do this? How do I correct this?

 

[CyberTaz]

Well, I've tried several different methods of getting a Windows .csv
produced by Excel 2008 into Excel 2007 & can't reproduce the problem you
describe. Regardless of whether I simply Open the .csv in 2007 or use the
Get External Data - From Text method the data comes in perfectly. I've also
tried several different File Origin settings in 2007's Text Import Wizard.

Assuming your installations are fully updated on both ends there doesn't
seem like there should be a problem. How are they 'opening' the file?

My first guess is that there is an incorrect setting in the attachment
encoding specs of your email client or in the decoding being done on the
other end. Check those settings, make sure the file has the '.csv' extension
& it wouldn't hurt to zip before attaching.

Moreover, if the file is going from Excel 12 to Excel 12 why convert to .csv
in the first place? Why not just use the standard .xlsx format?

HTH |:>)
Bob Jones
[MVP] Office:Mac

 

[bmiesle]

Can I email a suspect file from my Mac using OS X Mail program?

 

[bmiesle]

I attempted the following. I opened the csv in excel 2008 ans saved. Copied the file to my Windows VM (Fusion) and opened in Excel 2007 with no blank rows - good. Then I attached the csv to my email and opened in my webmail client on my Windows VM and save it to my desktop. When I opened the file in Excel 07 on my WIndows VM the blank rows were there. So you are correct that it might be an email (encoding?) issue. Any ideas on how to solve this. I think it is on my end not the client opening my sent email.

 

[CyberTaz]

If you're using Apple's Mail app go to the Edit> Attachments menu & select
Always Send Windows-Friendly Attachments. If you're using a different email
client check its Preferences or Help files.

Also, don't forget about including the filename extension ‹ just check that
box in the Save As dialog.

Regards |:>)
Bob Jones
[MVP] Office:Mac