Questions tagged [sharepoint]

SharePoint is a collaboration platform by Microsoft.

Filter by
Sorted by
Tagged with
1 vote
3 answers
10k views

Updating a SharePoint List via Excel

From following Microsoft's documentation, I've been able to import an Excel spreadsheet into SharePoint Online as a List and also export a SharePoint List to an Excel spreadsheet. What I haven't been ...
0 votes
1 answer
5k views

Allow people to filter in a shared read-only excel file on Sharepoint

I have an excel file that is hosted on Sharepoint and accessible to anyone with a link. I don't want anyone to be able to change the data in the file, so I've removed Edit access for everyone but me. ...
3 votes
2 answers
13k views

Adding mapped Sharepoint as a "Trusted Location" in Office 2016 for macro enabled files

Overview I'm trying to add a mapped Sharepoint Library to Trusted Location in Office for macro enabled files so end users don't have to select "Enable Macros" every time they launch the file. ...
1 vote
1 answer
5k views

Configure Office workgroup templates for Office365 from SharePoint location

Problem statement We have updated custom corporate templates to be used by staff for Microsoft Word, PowerPoint and Excel and these were loaded on Microsoft SharePoint. We would like to ensure that ...
3 votes
3 answers
3k views

Open desktop shortcut to SharePoint directly in Excel

I have a desktop shortcut to a shared Excel spreadsheet that I use daily. It lives in a Microsoft Teams folder, i.e. on SharePoint. This shortcut opens a browser window asking me if I want to open the ...
0 votes
0 answers
18 views

Windows Explorer integration of a shared OneDrive/Sharepoint folder without an account

With OneDrive/Sharepoint (please excuse my conflating of them), it is possible to create a shared folder, which can be set to "Anyone with the link can edit". Thus, it is possible to share ...
1 vote
1 answer
4k views

Excel powerquery with sharepoint workbook - We couldn't authenticate with the credentials provided

I'm trying to add a SharePoint 365 workbook as an Excel data source to another SharePoint 365 workbook. I am signed in with the correct account according to Excel. When I try to add the data source, ...
0 votes
1 answer
4k views

How to automatically populate a lookup column in Sharepoint 2013

I have 2 Sharepoint lists in SP2013: Errors and Locations. The errors list has a lookup column to the locations list. I need the location information (phone, address, etc) to populate automatically ...
2 votes
1 answer
73 views

How to autopopulate Sharepoint list with Power Automate?

Im trying to autopopulate a Sharepoint list with names of the employeey with Power automate. The names of employees I want to retrieve from Office 365 Users. I already created a flow for this but it ...
0 votes
1 answer
5k views

Autorefresh excel file in sharepoint

I have an excel file that is connected to some external data sources (sql server...). This file is used as a data source in a power bi dashboard. What I want is to have the data in this excel updated ...
2 votes
1 answer
5k views

Hyperlink to a file using the current user

I am trying to create a hyperlink which will work for everyone on different machines. For example, this works for me: C:\Users\bob\text.txt However, will not work for users on a computer who do ...
0 votes
1 answer
8k views

Navigation settings missing in site settings. SharePoint Online

I am an admin on all site collections and team sites which I created. I need to change the Navigation method. However for some reason the new sites that I created does not give me the "Navigation" ...
0 votes
0 answers
11 views

Does sharing file/folder/site with an external user result in AD account auto creation and is there a limit?

I want to share either file/folder/site with an external user. What I'm trying to understand is whether either of this results in automatic creation of guest account in the AD? And if it does result ...
1 vote
1 answer
77 views

Download different versions of sharepoint files without replacing them on the server

I have a bunch of xml files stored in a Sharepoint Document Library which are altered by a tool from time to time, so the files have a version history. Sometimes, I would like to know the exact ...
0 votes
1 answer
48 views

Sharepoint formula to increase count of Name column

Looking for a formula to increase count based on times data appears in column. I’m getting a syntax error trying =COUNTIF([Name]:[Name],[Name]) Example: Name / Formula Jon/ 1 Jon/ 2 Sam/ 1 ...
0 votes
0 answers
34 views

migrating from dropbox to onedrive

Senario We are migrating files from dropbox to onedrive. We download the top-level parent folders from dropbox and upload to onedrive. Those parent folders have many levels of subfolders and so on, so ...
1 vote
1 answer
3k views

Branching based on rating in Microsoft Form

