Hello community!
I have two different problems that I think are related to each other.
Both the problems are happening since we updated Excel to the new 1703 build (with the previous 1609 it did not happen).
The first is the "Send to Excel" function: it doesn't work. It simply nothing happens. It does not work both from the right click function or from the indentation "xls" icon.
The second problem is with the export to Excel via VBScript.
I have a pivot table with two consecutive blank columns. Until now both columns were exported to the Excel file with a VBScript macro, but since this Excel update only one of these columns gets exported causing trouble with the rest of the macro (wrong columns are deleted, table formatting is wrong etc.)
I have a simple workaround for this, but this is not the only table nor qvw with this kind of tables and if this is an Excel bug as I suspect (although I have no confirmation) I would prefer not to update every one of them only to rollback to the previous version after an Excel fix has been released.
I've attached an example .qwv to show you what I mean.
The QlikView version I'm using is the 12.10.20300 SR5
Do something like this happened to you?
Did you manage to solve the problem?
Thank you all!
