What is SharePoint?

SharePoint is a part of Microsoft365 (formerly Office365), just like Word, Excel, PowerPoint, etc. SharePoint is an internet-based service that can be accessed directly on your computer by installing the OneDrive App. SharePoint can also be accessed through a web browser if you are using someone else’s computer. SharePoint is compatible with Windows, macOS, Android and iOS. If you are using a Linux computer, like a Chromebook, you can access SharePoint through the browser as there is no official app for Linux. SharePoint is included in the university’s subscription to Microsoft and every department has 500GB of storage available to them.

UConn’s data storage background

Faculty, staff, and students who were at UConn prior to 2023 are familiar with the P Drive and the Q Drive. These drives are different than SharePoint because they existed on campus. In the UConn datacenters, there were specialized computers, full of hard drives, that acted as personal and shared storage (the P and Q Drives respectively). Whenever someone signed into a university computer on campus, that computer would reach out to the datacenter and link them with their files. This allowed users to begin their work on one computer, and then continue their work on another.

However due to the nature of these files and the ecosystem they lived in, they could not feasibly adapt to the changing workplace. These files were physically on campus, and you needed to be on campus in order to access them. Or, users could use a VPN (virtual private network) to have their computer behave as if it were on campus. With the Q Drive, different users could not edit the same file at the same time. When one user had the file open, the system would place a lock on the file until the first user closes the file.

Advantages of SharePoint

In 2023, UConn expanded its use of Microsoft365 (formerly Office365) by incorporating SharePoint into daily use, replacing the legacy Q Drive system. SharePoint is hosted on the cloud (internet based, not physically on UConn campus), this means a VPN is no longer needed to access your files. This also means that any computer connected to the internet can access the files, whether it is a university computer, a personal laptop, or even a smartphone/tablet.

SharePoint allows for multiple, simultaneous editors in Microsoft365 files (Word, Excel, PowerPoint, etc.). Unlike the legacy Q Drive system, SharePoint can recognize when multiple users have the same file open and will allow multiple users to edit the file at the same time. This means a user typing in a Word document will see their coworker typing along with them. This allows users to divide the work and to collaborate in real-time. If you have used Google Docs in the past, this is a familiar experience.

When you share/email a SharePoint file, you’re giving access to a file, you’re not sending the file itself. The recipient of the share will have a link that they use to access your file; the updates they type are saved to the file in your SharePoint. This, along with real-time collaboration, solves the issue of sending files and creating discrete copies in the process. When it is time to revoke access, their access link stops working, and they no longer have access to the file. In the past, when emailing a file to someone, they would have a copy on their own computer that would not update your original file. When it was time for them to send their updates back, you would then have two copies of the file. However, if needed, you can also include your file as an attachment and the recipient will receive a discrete copy that is not connected to your SharePoint.

SharePoint is a part of our university Microsoft accounts, which means your user-presence is tightly integrated with your UConn account that you use every day. Sharing files with another university member is as easy as knowing their name. If sharing with a university member, their name will appear in SharePoint share fields. However, if you’re sharing with someone outside of the university, you simply need to know their email address.

What is the relationship between OneDrive and SharePoint?

OneDrive vs SharePoint

What is the relationship between SharePoint and Teams?

SharePoint's Relationship with Teams

How much storage space do I have?

Every department has 500GB of available storage. But how much space is this really?

1GB (gigabyte) is 1,000MB (megabytes)*.

For reference: a standard 4-page Word document, without any pictures, is less than .05MB, and you have 500,000MB available.

*Depending on the computer system, the values above are expressed as either 1,000 or 1,024. This does not affect your usage of SharePoint or your computer.

Is my data safe?

SharePoint offers an encrypted file storage solution. Your files are encrypted during travel (downloading / uploading) and while at rest (the file is sitting on your computer or the SharePoint cloud). But what does it mean to be encrypted?
You can compare an encrypted file to a secret message you are sending to a friend. Beforehand, you both decided on a cypher that you will use to scramble your secret messages. Now, when you are finished writing your secret message to your friend, you scramble all the letters using the cypher. When they receive the letter, they use that same cypher to unscramble, or decrypt, the message. If anyone were to intercept the letter, they would have no idea what it says.

When uploading / downloading files, a 2048-bit encryption key is used. This means there are 2²⁰⁴⁸ possible combinations to decrypt your data. This would take a computer 300 trillion years to unscramble without the cypher.

On the other side of this coin, what if a user makes a mistake on a file? SharePoint keeps up to 500 versions of each file. This is called Version History. Every time someone opens a file an invisible copy of the file is saved. If needed, you can restore the file to this invisible copy. Let's say the coworker opens the file and believes you want them to delete an entire column in Excel. They delete the column and then save the file. Next week you discover the mistake, however you do not worry because you know that you can go back into the file’s history (versions) and restore the file to a previous point in time. To learn more about version history and when versions (restore points) are captured, view the guide below when you are done reading this page.

How do I access my data?

ITS recommends that you “Add shortcut to OneDrive” from your SharePoint with your computer. Doing so will allow your SharePoint files to appear in File Explorer (Windows) and Finder (macOS) as if they were on your computer like any other, non-backed up file.

However, if you are on a public computer, like one at your local library, you can simply use the SharePoint website to have full access to your files. Be sure to log out when you are done!

Any files you add to SharePoint can be accessed by other members of the SharePoint site. You do not need to manually share these files with your department coworkers.

Where does my data actually reside?

In SharePoint, you will see the terms “local” and “online-only” very often. What do these terms mean?

• When a file is “local”, that means the file is physically on your computer. That file is on your storage drive (general term for “hard drive”, “hard disk” or “SSD”), taking up space. If you were to sail out into the middle of the ocean, you would be able to open and edit the file without issue.

• When a file is “online-only” (you can also consider it to be “remote”, to contrast the previous term), that means it is not on your computer, and you need internet access in order to open and edit the file.

SharePoint has a feature named Files On-Demand that automatically handles the transition of files from online-only to local, and vice versa. With On-Demand enabled, only the files that you are working on will consume space on your storage drive. This feature is enabled by default when you first install OneDrive.

A real-world scenario: I have tons and tons of files on SharePoint. I log into my laptop and open the SharePoint folder and I see every folder that I own in front of me. I dig into a couple folders to find the Word document I want and double-click on it. The file automatically downloads from SharePoint and then opens in Word. This file is now local, it can be edited and then saved once more, and it is consuming space on my storage drive. When I click on Save, my changes are automatically sent to SharePoint. I then close Word. If I do not touch that document again within 30 days, it will remove itself from my computer and return to online-only. It is no longer consuming space on my storage drive. If I need to edit the file again, I double-click on it, and once again it downloads to my computer. If I edit the document again 10 days later, the 30-day timer resets.

This is how “Files On-Demand" works. The files appear as if they are on your computer allowing you to double-click them. Once double-clicked, they download to your computer so you can edit them. Once the file goes 30 days without interaction, it silently removes itself from your computer and returns to an online-only state and frees up the space on your storage drive that it was using.

Recycle Bin

With SharePoint, all users have access to a Recycle Bin. Users of the legacy Q Drive will know that this was absent in that system; those users needed to reach out to ITS to receive help in restoring their files.

When you delete a file in SharePoint, it will sit in a user-accessible recycle bin for 93 days. If a file is manually deleted from the Recycle Bin, it is sent to a “second-stage recycle bin” where it will sit for another 93 days.

Training Opportunity: Video Course (July 2021)

Related Help Guides

• SharePoint - help homepage: Microsoft SharePoint

• Sharing files - homepage:

• Where does my data actually reside? -