Compare 2 similar Excel files with the Inquire Add-In

Note: this was only tested in Excel 2019. Office 365 Pro Plus has something called Compare sheets similar to this function I had the need the other day to compare two excel files that had some information in them from exported SharePoint lists. They were very similar, but I didn’t know of a good way […]

Handling large lists with SharePoint on premises

If you have spent much time working with SharePoint, you know that once a group of users likes it to store information in libraries or Lists, you can certainly tell. Ultimately what happens is you get an email (or call, or service ticket) one day that says “Hey we are getting some kind of error […]

SharePoint resources for demos

Today’s post I thought I would include in order to find anything needed to create a working demo of SharePoint locally. Nowadays,  Azure or other cloud providers make this much easier, but if you want more control you can spin up your own locally. Windows Server 2019 (still beta as of now) https://techcommunity.microsoft.com/t5/Windows-Server-Insiders/bd-p/WindowsServerInsiders 2016 https://www.microsoft.com/en-us/evalcenter/evaluate-windows-server-2016 […]

Office Files too big? Inspect them!

Today I had a problem with a group of users that were trying to work with a very large PowerPoint file in SharePoint and didn’t realize until I downloaded a local copy of the file that it was too big to work with through Office Web Apps. So I did some digging around to see […]

SharePoint giving all zeros for correlation id

I had an interesting error come across today when I was working on a new Nintex form list. I have been doing some power user training in my company lately and a few of my users have taken the plunge and started creating their own electronic forms in Nintex. Which is awesome! It’s a great […]

Creating sample data for SharePoint with SPDG

If you work like I do trying to setup test environments in SharePoint often, the experience is great when you finally get all the bells and whistles activated for the features you need to test, but then what? Now you have a great looking environment with no data! A SharePoint farm with no data in […]

No time for documentation? Get SPDocKit!

For many people who work in development and IT there tends to be one universal truth that I have seen time and time again. People setup and spend lots of time and money creating great software systems for businesses and other organizations, but when it comes time to document where things are and how things […]

Displaying pdf reports in SharePoint

I had an interesting request by someone the other day. I was helping them set up a new site template for SharePoint 2013 and they wanted to display a couple of reports on their site that they had in pdf format in a way to showcase the numbers of the report to others in the […]

ChattPAC wrap up

I wanted to take some time and just thank everyone who came to hear me talk about SharePoint today at the Chattanooga Portals and Collaboration user group. I really enjoyed the stories that we all shared and some of the ideas we threw around to get more people talking about SharePoint in our corner of […]

KB2775353 fixed with KB2817570 for SP2010 Server

  Hello again from SharePoint land! It’s been a while since we talked about KB2775353 and how it made our SharePoint 2010 servers where I work extremely sad and kept them from correctly displaying our BI dashboards in 2010 (see here). I was originally told when I found this bug that the fix would be […]