View Single Post
  #1   Report Post  
Pat
 
Posts: n/a
Default Ghost data lurking

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