Export von Daten in Excel Version QlikView 12.6 - Beschädigte Datei - Makro

[qlikview2015]

Hi zusammen,

seit dem Update auf QlikView Version 12.6 klappt der Export an Excel nicht mehr per Makro.

Es wird zwar exportiert und die Datei erstellt. Beim öffnen bekomme ich allerdings die Meldung das diese beschädigt ist.

Jemand eine Idee oder sogar ene Lösung?

Besten Dank.

Mike

--------------------------------------------------------------------------------------------------------------------------------

Hi all,

since the update to QlikView version 12.6 the export to Excel does not work anymore via macro.

It is exported and the file is created. But when I open it, I get the message that it is corrupted.

Does anyone have an idea or even a solution?

Thanks a lot.

Mike

[marcus_sommer]

Please share some more details, like the release changed from x to 12.6 SR x and if there were any other changes to the OS and/or MS office, too or not? Which Excel release is in use? Happens it for all users/application/objects - even very simple ones? How is the macro executed - manually or per batch? How does the macro and the Excel file look like?

- Marcus

[marcus_sommer]

Just seeing this elder posting with the new bump: ExportBiff saving corrupt xls from QV Plugin, but ... - Qlik Community - 1875544.

If it's related to the IE plugin - was it also updated to 12.6 ? If yes you may try to revers it to see if it worked then and if not you should upgrade the plugin, too.

- Marcus

[qlikview2015]

Hi!

Seit dem Update ist QlikView May 2021 SR1 Version 12.60.20100.0 im Einsatz. Das IE-Plugin ist auch das neuste (Version 12.60.20000.0).

Die Office Version ist von 2016. Das Macro wird manuell ausgeführt. Alle User haben das selbe Ergebnis.

Viele Grüsse

Mike

--------------------------------------------------------------------------------------------------------------

Hi!

Since the update QlikView May 2021 SR1 version 12.60.20100.0 is in use. The IE plugin is also the latest (version 12.60.20000.0).

The Office version is from 2016 and the macro is run manually. All users have the same result.

Many greetings

Mike

[marcus_sommer · Accepted solution]

What happens by reverting the plugin release to the elder ones? 

Does a manually export from an object work? And if yes how does the working and not working files differ from each other?

- Marcus

[qlikview2015]

Hi!

ich habe das PlugIn auf die neuste Version geupdatet. Nun scheint es zu funktionieren.

Vielen Dank fürs gedanken machen :-).

Viele Grüsse

Mike

----------------------------------------------------------------------------------

Hi!

I have updated the PlugIn to the latest version. Now it seems to work.

Thanks for your thoughts :-).

Many greetings

Mike