Export to Exccel issue

[svsudhakar]

Hi ,

some times I am facing issue with Export to excel option.

  No response even we  export, send to excel or
clicking the excel icon on straight table or pivot table.

please help on this daily I am facing this issue.

Thanks in Advance..

[Anonymous]

This might be due to some connecton problem or probably the data you are trying to export is beyong limits of Ecxel file ie, appr of 65000 rows.........

Please look at this side also...

[svsudhakar]

I am trying to export below 2k records.

The problem is different users are facing this issue with different times.

[amit_saini]

Hi Sudhakar,

I will suggest you to create a export button for your straight table or pivot table through a macro.

Sub ExportExcel1

vFile = ActiveDocument.Variables("vInput1").GetContent.String

'XLDoc.SaveAs "c:\Qlikview\Claro"& vFile &".xls"

set obj = ActiveDocument.GetSheetObject("Give youe cahrt object ID here")

obj.ExportEx "Give path where you want to see the export result\"& vFile &".xls",5

End sub

Here create a variable by the name of vInput1 and give it value =test (the output of export to the given location will be test.xls)

Thanks,

AS

[svsudhakar]

Thanks for your suggestion AS.

Already dashboard is in live, if I create the macros through button again I have to give training to all users.

its difficult to manage. please suggest the any alternate solution.

regards,

SVS