Search the Community

Hi Team, I am trying to create an excel file which is hosted on sharepoint which does the following purpose: 1. It maintains records of each file and folder of a sharepoint document library (has links to access every file/folder) 2. If any changes are done in the document library, the excel file should synchronize automatically with this updated change. I am trying to achieve this with power automate but I am finding it very hard to do so since I am quite new to this. Can some experts please guide me on how should I approach this? I have found resources to do this with document lists but nothing for document library and excel. Thanks.

Hello all, I'm sort of the tech for a small ~8 person consulting company. We take heaps of photos and we're out of SharePoint storage to store them all. Currently we have ~1.7TB of documents, this number will continue to expand and Microsoft charges about $200/TB/M....which is insane. We obviously have to pay that until I get our libraries cleaned out to below 1.13TB total. Anyway, knowing that most of our data is photos, excel documents, and pdfs..... and that we don't really need to refer to older than current year stuff very often.... I think it would be best if I built some cold storage and moved all those old photos and documents off SharePoint/OneDrive. I could probably swing a budget of $1000, but we'd obviously want to be go as low as possible. What kind of system should I be looking at here? A NAS? Something self built? I have a feeling a NAS will do this job well, the question seems to be what brand and if the software allows for remote access by a predetermined set of users (and what networking equipment, if any, might I need to enable that securely?)

Hello there, I am hoping some members in the community here may have some experience with what the title suggests, I'll lay out the situation below: I am an IT admin for various schools in the South West of the UK, the Main school I work at however is what I am having issues with. The network there is a plain and simple Vanilla Windows network with each user getting their own user account and an email with Microsoft Office 365 A1 Plus. With Corona Virus still lurking and likely to be lurking for a while, I have moved my whole workplace/school environment over to Microsoft Office Online, SharePoint and OneDrive so that my user base does not rely so much on the storage, servers and internet connection of my work place/school. Albeit what I have got is still very quick but that's not the point, it just gives me plenty of wiggle room in what I do as well as overhead and plan B options. The Microsoft Office Online Suite was working absolutely fine whilst everyone was working from home and whatnot. However, with students and staff being back in schools at the moment, everyone is trying to access the whole of the Microsoft Office Online and more from within the school through their browsers which is not ideal and has brought up some major headaches for me. Before I made this move, Students used to get their own mapped drives including to the shared drives that now exist within SharePoint, my problem is that with having moved the drives up to SharePoint, the students can no longer gain access to said mapped drives through file explorer since the drives are not internal to the network. Students cannot save files directly to the computer as this is what the mapped drives were for, but since they are gone then the students can no longer save locally, at which point anything outside of the Microsoft Office Online Suite is currently out of the question. So here's my question: Is there a way I can map the areas I want from SharePoint to the students within Active directory? I ask because I am currently running into issues with the drive maps not recognizing the pupils logged in, at which point the drive has a simple red cross on it and it won't bring up anything to authenticate them. I understand that the simpler option is to let the students use OneDrive for Business but then this stores a cache of each users area on each computer, storage on each machine would go through the roof which is not what I want. I look forward to hearing some of your answers, experiences and/or solutions. Cheers, Brennan.

Good afternoon! I am currently needing to clear up Sharepoint space, but luckily have server hardware running for a project that ended up being abandoned. I am looking for some information on the best practices for getting the server set up to host a lot of this data as an archive to get it moved off the Sharepoint site and avoid having to spend more for more cloud storage. I'm also sick of getting an email every day that I'm out of space. So, essentially, I was hoping to get some guidance on the local server setup, and any information/tips for pulling the data down from Sharepoint (the current plan for pulling the data is going to be download a chuck, verify data integrity on the server, then remove from Sharepoint. But that's going to be a long process for multiple TBs of data, so if there's a better way please let me know). My plan is also to get a license for the Sharepoint local front end for the archive server, but will probably wait to see how much the old data is even used before I spend money on that. Apologies if this is posted to the wrong place.

Good afternoon! I am currently needing to clear up Sharepoint space, but luckily have server hardware running for a project that ended up being abandoned. I am looking for some information on the best practices for getting the server set up to host a lot of this data as an archive to get it moved off the Sharepoint site and avoid having to spend more for more cloud storage. I'm also sick of getting an email every day that I'm out of space. So, essentially, I was hoping to get some guidance on the local server setup, and any information/tips for pulling the data down from Sharepoint (the current plan for pulling the data is going to be download a chuck, verify data integrity on the server, then remove from Sharepoint. But that's going to be a long process for multiple TBs of data, so if there's a better way please let me know). My plan is also to get a license for the Sharepoint local front end for the archive server, but will probably wait to see how much the old data is even used before I spend money on that. Apologies if this is posted to the wrong place. Budget (including currency): $0 Country: USA Games, programs or workloads that it will be used for: Data Storage Other details (existing parts lists, whether any peripherals are needed, what you're upgrading from, when you're going to buy, what resolution and refresh rate you want to play at, etc):

