Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi. I'm getting a weird error when loading Excel (xlsx) files into Qlik Sense
I can work around it by opening it, then saving with a new name... Any idea how i can trouble shoot it? Would this kind of thing appear in logs so I can get the infrastructure guys to look into it?
The file may not be completely match with the specified file-formatting. This could happens if the file wasn't created by a desktop Excel else any other tool (even the online Excel isn't identically with the desktop Excel). Some tools could handle respectively ignore such deviations and some are rather strict. Therefore try to change the source of this file.
- Marcus
Thanks Marcus - I'll follow up with the guys who provided the file - it should just be the desktop version that created it, as we are one of those companies that lock everything down, but perhaps its a really old file that they keep saving on top. Cheers.