Need Help With EXCEL Save As CSV

[stepheneng]

I am probably doing something stupid, but, when I try to save a
Worksheet to CSV, I get messages saying that i can only save one page,
then one which says some features won't be saved... I go through those,
and a new Worksheet icon appears on the desktop with the .csv suffix.

BUT, when I re-open the Worksheet, the Worksheet does NOT appear in CSV
format: it reverts to the columns and rows format like a regular
worksheet.

Oddly enough, when I look at it through the View menu on MacLink, there
is appears in comma-separated format.

Can anybody tell me what I am doing wrong in saving?????

 

[CyberTaz]

It sounds like you're doing nothing wrong - nor is the software. One of the
aspects of a CSV is that Excel can reopen the file as though it were a
standard .xls so you can edit & save changes to it using Excel. If you open
the file in a text editor it will open in the comma-delimited appearance.

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

 

[Paul Berkowitz]

I am probably doing something stupid, but, when I try to save a
Worksheet to CSV, I get messages saying that i can only save one page,
then one which says some features won't be saved... I go through those,
and a new Worksheet icon appears on the desktop with the .csv suffix.

BUT, when I re-open the Worksheet, the Worksheet does NOT appear in CSV
format: it reverts to the columns and rows format like a regular
worksheet.

Oddly enough, when I look at it through the View menu on MacLink, there
is appears in comma-separated format.

Can anybody tell me what I am doing wrong in saving?????

You're not doing anything wrong. That's how Excel displays CSV files - which
are actually text files. If you want them displayed as text, with commas,
open them in a text editor.

Drag the .csv file onto TextEdit and you'll see it displayed how you wish.

--
Paul Berkowitz
MVP MacOffice
Entourage FAQ Page: <http://www.entourage.mvps.org/faq/index.html>
AppleScripts for Entourage: <http://macscripter.net/scriptbuilders/>

Please "Reply To Newsgroup" to reply to this message. Emails will be
ignored.

PLEASE always state which version of Microsoft Office you are using -
**2004**, X or 2001. It's often impossible to answer your questions
otherwise.