Questions tagged [sharepoint]

SharePoint is a collaboration platform by Microsoft.

Filter by
Sorted by
Tagged with
3
votes
1answer
67 views
+100

Power Queries in Excel just default to “anonymous” and doesn't ask for login info

I have created multiple Excel sheets for my coworkers, many of which involve power query connections to our corporate SharePoint site. When I set it up, I logged into my SharePoint account to ...
0
votes
0answers
11 views

Moving synced files from SharePoint Online to local storage via PowerShell

I have synced a OneDrive library using the OneDrive Client in Windows 10 and it is located in C:\users\user\SP_lib. I want to move certain files and directories from that library into local storage. ...
0
votes
0answers
10 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 ...
2
votes
0answers
34 views

Excel rows of data suddenly disappeared after undoing deletion of unrelated rows. Version history suddenly blank. Get my data back?

I have been editing an Excel workbook for 6 days. The workbook is saved in sharepoint and also marked to always be kept on my laptop. I have saved this .xlsx file dozens of times in the last few days. ...
1
vote
0answers
7 views

Create local Word document from template in Sharepoint [migrated]

We have our company-wide Word templates in Sharepoint as the source of truth and so they can be accessed by everyone in different physical locations. There are often times when someone needs to make a ...
1
vote
0answers
17 views

Avoiding file replication in MS 365 products

I have an existing file/folder on my Onedrive. I would like to achieve the following: Make this file/folder available in the "files tab" of a Teams channel or a shared Sharepoint folder ...
1
vote
0answers
23 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
0answers
6 views

How can I archive completed tickets in SharePoint's “Issue Tracking” app? [migrated]

