Questions tagged [sharepoint]
SharePoint is a collaboration platform by Microsoft.
149
questions with no upvoted or accepted answers
1
vote
1
answer
8k
views
Xcopy or Robocopy from Network folder to SharePoint(2013)
I am trying to copy files from a network folder to a SharePoint folder. I have read/write permissions to the SP folder and can manually upload documents to it.
I was able to get the .bat to work 1 ...
- 11
0
votes
0
answers
9
views
automatically batch conversion of local file links to sharepoint links?
Is there a method, or an efficient approach of performing an conversion of local file link (to other files) to sharepoint (MSTeams sites) links?
Context:
a co-worker has an Excel file on a local ...
- 3
0
votes
0
answers
21
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 ...
- 111
0
votes
0
answers
25
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 ...
- 222
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
36
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 ...
- 143
0
votes
0
answers
61
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
0
votes
1
answer
713
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 ...
- 373
0
votes
0
answers
50
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 ...
- 239
0
votes
0
answers
206
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 ...
- 1
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 ...
- 1,869
0
votes
1
answer
186
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 ...
- 141
0
votes
0
answers
164
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 ...
- 526
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?
- 1
0
votes
0
answers
81
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 ...
- 101
0
votes
0
answers
112
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 ...
- 1
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 ...
0
votes
0
answers
128
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 ...
- 963
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 ...
- 958
0
votes
0
answers
700
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)....
0
votes
1
answer
1k
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
1
answer
637
views
Excel custom sort list works in Excel but not when file is transferred to SharePoint
I created a custom sort list of fiscal weeks that I use for my reports in Excel. For many reports I also use them as a Slicer. I have come across the issue where this custom sort list works perfectly ...
- 3
0
votes
0
answers
3k
views
Onedrive doesn't sync to the building icon, instead sync to the OneDrive - Tenant Name
I tried syncing a Teams General folder to Onedrive in a new PC, but it is always syncing to Onedrive - Icon in Onedrive
We are using Microsoft Teams in the company, and we had added several Teams ...
- 11
0
votes
0
answers
23
views
Can I add our company Sharepoint portal URL to always show in File Open/Save dialog?
We have on-premises Sharepoint Server 2019. When I open a file from SP in Word, and do "save as" then the SP is shown as a save location like the following https://portal.GreatWidgets.com/...
- 5,256
0
votes
1
answer
897
views
How can I create a new Word 365 from a template stored in SharePoint?
Pre-Sharepoint things were easy. You double-clicked a .dot file and automatically got a new document from this template. Or you could add a folder to Word and templates in that folder would be ...
- 5,256
0
votes
2
answers
2k
views
O365 delete events from Group Calendar
Trying to migrate from a Shared Calendar to a Group Calendar to get things more integrated into Teams, SharePoint, and Outlook.
I tried to copy events from a Shared Calendar to a Group Calendar by ...
0
votes
1
answer
182
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 ...
- 489
0
votes
0
answers
354
views
Excel online workbook cache local file which is password protected - content.mso
We are going through the process of moving our files to sharepoint, a few of our workbooks are linked to other workbooks which are all password protected.
When I open Workbook 1 which is linked to ...
- 1
0
votes
1
answer
2k
views
Mapped OneDrive on a Terminal Server
1st post, be gentle :)
I am currently working in a Hosted Desktop Solution business and more and more clients are starting to utilise OneDrive/Sharepoint combos.
This is great however immediately we ...
- 11
0
votes
0
answers
324
views
Opening SharePoint Excel file through desktop application warnings "Some files can contain viruses"
Only some users in my organization get this error when they try to open an excel file through excel desktop application that is one our SharePoint:
I tried every thing on the users excel options in ...
0
votes
2
answers
105
views
Setting up sharepoint for visibility of cell edits
I have a large excel sheet in sharepoint that is worked on by people from multiple physical locations, who can make edits to specific cells. However we regularly need to know, the values in which ...
- 1
0
votes
1
answer
38
views
Is it possible to get all table items from web to excel power query?
I need to get table data from a single page site and load them to excel power query so it can be easily refreshed.
The problem is that on site view, the table has a lot of items so it shows only the ...
0
votes
1
answer
925
views
Cloud host Sphinx documentation HTML on a corporate intranet with authentication in place
We have some HTML-based documentation generated by Sphinx. Currently it's hosted from an on-prem webserver box. We'd like to move it to the cloud and eliminate the requirement for VPN, but maintain ...
- 520
0
votes
0
answers
367
views
Cell content is cut off (vertically) when making boldface = because no longer completely top-aligned
This is when viewing the Excel inside the desktop browser version of
Microsoft SharePoint. Not when opening inside the Excel software itself.
The following concerns a cell of which the content is cut ...
- 123
0
votes
1
answer
226
views
Need to calculate cell date but only if the date is greater or equal to specific date
I am trying to create a date stamp for when a column [Task Status] is changed to complete. The following code successfully creates the date stamp when the "status" cell is changed to ...
0
votes
1
answer
53
views
Sync link for syncing shared OneDrive folder doesn't install
We have an Office 365 Business account.
I have set up a shared SharePoint/OneDrive folder, it can be accessed online from O365>OneDrive>Shared Libraries
When I press the Sync link above the ...
- 418
0
votes
0
answers
83
views
How can you transfer files from Yammer to Onedrive without doing it one by one?
I need to move the files in yammer groups out to onedrive for storage as we are going to stop using yammer. Is there an efficient way to move the files that are attached to yammer groups to onedrive?
- 1,099
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.
...
- 175
0
votes
0
answers
556
views
Download multiple files without zip?
I want to download multiple files from a Sharepoint folder to my hard drive. When I select multiple files to download it automatically zips them but our IT does not allow zip files, so nothing happens....
- 314
0
votes
0
answers
4k
views
In Excel, how do I link to a Sharepoint file instead of the synced local file?
Our office recently migrated all of our files to being stored on Sharepoint, so I'm still getting used to it.
In Excel, I am linking to an external file that is located in a Sharepoint folder that I ...
- 175
0
votes
1
answer
57
views
Show MS Dynamics 2016 (On Premise) Contacts List within SharePoint (On Premise)
We use SharePoint for our Customer Projects. We also use MS CRM 2016. So it would be helpful to store all contacts and accounts info within MS CRM but also show this on the SharePoint project pages. ...
- 131
0
votes
0
answers
30
views
How can a OneDrive user sync in his/her hard drive a folder I've shared from my own OneDrive?
I have a large multi-GB folder I've shared with a colleague and I've sent him a link with which he can download everything, but how could he "sync" my folder using the OneDrive client so whenever I ...
- 1,690
0
votes
0
answers
1k
views
The Data Area passed through a System Call is Too Small
I have a Sharepoint site synced as a mapped drive and when I try to open a file from a file path that's over 260 characters, I get the error, 'The Data Area passed through a System Call is too Small.' ...
0
votes
1
answer
37
views
PowerQuery in Excel 'master' spreadsheet on SharePoint can only be refreshed by one user and gives authentication errors for others
I created a group of SharePoint libraries on an intranet that each contain an identically formatted spreadsheet, and another library that contains a “Master” spreadsheet that fills a table from the ...
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 ...
- 101
0
votes
1
answer
401
views
How to keep an excel file open in sharepoint or onedrive after I log out?
I have an excel file that contains some vba scripts that refreshes other excel files at specific intervals. My problem is this file must be open in order to have that macro run. My question is how can ...
- 101
0
votes
0
answers
91
views
ChartJs works with Sharepoint 2016 but not sharepoint 2013
I created a chart with ChartJS and I imported the data dynamically from an xml link (odata), it worked with Sharepoint 2016 but the chart doesn't show in Sharepoint 2013. Do you have any solution for ...
0
votes
1
answer
157
views
Background Refresh Not Refreshing
I am pretty new to excel/power query, so I apologize if this is a basic question.
I'm using an Excel 16 document on sharepoint that is pulling data from another sharepoint document. The data queries ...
- 101
0
votes
1
answer
275
views
Change Desktop Shortcuts Destination to SharePoint Online
We have a client that we will be migrating to SharePoint online. Currently they have shared folders on a local server.
Users on the domain have created shortcuts to locations within the shares.
I ...
- 1
0
votes
2
answers
3k
views
Powershell. Create a subfolder in SharePoint 365
I have the following script that creates a folder named as yesterday's date under the list "Documents". However, I need to create this folder under another subfolder called "FinancialReports" instead....
- 1