Is it possible to branch the option based on rating? Like, if rating is one star, it must go to "What you dislike most" and if rating is 5-star, it must go to "What you like most"
0 votes
2 answers
8k views

Mounting a SharePoint folder in Windows 10 without IE

There are multiple questions and tutorials that show how to mount a Sharepoint storage directory as network drive on Windows 10. Unfortunately all ways to mount a Sharepoint storage in Windows seem to ...
0 votes
0 answers
60 views

Allow SharePoint site owner to extend guest expiration (SPO)

I understand that by default, only site collection/SharePoint admins can extend guest expiration. But this isn't practical for my purposes. I want site owners to also be able to do this. If there is a ...
1 vote
0 answers
675 views

How to build a library of reusable slides for PowerPoint?

Our company has recently had a rebrand and we are redesigning all our slide decks, we have about 100 unique slides that get used in various scenarios and sometimes not all slides are needed. I'd like ...
2 votes
3 answers
4k views

Open sharepoint word file in users desktop app by clicking on direct hyperlink to word document

In our web application, we have direct link to word document in SharePoint site. So when user clicks on the hyperlink, I would like to open that in users local desktop word application. But I am ...
-1 votes
1 answer
2k views

SharePoint's "Open in desktop app" is not available in Office 2021 apps, how to show it?

I have been shared with a file in SharePoint but the Open in desktop app option is invisible. I appreciate any idea to fix it. Only these menu entries are visible in Excel:
0 votes
1 answer
643 views

Broken zip when downloading from sharepoint site

I have to download about 200GB of data from a Microsoft 365 sharepoint site on a Mac. The downloaded zip files seem to be broken. I have tried downloading smaller folder and fewer set of files at a ...
0 votes
1 answer
87 views

As a SharePoint Guest, is there a way to attach files in the Outlook app for Windows using the "Browse Web Locations" feature?

I work in IT and am helping a SharePoint guest who works closely with another tenant, attach files to her Outlook client straight from that tenant's SharePoint. Is there way to make this work through &...
1 vote
4 answers
9k views

Access Denied to local document, offering to request permission on SharePoint

A colleague of mine has encountered this error while trying to access a document on a file share. Access Denied You do not have access to view this file. Would you like to request for permission on ...
0 votes
0 answers
49 views

Powerpoint file downloaded from Sharepoint gets ruined by upstream changes in bizarre fashion

I downloaded a pptx file from our company's Sharepoint repository (by right-clicking and choosing 'Download'). Then I moved the file on to my Desktop, which is synchronized into OneDrive. Then I made ...
0 votes
0 answers
199 views

Send notification of new sharepoint news by mail automatically

I have a SP modern Team site with "News" web part on the main page. I want to notify users via email when news are posted. It is possible to send a digest to email manually. However, I want ...
0 votes
0 answers
26 views

How to move to next slide in PowerPoint Web App?

I have a PowerPoint file in SharePoint. When I copy a link to share the file (e.g. in a meeting agenda), then I click on that link, it opens up in the PowerPoint Web App. In there, if I'm editing a ...
0 votes
1 answer
170 views

Is it possible to search a Sharepoint documents library and exclude results from any directories named "Archive" and subdirectories of "Archive"?

Is there search query syntax that can be entered at the top of the SharePoint Microsoft 365 site in the search box to search for any files and folders that meet a given word or words but not include ...
0 votes
0 answers
155 views

Publish Word document as web page via OneDrive for Business

I need to share a Word document (named MyPage.docx) with tables and images via OneDrive Business as a web page with colleagues. The Word document is updated regularly. When I save the Word document as ...
0 votes
1 answer
2k views

Copy a file from a computer to a SharePoint folder either using xcopy or robocopy

I am trying to copy a file that is stored on a local disk C on my computer to a SharePoint folder using either xcopy or robocopy. is there any way to do that?
0 votes
0 answers
77 views

Getting user names from a Sharepoint.files() extraction (Power Query)

From Sharepoint, I am able to extract a table containing filenames, file extensions, and dates... https://learn.microsoft.com/en-us/power-query/connectors/sharepoint-folder However, I would like to ...
0 votes
0 answers
106 views

How to access sharepoint files on task scheduler when not logged in

I have a powerflow setup saving certain email attachments to a sharepoint folder. Our sharepoint syncs to onedrive. I have a python script that takes these excel files, reworks them and saves them to ...
16 votes
5 answers
55k views

