.csv Format, Hidden Columns, 2007
 

In 2003 Excel, I could hide columns in a worksheet, save the worksheet as a
.csv and the hidden columns/data did not convert to the .csv file (which is
what I want). In 2007 Excel, I have hidden columns and save the worksheet as
a .csv and the hidden columns/data get converted over, too. Is there
something I can do about this? I don't want the data from the hidden columns
converting to the .csv.

.csv Format, Hidden Columns, 2007
 

I tested with both... hidden columns get transferred to the CSV...

You can record a macro to copy the visible cells to a new worksheet and save
that worksheet to CSV.

--
Pl click the ''''Yes'''' button
(if you see it - don''''t worry if you don''''t),
if this answer was helpful.



"Tammy" wrote:

In 2003 Excel, I could hide columns in a worksheet, save the worksheet as a
.csv and the hidden columns/data did not convert to the .csv file (which is
what I want). In 2007 Excel, I have hidden columns and save the worksheet as
a .csv and the hidden columns/data get converted over, too. Is there
something I can do about this? I don't want the data from the hidden columns
converting to the .csv.

.csv Format, Hidden Columns, 2007
 

Are you sure? With my Excel 2003, the hidden columns *are* included in the
csv.
--
David Biddulph

Tammy wrote:
In 2003 Excel, I could hide columns in a worksheet, save the
worksheet as a .csv and the hidden columns/data did not convert to
the .csv file (which is what I want). In 2007 Excel, I have hidden
columns and save the worksheet as a .csv and the hidden columns/data
get converted over, too. Is there something I can do about this? I
don't want the data from the hidden columns converting to the .csv.

.csv Format, Hidden Columns, 2007
 

I had to get someone to give me a copy of 2003 and found that yes, the hidden
columns are included.

I've noticed other posts that recommend a way to eliminate the hidden
columns when copying/pasting, but not when doing a Save As .csv. Here are
the recommendations for copy/paste (below). Anything similar for Save As?

Two stages

Edit, Goto, Special, Current Region

Edit, Goto, Special, Visible

Then copy and paste as normal.




"David Biddulph" wrote:

Are you sure? With my Excel 2003, the hidden columns *are* included in the
csv.
--
David Biddulph

Tammy wrote:
In 2003 Excel, I could hide columns in a worksheet, save the
worksheet as a .csv and the hidden columns/data did not convert to
the .csv file (which is what I want). In 2007 Excel, I have hidden
columns and save the worksheet as a .csv and the hidden columns/data
get converted over, too. Is there something I can do about this? I
don't want the data from the hidden columns converting to the .csv.