Hi
I've two files exported to excel by a software with, so far, no percievable change.
The only thing is that one of them fails merging in power querry (it's properly read by power querry and formated), but will fail to find "column 1".
The tricky part, lets say that the one that works is File A and do one that doesnt is File B. To the furthest I could examine they are identical, same values same formating same value address, everything.
But, if you fully copy the values of File A and paste it over File B, the querry doesnt work.
If you fully copy the values of File B and paste it over File A, it works.
The fundamental problem seems to be in the file itsefl regardless of contents. Even though it fails to find column 1, which is, suposedly content depending.
Is there any hidden properties that might be causing this error?
I've two files exported to excel by a software with, so far, no percievable change.
The only thing is that one of them fails merging in power querry (it's properly read by power querry and formated), but will fail to find "column 1".
The tricky part, lets say that the one that works is File A and do one that doesnt is File B. To the furthest I could examine they are identical, same values same formating same value address, everything.
But, if you fully copy the values of File A and paste it over File B, the querry doesnt work.
If you fully copy the values of File B and paste it over File A, it works.
The fundamental problem seems to be in the file itsefl regardless of contents. Even though it fails to find column 1, which is, suposedly content depending.
Is there any hidden properties that might be causing this error?
