Excel worksheet external links aren't great practice to begin with. Excel is not a database and shouldn't be used like one. Heck, using a SharePoint list can be better than Excel depending on the purpose and need. Regardless of external links being best practice or not, this cannot be expected behaviour. I frequently use "Edit links" to remove external links in files, and link elements to my current file instead.
I am copying a fairly advanced graph from previous months report to current months report. The report file is system-generated and so is not reused.
I also copy the graph's source data sheet to my current report file. Now the graph is still fetching data from prev. This I normally fix by "Edit links" and pointing to my new current report file to remove that link.
Now with Sharepoint I get the error "Cannot access Then I copy the file to sharepoint again and open to continue working with the file. This way the graph will fetch data from the datasheet in my current file instead of in the previous months report file. Products 74 Special Topics 42 Video Hub Most Active Hubs Microsoft Teams.
Security, Compliance and Identity. In this tutorial, you will find full details on how to share Excel workbook with other people by saving it to a local network or OneDrive, how to control user access to a shared Excel file and resolve conflicting changes.
These days more and more people are using Microsoft Excel for team work. In the past, when you needed to share an Excel workbook with someone, you could send it as an email attachment or save your Excel data to PDF for printing. While fast and convenient, the former method created multiple versions of the same document, and the latter produced a secure though non-editable copy. The recent versions of Excel , and make it easy to share and collaborate on workbooks.
By sharing an Excel file, you are giving other users access to the same document and allow them to make edits simultaneously, which saves you the trouble of keeping track of multiple versions. This section shows how to share an Excel workbook for multiple users by saving it to a local network location where other people can access it and make edits.
You can keep track of those changes and accept or reject them. For example, you may want to have changes updated automatically every n number of minutes all the other settings on the screenshot below are the default ones. If done correctly, the word [Shared] will appear to the right of the workbook's name as shown in the screenshot below:.
Now, you and your colleagues can work on the same Excel file at the same time. You are free to accept or reject their changes, and after the desired changes have been incorporated, you can stop sharing the workbook. Further on in this tutorial, you will find the details on how to do all this. If you'd like not only to share an Excel file, but also to ensure that no one turns off the change history or removes the workbook from shared use, proceed in this way:.
Though entering a password is optional, you'd better do it. TRob TRob 3 2 2 bronze badges. Update This seems to have resolved our issue. KGlasier 1, 1 1 gold badge 8 8 silver badges 22 22 bronze badges. Pablo Herman Pablo Herman 1 1 1 bronze badge. Please update your answer with more details. What changes need to be made etc.? If the link you provided in your answer breaks in the future, your answer will not be very useful. Jussi Palo 8, 1 1 gold badge 17 17 silver badges 34 34 bronze badges.
Peter Rogala Peter Rogala 1 1 1 bronze badge. This argument suggests the opposite of TRob's answer from a year prior. Can you explain why? Sign up or log in Sign up using Google. Sign up using Facebook. Sign up using Email and Password. Post as a guest Name. Email Required, but never shown. Under security warning section you will see the warning details. You can continue without updating their values, or edit links you think are wrong.
Error: This workbook contains links to one or more external sources that could be unsafe. If you trust the links, update them to get the latest data.
Otherwise, you can keep working with the data you have. In Edit Links window, if you select a source, you will see its location. In situations, you will find it pointing to the local desktop profile of users. Nice work with the data report, but not nicely executed. Now if you try to open the file directly from SharePoint, you will get warning messages.
See the URL address has been appended with the linked file address! Microsoft uses our product internally for the past 3 years in multiple areas internally , as well as NASA 3 research centers , Intel, HP deployed globally , Ford used by 12K site collection admins.
Thank you Chris I've spoken to your team but it's incredibly expensive compared to others. Products 74 Special Topics 42 Video Hub Most Active Hubs Microsoft Teams.
Security, Compliance and Identity. Microsoft Edge Insider. Azure Databases. Project Bonsai. Education Sector. Microsoft Localization. Microsoft PnP. Healthcare and Life Sciences. Internet of Things IoT. Enabling Remote Work. Small and Medium Business.
0コメント