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

  • Thread starter Thread starter Tammy
  • Start date Start date
T

Tammy

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.
 
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
 
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.
 
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...
 
Back
Top