Mount SharePoint Online (Office 365) in Linux

We have started using SharePoint Online included with our Office 365 subscription. Our windows users can install software that automatically syncs the Shared Documents from SharePoint to their ...
0 votes
0 answers
120 views

Why are there two locations for SharePoint and why don't they show the same files?

On my SharePoint I have synced it with my local drive and I see two locations. https://yellowshoe.sharepoint.com/sites/HR/Shared Documents/SFB Consulting Z:\One Drive Square Balloon\Yellowshoe ...
0 votes
0 answers
20 views

Export to excel error caused by netscaler loadbalncer

We are curently migrating from SharePoint 2016 to SharePoint SE and we are facing strange authenticationg issue on new SHP SE enviroment. Authentication is NTLM and what is happening besides all other ...
1 vote
0 answers
497 views

MsTeams how to disable deletion of files

My question is about ms-teams. How do I prevent deleting files from ms teams by guests or members. By the way, i am working with the free version. Untill now i did not succeed. I looked at channel ...
0 votes
0 answers
1k views

PowerPoint opens old version of file instead of the most recently saved

I have a presentation I have worked on for some hours, and which I have saved regularly. When going to the open file dialogue in PowerPoint I see that it is last saved ~5 minutes ago. However, when ...
4 votes
2 answers
4k views

Mapped Drive Storage Size Matches my Windows Drive?

I have a couple of drives mapped to a SharePoint site. When I open Windows 10 Explorer and look at the details of my Windows (C:) drive, it tells be there are "4.77 GB free of 66.7 GB". When I look ...
0 votes
0 answers
695 views

Folder junction/link to a OneDrive/SP folder that retains OneDrive features?

We have a request to change the location of OneDrive/SP synced files to the c:\ root folder. However, this would require the change of all OneDrive folders (personal synced folders, SP libraries, etc)....
2 votes
3 answers
8k views

Set Documents library as the Home view in Sharepoint 365?

The homepage for my Sharepoint site is a view that includes the Documents library. This view looks nearly identical to the actual Documents library, but is missing most of the controls. Users have to ...
1 vote
3 answers
8k views

Sharepoint List Exported to Excel - Columns are readonly

From a sharepoint list, I chose Actions -> Export to Spreadsheet, saved the owssvr.iqy file, opened this file, and tried editing entries in Excel. When I try to edit any columns, I am shown: "...
1 vote
1 answer
293 views

Change resource Working Time (add vacations) in MS Project (PWA)

Clicking on "Project" -> "Change Working Time" and choosing the resource, does not allow me to change the work time. There's no dropdown arrow in Start and End columns... In MS ...
0 votes
1 answer
311 views

Sharepoint document shared with me no longer opens in browser

My colleague J at another institution shared a read-only Sharepoint document with me and other colleagues at other institutions via link sharing. I was able to view the whole document in my browser ...
0 votes
1 answer
175 views

How can I access contents of a SharePoint repo without downloading contents to my computer?

OK so I will probably butcher some terminology but bear with me... Our organization in transitioning to the Microsoft infrastructure. One thing that was done was backup to SharePoint of a NAS backup ...
2 votes
5 answers
52 views

Is there a risk of breaking a document by opening in word online

I use sharepoint in my Company. Each time I want to view a document, I right click on it and then choose "preview" or "Open in word" (for desktop) instead of directly clicking on ...
1 vote
1 answer
399 views

Sharepoint/One Drive "Free up space"

I use sharepoint to host files on the cloud, with a shortcut added to OneDrive so we can browse the files through windows explorer. We have a lot of automation, which pulls files locally and processes ...
1 vote
1 answer
117 views

Does Word provide an explicit menu option to check in/out of SharePoint?

We use on-premises SharePoint and often when opening a Word file, it prompts me with a yellow header bar to make a document editable, and check it out. Some times when saving, I am similarly prompted ...
0 votes
1 answer
996 views

Merging two lists in Excel

The Situation: I have two teams both on separate sheets of an excel document writing out the info of people they talk to each day (Name, customer number, Date etc). The third team want a sheet with ...
0 votes
0 answers
710 views

What's the best way to work with a sharepoint site?

I'm a developer who's never used MS SharePoint to manage web sites. The company I work for uses them all the time. They've set us up a web page, with a template to base new pages from. As well, they'...

1
2 3 4 5
7