I have created an Issue Tracking app on SharePoint for my organization. I would like to be able to move tickets marked as "Closed" to an archive / different location (or I would even settle ...
0
votes
0answers
15 views

How to automatically export MS Teams links for all files within folder and subfolders

I want to automatically obtain a list of MS Teams/Sharepoint links to all the files within a folder on MS Teams. The folder also has subfolders. I'd rather not manually go through every file, click on ...
0
votes
1answer
22 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 ...
0
votes
0answers
29 views

Sharepoint Recycle Bin Searching

Helping out with (small) company IT. Everyone using Office365, Sharepoint, OneDrive. The level of tech savvy is not high among users. People often deleting files, which I then need to find/restore. ...
0
votes
1answer
13 views

SharePoint Date Validation Help Needed

I'm struggling with adding validation to a Date Column in a SharePoint list. I have looked up several sources and even trying the most basic validation of "=[Date Used]> TODAY()" as in ...
0
votes
0answers
23 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
0answers
14 views

User input validation in MS Forms or SharePoint

I am organizing a small conference at work. I need to ask the participants to submit their presentation abstracts. I can use MS Forms and/or SharePoint to collect and organize the user input. I wonder ...
1
vote
2answers
35 views

What does this symbol mean in Excel 365 (SharePoint located)

A couple of people are working on the same file at the same time, sometimes. But what does exactly -1 mean?
1
vote
1answer
270 views

How to allow multiple users to refresh to sharepoint Excel file with Power Query

I have an excel file with data and the second excel file that uses Power Query to connect and fetch data from that 'data' file. They both are located in the Sharepoint space. When I set up a ...
1
vote
0answers
12 views

IE 11 - TLS Error for only the one user login in a Windows 10 profile, that works fine with my own email

I have reviewed other IE11 TLS fixes and not had any success, perhaps I've missed something from them... When we are in IE 11 and launching our Sharepoint website, it leads as usual to our Office 365 ...
0
votes
1answer
54 views

Can Insert Object > Text from File use a relative path instead of an absolute path?

Problem: I am building training documentation for a client. The client has multiple roles that need to perform the same task. However, for each role there must be a distinct job aid or training manual....
1
vote
0answers
76 views

Bookmark link (OLE_LINK) constnatly breaks in a Word doc stored in OneDrive/SharePoint

In my Word doc I have a "Content Control Drop-down List" and a link to that list that is set to automatically update when the value in the list changes (might be an XY problem, but it's the ...
1
vote
1answer
169 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
1answer
1k 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
2answers
32 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 ...
0
votes
1answer
14 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
0answers
41 views

Unable to move page in sharepoint, but I have a copy to

I have a sharepoint online page that is in the wrong position. My hierarchy is like this at the moment Site Pages/main Site Pages/main/index.aspx Site Pages/page.aspx I want to move page.aspx under ...
0
votes
0answers
97 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 ...
0
votes
0answers
7 views

About SharePoint 2019 on premise custom Application Page

Today I ran into a problem is to deploy a custom application page in the SharePoint Farm (One is Application Server, another is WFE). When we access the custom application page, we got the following ...
0
votes
0answers
17 views

SharePoint 2013 - Validation Settings

I have 2 columns. Column 1 - YES/NO - Incident Column 2 - Date - Incident Date I need a validation setting put in place that does not allow a user to submit an item if they select YES for incident and ...
0
votes
0answers
33 views

Open and save Word documents directly to and from SharePoint with Firefox

Sharepoint Clicking a SharePoint document in a browser opens the document in Microsoft Word. Chrome Behaviour Chrome opens the document in read-only mode from the server. I can enable editing and ...
0
votes
0answers
13 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 ...
0
votes
1answer
772 views

Excel VBA , Excel files in a folder on sharepoint cannot be read

can anyone tell me what the problem is that the path cannot be found? When I execute the script, an error message is always displayed at the same place (runtime error 76). Sub GetData () Dim oMe As ...
0
votes
1answer
49 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
1answer
106 views

Outlook 2016 hangs when opening emails with some SharePoint links

I get emails from time to time that have links to SharePoint docs. I noticed that in some cases, I would get the "contacting the server" window as shown here which would not go away for 10-...
0
votes
0answers
8 views

how to avoid the davfs asking every-time while mounting after the reboot

I have mounted share-point on linux machine using davfs .But while mounting it will ask the username and password of the sp.I am thinking to automatically mount sharepoint after the machine reboot ...
1
vote
0answers
866 views

Can't connect to the server at this time. Your table cannot be published in Excel Sheet

I have an Excel Sheet. As per my requirement, I have to import this Excel sheet into SharePoint Online List. When I tried to import that Excel Sheet into SharePoint Online List, It is showing an ...
0
votes
0answers
51 views

Selecting Right-Align for cells rearranges the cell contents - via Sharepoint / Excel online App

I am finalizing the formatting for a project proposal for my company, and found this error. As the title states, when I try to right-align the cells their contents are rearranged. The cells are shown ...
0
votes
1answer
37 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 ...
0
votes
0answers
45 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?
0
votes
1answer
944 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. ...
0
votes
0answers
153 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....
0
votes
0answers
2k 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 ...
1
vote
1answer
31 views

How to only track my changes?

I am helping edit a document in Word on Sharepoint with multiple simultaneous authors. Sections of the document are still being written, so it doesn't make sense to track changes there. Is it possible ...
0
votes
1answer
46 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. ...
0
votes
0answers
24 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 ...
0
votes
0answers
816 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.' ...
1
vote
0answers
53 views

Deploy Custom App Page WSP 2010 in 2019 [closed]

Good morning, We are in the process to upgrade our 2010 environment to 2019 and we are trying to do an inventory of which solutions don't need to be touched to optimize before the upgrade process. ...
0
votes
1answer
23 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 ...
1
vote
1answer
352 views

Allow Users to Edit Ranges" does not work on Sharepoint 365

I have an excel spreadsheet (Office 365) that I need different users be able to update different ranges in the sheet. I would like this to work on SharePoint via excel online so the users can ...
1
vote
1answer
1k views

DlookUp Function in ACCESS Query

I am working on 2 databases that are linked together: Action Items List and UserInfo. I have imported the Action item List from my Sharepoint site. I am trying to display only the "actions" that ...
0
votes
1answer
1k 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 ...
0
votes
1answer
286 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 ...

1
2 3 4 5 6