2007 Worksheet, Hidden Columns, .CSV Format Saves Hidden Column Da
 

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.

2007 Worksheet, Hidden Columns, .CSV Format Saves Hidden Column Da
 

I tried with Excel 2003 and 2007 both... both saved the hidden column too.

Workaround...
F5-Special-Select Visible cells only
Copy and paste to another sheet and save that sheet as CSV

"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.

2007 Worksheet, Hidden Columns, .CSV Format Saves Hidden Colum
 

I'm wondering if there's some sort of setting, then, in 2003 that did this
for me and if there's an equivalent setting in 2007.

"Sheeloo" wrote:

I tried with Excel 2003 and 2007 both... both saved the hidden column too.

Workaround...
F5-Special-Select Visible cells only
Copy and paste to another sheet and save that sheet as CSV

"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.

2007 Worksheet, Hidden Columns, .CSV Format Saves Hidden Colum
 

Are you sure you could do this in Excel 2003?

Pl. post your question again as I don't know of any setting which will
achieve what you want...


"Tammy" wrote:

I'm wondering if there's some sort of setting, then, in 2003 that did this
for me and if there's an equivalent setting in 2007.

"Sheeloo" wrote:

I tried with Excel 2003 and 2007 both... both saved the hidden column too.

Workaround...
F5-Special-Select Visible cells only
Copy and paste to another sheet and save that sheet as CSV

"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.