Initial Sheet (Opening Sheet)

[Anonymous]

I want the users to land on a specific sheet when opening using any client from the access point.  I have saved the file on the sheet I want to open, but there appear to be users on the AJAX client where the document opens to a different sheet every time.  Is there a cache or some other AJAX limitation that is preventing this from working correctly?  Is there another way to accomplish this?

[m_woolf · Accepted solution]

Try:

ActiveDocument.Sheets("Details").Activate

in a macro that is set yo run when the document is opened, where Details is the name of the sheet you want to activate.

[Anonymous]

I will certainly try that.  So it looks like a possibility is that AJAX cannot process activate sheet on open triggers but can execute a macro that does the same thing?  I will post results.

[erichshiino]

Hi, Aaaron,

Maybe those users are recovering an old session.

You can try to disable it on the server.

There is a checkbox called 'Prohibit Session Recovery' on the Documents tab in Server properties in QEMC. Please, check if it marked. It may be causing your problem.

Hope this helps,

Erich

[Anonymous]

The macro idea worked.