How to transfer multiple sheet objects to excel with functionality intact?
I am trying to shift a multibox and a pivot table from QlikView to MS Excel. I am able to transfer the data and at times have drop downs using macros, but the functionality is not traveling. Any suggestions are most welcome.
tamilarasu If we can do this using macro, can you help me with how to implement that code? I'd be grateful for your help.
The routine would need to check if the excel is already opened and if they must give a message that the excel must be closed and after this they could be called again. Or the data are kept outside from the excel-dashboard maybe within another excel or some csv and the dashboard would use them as data-source.
