Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 -- to e-mail direct replace @mailintor.com with @tiscali.co.uk "Pat" wrote in message ... 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 |
#3
|
|||
|
|||
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 "Sandy Mann" wrote in message ... 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 -- to e-mail direct replace @mailintor.com with @tiscali.co.uk "Pat" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help with data not getting plotted | Charts and Charting in Excel | |||
Charting data ranges that change | Charts and Charting in Excel | |||
Formulas in source data | Charts and Charting in Excel | |||
Data Table - Does it work with DDE links and stock tickers? | Excel Discussion (Misc queries) | |||
Extending a Chart Data Series from an Array - Can it be done? | Charts and Charting in Excel |