Hello all, I manage Office 365 for a small consulting company. We are currently using about 1.5TB of data, mostly photos, word docks, and spreadsheets all stored in various SharePoint Document Libraries. SharePoint estimates we will consume our current 3TB plan in 6 months at the current rate of data usage. We are able to offload data to local storage as old projects wrap up and buisness years conclude, so our OneDrive space is fine as long as we offload data eventually. While OneDrive/SharePoint offer many tools for recovering data and allegedly have good backup systems, that does not help us if OneDrive goes down or we can't access it for whatever reason. While the risk of data loss is low, I'd still like to have a local backup of all our data so I'm looking for the best way to go about doing that. Currently, there is no method (that I am aware of) of incrementally backing up OneDrive/SharePoint data. All that can be done is to manually download a whole library and copy it. So at this moment, every backup is going to consume 1.5TB of disk space. That gives us 8 backups at whatever frequency we determine on a single 12TB drive, which costs ~$300. Keep in mind, some data we must retain for about 5 years, but we would like to retain all data for as long as possible. My current plan is to put together an inexpensive desktop with enough HDD storage to store all our SharePoint Libraries locally, then copy that data to a NAS where it will sit. What NAS I should order/build is up in the air. As are a lot of things like: How often should we make a backup? Every month? Twice a month? How many bays is enough? A NAS gets pretty expensive real quick and so do drives. Does the NAS need to be in RAID since we're backing up an already pretty reliable service? RAID seems like it would complicate decommissioning drives when we still want to store the data on those drives. When do LTO tape drives start to make sense? Boss won't be happy about the bill for a project like this, but as the company grows in the future this becomes serious and I'd like to have that security. I realize this is kinda intense, but any input would be great!

Hello all, for some context, I am my works sole IT guy. I have maintained and deployed Microsoft 365 for us coming up on 3 years ago. We're a small business, only 8 people. We mostly use the SharePoint/OneDrive features of Microsoft 365, being able to do file collaboration in the field is extremely important, so OneDrive or other cloud sync services are literally the only way we can do our inspections. While most of our production data is duplicated on other services (we have two programs we use to do surveys/run reports) the original data (floor plans, photo, excel matrices, and field notes) are all stored in our various SharePoint libraries. Not only are inspection related documents stored in SharePoint/OneDrive, sensitive company info is as well. Info such as client contracts, payroll info, etc. All in all, we have approximately 1TB of data that has been generated since I deployed M365. While the chances of data loss or data breach are low (we use 2FA, only myself and 1 other coworker have admin access to anything, and OneDrive has great protections against mass deletion and ransomware) I would still like to host a backup of some sort. Unfortunately, OneDrive does not really have any backup tools built in. The only real means is to download copies of your whole libraries and archive them, the problem with that is the storage requirements quickly balloon out of control and the process is entirely manual. I recently discovered Backblaze and have considered using it as our primary backup. To do this, I would build/buy a low power desktop (probably a Mac mini), connect it to a drive enclosure or use its local storage and sync all document libraries locally. Then Backblaze would backup up that whole computer and the drive with all the SharePoint/OneDrive data. In the event of a ransomware attack, even though the local copies would eventually be encrypted as the changes trickled in, I could wipe any affected systems and restore 100% of our data to prior to the attack. We would pay for the basically free forever version history feature of Backblaze to meet any possible data retention policies I may have to comply with that I don't know about. This method would also allow us to access our data even in the unlikely event that OneDrive is not available for any reason or if accounts are somehow compromised and we get locked out. What are your thoughts on my approach here?

So let me start off by simply saying that I have no idea what I'm really looking for so I'm going to have to ask this question in a pretty broad manor and I hope this is the right place to ask. Basically, the small business I'm working with has two locations about 500 miles apart and they need to keep in touch with each other. One location keeps track of incoming product and specifications of said product and the other location has to use that information pretty much as soon as it can. Currently, the setup we are using is through Google drive because we need the availability to edit on both sides and the live update/ sync and to be able to view what another user is typing is key. However, if this method worked well, I probably wouldn't be here asking this question. What we're looking to do is upgrade to have a small business server, either physically in our office or elsewhere. We would like to use that server to have excel spreadsheets that live updates like google sheets does but that also has the ability to utilize macros. We basically need it to update as immediately as possible and to be reliable. Looking into it briefly, a few people have recommended using sharepoint but I'm not sue what that is or how that program works. Any input would be greatly appreciated.

My parents run a business that consists of 5 desktop machines that are all managed by a relatively old Dell Poweredge running Windows Small Business Server 2012. There Is a 2tb raid 1 shared as network storage where they store all the files. They work with a tech company that wants to charge them $1200 USD to "Untangle the machines from the server" and move there files to SharePoint. Which to me, seems like way to much. So as an alternative, I am thinking about getting two identical servers with 4+tb of raid, one at there home, and one at the business. And do the type of thing linus did a while back and have the home and server sync creating an offsite backup for both the home and the business. The business computers would store there files on the new NAS and the home computers would backup to the NAS. I feel this would be cheaper than going to SharePoint, and would allow them to work regardless of internet conditions. Plus they get an offsite backup both at there home and business. The idea is that it costs less the $150/mo for SharePoint, and find a way around the "Untangling Fee." I'm not experienced in real world business examples, but ive created NAS like soloutions at my house before. What could the "Untangling" fee actually be for, and is it something I could do myself? I imagine its just creating locla logins for each computer. Any suggestions about having two local NASs rather than just using SharePoint or some other External file sharing/backup system? I hope I was clear in my writing above. How have you guys handled similar situations? Do you have an in home NAS?

