Well as I noted above, if the filename hasn't changed then you must have moved that file to another location. You cannot have two files with exactly the same path/filename - hence some of the information on that has changed. This is likely why.
Simply put Excel is possibly the worst medium you can use for data transfer, I cannot stress to you how bad it is. Use any proper data transfer format and your life will be so much easier - CSV, XML, dataset, delimted etc. I know, your response is going to be, but we "have" to use Excel, generally I hate that word have to. Even then however you could save the data to Excel - write a macro to do it if you have to, just get away from the horribly unstructured/uncontrolled environment.
... View more
