Excel Online – Data Refresh may time out

When using an OData Connection inside Excel, refresh may time out if the amount of data being refresh is very large. Depending on the amount of data attempting to be refreshed the refresh can take several minutes. By default the Excel Session Timeout setting is set to 450 seconds (7.5 minutes), so if your refresh is taking longer than this time frame, you will see a timeout error.

To increase the timeout setting for Office Web Apps Server 2013 on premise, you can use the following command.

set-officewebappsfarm -excelsessiontimeout <# of sec>

This cannot be changed for Excel Online. If you have a long running query, you can download the workbook, refresh the content in the rich client, and upload back to SharePoint.

Comments (3)

  1. wow can you imagine waiting 7.5 minutes waiting for a refresh? I can’t either. So try explaining this to the end user.

  2. Anonymous says:

    Recent Releases and Announcements ·          An on-demand hotfix

  3. Canuck says:

    To answer you Maurice, Excel can be programmed to download data from the web. Then when you refresh the data, it downloads the present data from the web. It can be used for things like downloading current stock prices, because those change every day.
    When you have a lot of data to download though, like financial statements and stock prices for thousands of companies, it can take more than 7.5 minutes to refresh the data. Mine would take more than an hour to do that, because it has to download more than
    a million pieces from more than 10,000 sites. Can’t figure out a way to make it work other than dividing it into more than 50 files.

Skip to main content