Does some one know a good tutorial or cursus to develop a sharepoint site?

Hi Everyone, I'm trying to think of what the differences are between Excel Online, Sharepoint and OneDrive. The main purpose behind this question is ... what does the calculations for the formulas on the spreadsheets for each of these methods? I have a group of people simultaneously working on spreadsheets and Google Sheets isn't working out for us due to the amount of data and formulas that calculate the stuff on Google Sheets. Afaik, we have Office 365 ProPlus. I don't know if that's inclusive of all of those three methods above but I suppose they do. Thanks!

Evening all, Having a bit of an issue instaling SharePoint 2013 on a server running 2008 R2 Enterprise. I'm getting an issue which most people seem to get when installing on 2012 R2 which relates to IIS and ASP. The error I get is this: "Application Server Role, Web Server (IIS) Role: configuration error" Looking at the log files we actually get a little more info, but not much. "2015-04-18 23:46:13 - "C:\Windows\Microsoft.NET\Framework64\v4.0.30319\aspnet_regiis.exe" -i 2015-04-18 23:46:14 - Request for install time of Application Server Role, Web Server (IIS) Role 2015-04-18 23:46:15 - Request for install time of Application Server Role, Web Server (IIS) Role 2015-04-18 23:46:16 - Request for install time of Application Server Role, Web Server (IIS) Role 2015-04-18 23:46:17 - Request for install time of Application Server Role, Web Server (IIS) Role 2015-04-18 23:46:18 - Request for install time of Application Server Role, Web Server (IIS) Role 2015-04-18 23:46:19 - Request for install time of Application Server Role, Web Server (IIS) Role 2015-04-18 23:46:20 - Request for install time of Application Server Role, Web Server (IIS) Role 2015-04-18 23:46:21 - Request for install time of Application Server Role, Web Server (IIS) Role 2015-04-18 23:46:22 - Request for install time of Application Server Role, Web Server (IIS) Role 2015-04-18 23:46:22 - Install process returned (0) 2015-04-18 23:46:22 - [in HRESULT format] (0) 2015-04-18 23:46:22 - "C:\Windows\system32\cscript.exe" "C:\Windows\system32\iisext.vbs" /enext "ASP.NET v4.0.30319" 2015-04-18 23:46:23 - Request for install time of Application Server Role, Web Server (IIS) Role 2015-04-18 23:46:23 - Install process returned (-2146646015) 2015-04-18 23:46:23 - [in HRESULT format] (-2146646015) 2015-04-18 23:46:23 - Error when enabling ASP.NET v4.0.30319 2015-04-18 23:46:23 - Last return code (-2146646015)" There are hundreds of pages suggesting fixes if I was using 2012 R2 but I'm not and even so none of them work or are applicable. Anyone with any suggestions? I've been at this for 5 hours now.

Hello, I recently set up a SharePoint server it works well for computers connected to the domain however when I try to access the site (not the central administration site the sites created for projects) I am unable to do so, this is most likely an issue with how I am trying to do it so some advice would be highly appreciated. Info: -server: Windows server 2012 standard -SharePoint 2013 -SQL server 2012 While I know it is not good practice this is all running on the domain controller (we have a one server environment). What I am doing: application management>create site collection -I then choose my settings and use /sites/"name" and enter a user and secondary >OK my problem is that I don't know how to access the site after it is created, even on the local domain I can't just click on the provided link i have to go through a process that seems to change every time. How to I access the site? One more thing: we have DyDNS setup at "example.test.com" and the site creator give the link as "domain/site/test" Thanks!

So I thought I would post my frustatration here to let you all deal with it. Simple Question: WTF is up with schools these days? Background: I am a full stack developer for a company that creates and supports applications for agencies under HHS (US gov). In school I was hammered with Java from 9th grade through college (I am still in college while I work fulltime). Well ... when I got my current job I was tasked with a dashboarding application. I of course chose to go with Java and made a Java applet that I could load in the browser for our customer. After months of work and two all day-ers at the end ... I was ****-slapped in the face with the notification that the government (at least HHS does not support browser based applets). So WTF?!?!?! Now I have changed paths and have sharpened my c# skills. I have leanred to deploy web apps into AWS GovCloud that can be consumed by government agencies and have begun making custom SharePoint deployments. But still ... wtf was I learning all of the Java syntax throughout my school for? I thought this was a due rant because today Stanford announced that it was changing many of their computer science classes from Java to Javascript ... good for you Stanford! Just seems like if you are not making phone apps or creating applications that run locally ... Java is not what we should be teaching our kids. Learn something universal and that is common in both commercial and government enviornments ... Javascript! So ... tell me I am a dumb@ss or back me up and tell me that you are just as frustrated as I am in this.