Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


Connect Excel to SQL Analysis Services

Posted on 2014-08-14
Medium Priority
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
  • 2
  • 2
LVL 28

Expert Comment

by:Ryan McCauley
ID: 40276919
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 Drexcel.com):

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

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

Accepted Solution

Ryan McCauley earned 2000 total points
ID: 40279365
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

ID: 40309221

Featured Post

NEW Veeam Backup for Microsoft Office 365 1.5

With Office 365, it’s your data and your responsibility to protect it. NEW Veeam Backup for Microsoft Office 365 eliminates the risk of losing access to your Office 365 data.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
When cloud platforms entered the scene, users and companies jumped on board to take advantage of the many benefits, like the ability to work and connect with company information from various locations. What many didn't foresee was the increased risk…
How can you see what you are working on when you want to see it while you to save a copy? Add a "Save As" icon to the Quick Access Toolbar, or QAT. That way, when you save a copy of a query, form, report, or other object you are modifying, you…

580 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