Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Sporadic Problems opening TDF in 2003
Hi, I have a program that creates a large number of Tab Delineated Files
(TDF). Most of the time Excel opens the files perfectly, but occasionally the files are opened improperly and a section of the data is missing (something like rows 10-20). If I close the file and then open it up again (no changing of the file) it opens correctly. This happens with Excel 2003 and occurs around once every 500 opens. I don't know whether any difference is made if I drag the file to the Excel window, double click on the file or open it using the open command in the file menu. I was wondering how to avoid this problem. The following TD section is a copy of one of the problematic files. (of type ..txt) 1900 504014.792963985 1901 499316.757449537 1902 418521.225079292 1903 473321.393970734 1904 536529.599218341 1905 376724.968863726 1906 300500.344013716 1907 357441.083111744 1908 397335.13996881 1909 338844.73011268 1910 463194.550236094 1911 333918.037592833 1912 306998.385048085 1913 377019.042393844 1914 392382.753975176 1915 266335.391767753 1916 416931.937678104 1917 369488.27597036 1918 433927.293059608 1919 441480.469992602 1920 337011.895683295 1921 407308.456549426 1922 358816.053925851 1923 354780.874957239 1924 402484.733879176 1925 490134.550236802 1926 348420.046880194 1927 346763.881867494 1928 528461.160327432 1929 260976.907826762 1930 311467.918194461 1931 323606.725863302 1932 466467.41266614 1933 494267.323583543 1934 669550.484391084 1935 438795.666988987 1936 401516.633893813 1937 341776.161123296 1938 436206.934270334 1939 425046.312502161 1940 412840.121568421 1941 242755.637972585 1942 329461.031456891 1943 379212.145782302 1944 325402.493740572 1945 392102.863288852 1946 463965.13742747 1947 526557.366702551 1948 467290.800477687 1949 406113.980165665 1950 562510.106263845 1951 507168.679398581 1952 326783.904103984 1953 369905.805834232 1954 505753.786421588 1955 482210.612039196 1956 544125.617074641 1957 492517.645337047 1958 352994.954315133 1959 534805.222879977 1960 497985.121702287 1961 529155.306992659 1962 393248.23615716 1963 426419.47270796 1964 431847.559573681 1965 538734.271220026 1966 373726.190703972 1967 485061.620085466 1968 580669.909461921 1969 471686.946621793 1970 368826.099689473 1971 502330.366839443 1972 635739.317307183 1973 391813.629388031 1974 522713.995835421 1975 473325.289400826 1976 572985.536092146 1977 370229.554857945 1978 419442.418909372 1979 350471.955529066 1980 383859.940890727 1981 476141.300874504 1982 448332.161093291 1983 458074.906462713 1984 471113.575814347 1985 366865.447477252 1986 445691.353639817 1987 400161.271777998 1988 303670.020691786 1989 463683.93777909 1990 475950.903651376 1991 499375.017597965 1992 338152.73815163 1993 281246.64676069 1994 309992.443001689 1995 381980.354715877 1996 497171.96240297 1997 527370.267985068 1998 402061.523125501 1999 457642.081887085 2000 498243.104818633 2001 283135.074436497 2002 522057.935796475 2003 381979.078500178 2004 395026.452740377 2005 369264.141719203 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Opening DBF files with Excel 2003 via Windows Explorer ? | Setting up and Configuration of Excel | |||
MS Office 2003 file opening problems | Excel Discussion (Misc queries) | |||
Problems with Excel 2003 after downloading Office SP1 | Excel Discussion (Misc queries) | |||
update row numbers after different active cells in macros followi. | Excel Discussion (Misc queries) | |||
Opening and saving Excel 2003 file from Excel 97. | Excel Discussion (Misc queries) |