Ghost data lurking

  • Thread starter Thread starter Pat
  • Start date Start date
P

Pat

I have come across a strange phenomenon which I cannot explain.

First, I deleted several duplicate rows of data. Then I saved the sheet as a
CSV file. The duplicate rows previously deleted are not visible (as it
should be the case). But when the CSV file is viewed in WordPad the deleted
rows appear as though they were never deleted.

This is bazaar. I discovered this when I had difficulty importing the CSV
file into an MSAccess 3rd party program.

Anyone come across this behaviour before?

Pat
 
Pat,

I can't replicate what you are saying by deleting the rows but they do show
in Wordpad if I only hide them. I am using XL97 on Windows XP.

Regards

Sandy
 
Hello Sandy,

I am afraid its a false alarm, the source of the problem is the absence of
the word Calculate in the code I use to run to create the CSV file. Sorry to
make you all scratch your head.

Pat
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Best Gmail Backup Tool to use in 2025? 3
Save as CSV not saving the same from Excel 2007 then in Excel 2003 1
CSV->Excel Data Problem 1
How do I autodelete rows in a macro on a variable dataset? 6
how to link ot a data in a csv file? 3
Pulling Data, References and Flat Files 1
Save Excel file to CSV with quotation mark data delimeter? 2
Losing date format when saving .csv files 10

Back
Top