Updated to Win 10 and Excel 365 and macros now hang

[tinkerz1]

Hi

My older setup was Win 7, QV12 and Excel 2010.

My new setup is Win10, Qv12 and Excel 365.

In my older setup I use QV to export data from containers into a spreadsheet for an old legacy report in Excel format.

This macro now hangs in Excel 365, has anyone else come across the same problem, are there some Excel settings I need to change to get this to work?

Ta

Tinkerz

[Brett_Bleess]

I would recommend the best place to get a potential solution for this one is going to be on the Microsoft Excel 365 Support site, as that is where you will find changes in API calls etc...  I have seen some other recent posts on the Community though, so you can search for those and see if they are helpful or not, I cannot recall any of the solutions off the top of my head given the number of posts I cover in a matter of days.  

One way to test that this is not necessarily QlikView related would be to take the macro code minus any Qlik APIs and try to run that in say PowerShell etc. to see what happens that way, as I would expect the same issue if I am on the correct track.

Regards,
Brett