Forum Discussion

KeithC's avatar
KeithC
New Contributor
4 months ago

User Inactivity Timeout - What Constitutes an 'Action' in Excel?

We currently have our 'User Inactivity Timeout' setting to 30 minutes. We have users that are being 'timed out' in the excel add-in before that time threshold.  Question- What constitutes an 'actio...
Application Properties
  • JJones's avatar
    JJones
    4 months ago

    Refreshing the sheet should reset the 30 minute timeout setting for User Inactivity Timeout.  The user inactivity timeout would be tied to a user who has not had any action on an application server in the environment for 30 minutes.  In order to count as an action, it would just be a request that was submitted to the application server, a Sheet Refresh would count as a call to the application server even if the metadata was not changed on the sheet as it has received a call to retrieve the data again.

    As a test I set User Inactivity Timeout to 10 minutes and created an excel sheet with a cube view connection.  I left excel for 10 minutes and then came back and refreshed and my session was timed out.  

    I then logged back in and refreshed the sheet and then set a timer for 10 minutes and before 10 minutes I refreshed the sheet and then went back when it would have been the 10 minute expiration and I was still logged in.

    Hope that helps answer your question.

JJones's avatar
JJones
New Contributor III
4 months ago

Refreshing the sheet should reset the 30 minute timeout setting for User Inactivity Timeout.  The user inactivity timeout would be tied to a user who has not had any action on an application server in the environment for 30 minutes.  In order to count as an action, it would just be a request that was submitted to the application server, a Sheet Refresh would count as a call to the application server even if the metadata was not changed on the sheet as it has received a call to retrieve the data again.

As a test I set User Inactivity Timeout to 10 minutes and created an excel sheet with a cube view connection.  I left excel for 10 minutes and then came back and refreshed and my session was timed out.  

I then logged back in and refreshed the sheet and then set a timer for 10 minutes and before 10 minutes I refreshed the sheet and then went back when it would have been the 10 minute expiration and I was still logged in.

Hope that helps answer your question.