Connect Excel to SQL Analysis Services

Posted on 2014-08-14
Last Modified: 2014-09-07
We have an excel that will connect to BI server but in case there is no network connection, a message box will be popped up to connect to the server.

Is it possible to disable the box if there is a connection problem to BI server ? Tks
Question by:AXISHK
    LVL 28

    Expert Comment

    by:Ryan McCauley
    No, you can't disable this warning - it's Excel telling you that it can't connect. It should only appear when you try to refresh the data and the server isn't available. If you're getting the warning when you first open the sheet and it's not connected, you can disable the "Auto refresh data when sheet is opened" for that data connection (instructions via

    1) Open Microsoft Excel workbook.
    2) Click a cell in the external data range.
    3) Click the 'Data' tab. (The 'Data' tab appears.)
    4) From the 'Manage Connections' group, click the 'Refresh All' drop-down list and select 'Connection Properties'. (The 'Connection Properties' dialog box appears.)
    5) From the 'Refresh control' group, select the 'Refresh data when opening the file' check box.
    6) Click 'OK'.

    Author Comment

    The setting is grey on my Excel 2013. Any idea ?
    LVL 28

    Accepted Solution

    Have you selected a cell within the data area before opening that menu? It looks like the data table isn't active.

    Alternatively, you could click "Connections" just above and to the right of that menu to view all the connections in the sheet (without selecting the data table) and then just modify the settings from there.

    Author Closing Comment


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Top 6 Sources for Identifying Threat Actor TTPs

    Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

    There have been several questions about Large Transaction Log Files in SQL Server 2008, and how to get rid of them when disk space has become critical. This article will explain how to disable full recovery and implement simple recovery that carries…
    This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
    Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
    Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

    758 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    14 Experts available now in Live!

    Get 1:1 Help Now