Issue in reading data from Excel

  • Thread starter Thread starter ASH
  • Start date Start date
A

ASH

Hi All,
I have 3 excel files with me. say,Test.xlsx, saved.xls and
original.xls.

Here Test.xlsx has got reference to saved.xls and original.xls and
displays values from both files. But the cells referring to data from
Original.xls shows #N/A in Test.xlsx where as data from Saved.xls
shows the correct values. (I am using the formula: =HLOOKUP(A5,'D:
\Testing\[Original.xls]Output'!$A$1:$CQ$2,2,FALSE)

Here, saved.xls and original.xls has got same columns and same data,
but if i check the files size of both, they are different.
size of Saved.xls is 26 KB and the size of Original.xls file is 17
KB.

Now the interesting work around for this is, if i keep the file
original.xls open and then open Test.xlsx it will bring the expected
values just like saved.xls does.
Or if I just open original.xls and hit save (and close it) and then
open Test.xlsx it works fine. Also i noted that once i save
original.xls, it's file size increases to 26KB from 17KB

These files were generated programatically and I would like to know
why I am not getting values from Original.xls initially and how can I
fix this issue without doing the above mentioned workarounds.

Thank you
ANR
 
Hi All,
I have 3 excel files with me. say,Test.xlsx, saved.xls and
original.xls.

Here Test.xlsx has got reference to saved.xls and original.xls and
displays values from both files. But the cells referring to data from
Original.xls shows #N/A in Test.xlsx where as data from Saved.xls
shows the correct values. (I am using the formula: =HLOOKUP(A5,'D:
\Testing\[Original.xls]Output'!$A$1:$CQ$2,2,FALSE)

Here, saved.xls and original.xls has got same columns and same data,
but if i check the files size of both, they are different.
size of Saved.xls is 26 KB and the size of Original.xls file is 17
KB.

Now the interesting work around for this is, if i keep the file
original.xls open and then open Test.xlsx it will bring the expected
values just like saved.xls does.
Or if I just open original.xls and hit save (and close it) and then
open Test.xlsx it works fine. Also i noted that once i save
original.xls, it's file size increases to 26KB from 17KB

These files were generated programatically and I would like to know
why I am not getting values from Original.xls initially and how can I
fix this issue without doing the above mentioned workarounds.

Thank you
ANR
Click to expand...
 
Back
Top