When you open a workbook that contains links to cells in other workbooks, you may receive the following message: Show
You can click either Update or Don’t Update. By default, Excel displays this message. To suppress the message and to automatically update the links, follow these steps:
Sharepoint 2013 Resolve refresh ExceBe careful. This workbook contains one or more queries that might be unsafe How to solve the prompt to refresh Excel data Be careful. This workbook contains one or more queries that might be unsafeSingapore projects are often isolated and helpless. Internet access is very limited, in order to write this article, I copied a few pictures. View Image This problem is caused by Excel Services. Open SharePoint Central Administration Open Application Management Click Service Applications open Manage service applications Click Excel Services application click Trusted File Locations and click on the Address that contains the workbook. View Image View Image Under External Data, remove the Refresh warning enabled hook. Just fine The following image View Image This article is contributed by Anonymous and text available under CC-SA-4.0 DISABLE ADBLOCKADBlock is blocking some content on the site
CheckedQuestionI try to display data using Excel services in a web part. First of all, my Sharepoint version is Sharepoint 2013; In addition, all authentication processes are working properly and I can retrieve the data. My excel is set to refresh connection each time the page is opened. Where my problem starts is that when I open the page, I get a warning: "Be careful. This workbook contains one or more queries that might be unsafe". I have searched about it found some solutions from: https://docs.microsoft.com/en-us/sql/analysis-services/power-pivot-sharepoint/this-workbook-contains-one-or-more-queries-that-refresh-external-data?view=sql-analysis-services-2017 and from : http://dinushaonline.blogspot.com.tr/2016/01/disable-warning-query-and-refresh-data.html
No correct solutionOTHER TIPS
I resolved this pesky warning by doing the following:
It shouldn’t affect the automatically refresh data after untick “warning refresh enabled” option. Whether there are other excel files with external data have this same issue? Make sure you have configured refresh data when opening the file in excel file. Technically this is not a SharePoint question but an Excel question. Here is a solution. Create a Visual Basic module called Workbook_Open() Private Sub Workbook_Open() 'Refresh the data link to Sharepoint List View ActiveWorkbook.RefreshAll Range("A1").Select ActiveWorkbook.Save End SubSave the workbook as an Excel Macro-Enable Workbook. This will then run when you open the file. How do you fix this workbook contains links to one or more external sources that could be unsafe?To resolve this problem, do the following:. Check for unresponsive instances of Microsoft® Excel®. Close all Microsoft® Excel® Workbooks. ... . Check the Microsoft® Excel® workpaper for improper links. ... . Check the workpaper for improper External Reference (links). ... . Check for multiple Microsoft® Office installations.. How do you disable this workbook contains one or more links that Cannot be updated?To suppress the message and leave the links (not updated) until you choose to update them, follow these steps:. In Excel, select Edit Links in the Queries & Connections group on the Data tab.. Click Startup Prompt.. Click the Don't display the alert and don't update automatic links option. Warning.. How do you remove excel error this workbook contains links?Solution. Open the Excel spreadsheet.. Click File.. Click Info.. Click Edit Links to Files.. In the Edit Links pop-up, if relevant select the link and click Break Link and confirm.. Save the spreadsheet.. |