Regular Document Reloads - loss of macro functiona... - Qlik Community

Report Inappropriate Content · ‎2011-02-02

Hi All

I have 2 problems with a document.

I have the server reloading the document every 2 minutes.

In the document's properties on the Server tab I have "Server perfomrs refresh automatically without client action" ticked and "Enable Push from Server" and "Enable Dynamic Data Update" also ticked.

On the document I have a button linked to a macro that does the classic fitzoomtowindow like:

sub FixZoom
ActiveDocument.ActiveSheet.FitZoomToWindow
ActiveDocument.GetApplication.WaitForIdle
ActiveDocument.ActiveSheet.ApplyZoomToAllSheets
End Sub

When I have the document open, in the IE Plugin, when I first open it the button works fine. Then when the document refreshes after 2 mins I lose the zoom (problem 1 - it reverts to 100% zoom) and also even if I then click my macro button to fix the zoom it no longer works (problem 2)?

If anyone has an idea I'd appreciate any advice you could give!

Thanks

Dominic

Regular Document Reloads - loss of macro functionality?