Sharepoint sharing from within word, excel (Possible Mac-only issue?)
Trying my luck in the forums, since google has come up dry! File is located in a sharepoint library, and can be shared perfectly well using 'share' or 'copy link' from within the library. However, if I try to open a file in excel or word app, the frame fails to load (as shown in screenshot). The same happens if I do it 'file>share' as well. Has anyone else experienced / know anything I can do about this problem?
Power Query Request to external Sharepoint / Log-In fails
Hi, I'm trying to make a Power Query to an external (client) Sharepoint. The URL identify the document and the connection is established... but no data is loaded. In then Navigator the table preview shows the header "Kind/Name/Children/Text" (?) and the Web Preview shows the Log-In dialog. I assume... the Log-In is the problem... but where to fill in the Log-In data for the query? Thx GoetzComplex Spreadsheet, very high disk usage working out of SharePoint directly
I'm trying to figure out what's the root of this issue, but the gist is I have a very formula heavy document that is currently misbehaving dramatically. Co-authoring has gotten very flaky, not too surprised about this, the doc is slow, also expected. What is perhaps most interesting, I am working directly through the SharePoint document library instead of through OneDrive synced folders, and when attempting to "save" some large changes excel starts spinning at around ~30% CPU of a quad core, and constantly at 30-50MB/s disk activity! This went on for well over 10 minutes then ended and the status changed from "Saving" to "Saved". I've no clue why there is so much disk activity for a file that is not even stored on my hard drive! I assume excel is saving some temp files or something, this is expected but the file is not even 3 MB in size! What could excel possibly be doing that amounts to ~18GB of disk activity!!!How to update a sharepoint list from excel table?
Excel 2013 I have lot of working excel workbooks, that are update on daily basis from several users. I wish to push to a Sharepoint list a standard content (table) in order to create only one table for making reports and comparisons among all worksheets data. In the previous Excel version there was an add-on available to do this job (syncronizewssandexcel.xlam), but now I am not able to find it (seems deprecated). How can I get out from this stumbling block? There is another supported method?
Importing data into Excel 2016 from Access/Sharepoint database
Hello I have an access database that has linked tables with sharepoint. I have historically linked queries to an excel spreadsheet and imported data with no problems in access and excel 2013. After upgrading access and excel to 2016 the the Excel spreadsheet will no longer connect and shows “connecting to database” but never does. I noticed that I can link to standard access tables but NOT tables or queries that are linked to sharepoint. Not sure if this is some new security or other feature. Please advise. DeanRefreshable Connections via Sharepoint
I've created an excel sheet that pulls data from two excel online sheets that are linked to forms filled out on a weekly basis. Because it's in my onedrive, I'm the only one who can refresh it, which is less than ideal. Is there any way to create it in such a way that multiple people could refresh it?
