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 if there was a way to possibly shrink the files, so I ended up finding something here:
In PowerPoint 2016 you can find the option here:
After doing a bit more digging, this actually applies to all Word, Excel, and PowerPoint versions from 2016 on down to even the Office 2010 versions.
So now I’d be curious if this could be automated somehow to do some major cleanup in PowerShell or something? Hmmm… maybe for another blog post later… hehehe.
Hope this helps if you need to free up some space in the future.
Recently I ran across a really tough issue that I had with one of my workflows that kept failing right before the approval step of the workflow was being sent.
Below is an example of the workflow I had with the listing of the error I was getting:
I tried going over this many times and even went and created a whole new list for this and imported the workflow into this new list with a newly build form to make sure I could minimize any other variables in the error.
Well the bad news was even in the new list I created and imported the workflow into, I still got the same error. So, I started digging in with some help, and was ultimately able to find the source of the issue on the step of the set item permissions in the workflow.
It turns out that when this workflow was originally created the set item permissions had several users explicitly defined in it to grant permissions to the item on before an approval would take place.
What I didn’t realize until I looked deeper into who all was being given access to this item was that one user who was specifically designated in the action was no longer with the company.
So, when the workflow would go out and try to match this person with a valid AD account, it would error out and not allow the workflow to go any further.
The location of the error was in the ULS of SharePoint, but only when verbose logging was turned on, of course…
So in the future I will always from now on, check to make sure that all users being granted access to items in workflows have valid accounts.
If you ever run across something like this I hope this tip will save you sometime and allow you to get right to the solution.
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 feeling when you demonstrate something to someone in a training session and then see what they are able to go and create on their own.
In this case, though the user had designed a great looking form, but when they went to submit the form once it was complete it gave the following error:
Which was very odd as I had never seen an error that gave all zeros for a correlation id on and error in SharePoint.
So I started to do some digging online and I noticed this was a common question that has come up before for several users in the past, but no one online I had seen had dealt with this in the context of creating and submitting forms.
After some more research I had a hunch that this was being caused from a required field on the form that was missing data when the form was being submitted. So I checked the form in Nintex form designer, and sure enough!
I saw that the “Title” column was not on the form, but in the list settings was still set to the required option like it is out of the box in SharePoint.
So I went into the list settings and turned off the required setting for this column and then went back to the form and tried submitting it again.
Everything submitted as it was supposed to and now I can move onto more form troubleshooting.
I hope this helps anyone else who runs into this error again and if you have any thoughts or comments, please feel free to add them into the blog.
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 company that would visit this site.
There are multiple ways actually to do this very method, but the one I ended up going with is referenced in the following article:
After doing this one the page it gave a pretty good layout on the page. My only concern going forward is having to update this manually and having to possibly retrain someone to keep this showing the most up to date info on the page.
There are other things I would like to research as part of this like putting in zoom or other capabilities in the code to modify the view of the pdf for the users.
I hope this gives you more ideas for displaying info on sites and pages and should work regardless of what version of SharePoint you are working with.
If you have interesting ways to display reports or other objects on pages, feel free to add to this in the comments below.
Beau Cameron just posted a fantastic article about how to do this in O365. Here’s the link:
Well for the first day of ignite, I can pretty much sum it all up in one word. Wow!
To begin the day with the keynote of the conference in an arena with 20,000 other people was truly amazing. If you would like to watch a replay of it, you can find it here:
Then from there, it’s an even more frantic day moving from session to session.
One great talk I attended was the roadmap update for SharePoint 2016 given by Jeff Teper and several other MVP’s. the link to this presentation is here:
Some great announcements coming out from this talk were for me the great ability now to do zero downtime patching in SharePoint 2016 with a 4 or even a 2 server farm. People will be able to do this with the new min role combo roles that they have coming out in November of 2016.
Another area of interest for me will be all of the new functionality and features given to Power Apps and Flow as well as more features being added to the mobile apps for SharePoint and others.
love the fact that Windows Server 2016 is now released to the public and out of tech preview! This means that everyone will now be able to bring up farms and other resources on all the 2016 products.
There were so many Azure related announcements, it made my head spin, so I will try to find a summary link and post it below.
Another highlight of the day was seeing the future of a lot of technologies in the innovation keynote. The link to that session is below:
They even brought Deon Sanders out on the stage to talk about playing fantasy football with an AI. Now that’s pretty cool.
As the videos and links to other talks become available, I will add them to this post. Now it’s time to start day 2 of ignite.
This past week I attended a SharePoint Admin survival course and it was a great training event to learn SharePoint and everything related to it.
The main reason I wanted to attend this training was to get familiar with the new content for SharePoint 2016 and to get familiar with what it takes to implement a hybrid environment for SharePoint.
The content of this class was excellent, but the best part of the course for me was actually going through and configuring a test environment on premises and in the cloud and connecting the two. This was something in the past I wasn’t sure how to replicate and it was a great learning experience in the class.
We covered other topics like Hybrid One Drive and Sites (more like site pages), Hybrid Search in 2016, Configuring a workflow server, setting up Office Online Server (formerly Office Web Apps), and many other areas that give a good foundation to be prepared for SharePoint 2016.
There’s so many different aspects of SharePoint that could be focused on in this course, but I felt like that this had something if you are a beginner or if you have a few years (and grey hairs on you like me), there is plenty of information to be absorbed.
I would even recommend this course to those people not on 2016 yet. 2013 has plenty of presence and discussion in this course because while Microsoft has improved many areas in the newest version, the foundation of much of the product is still rooted in the functionality of 2013.
Lastly what you take away from this course is confidence. Confidence that you are better prepared for all SharePoint has to offer. You also get a great pool of scripts, links, articles and reference material that will take me a long time to digest thoroughly. If you have a chance to take this training, jump at it.
So I ran into a frustrating situation lately where my users when they tried to open a pdf in SharePoint, it would launch the pdf in the browser correctly, but at the same time it would open acrobat reader in the foreground with an error message.
This was aggravating, because I could not figure out what setting I needed to modify in order to force acrobat reader to go away without digging deep into acrobat reader.
Well turns out the solution is pretty easy to fix and has to do with an add on in IE.
To correct this issue, go under IE, then manage add ons. Then find the following add on:
Select this add on and then choose: “Disable”
Once you do this, then close the add on window, then all your pdf’s will open in the browser window without getting acrobat blocked any more. 🙂
Hope this helps! Enjoy!
This past week I had an issue of some of my Nintex workflows just not running for some reason. They would get to a certain point and just decide not to complete the next step.
Recently i added a new application server into my farm and I did not realize that in order for these workflows to run correctly they needed to have the Microsoft SharePoint Foundation Workflow Timer Service only running on the web front ends (web servers), since that is where the Nintex service actually runs.
So if you are running Nintex Workflow in your farm and you have a multi-tier farm for your SharePoint setup, go to central admin and check your service settings like below:
To be clear once more, this Should be running on your web servers if you have Nintex workflow, but should not be running on your application servers.
I found this out the hard way after having to contact Nintex support one day.
Hope this helps others,
Back on June 21st, I had the privilege of attending my first event of the year in Atlanta at the Georgia State University Student Center.
You can find out more about the event by going here.
The twitter feed for this event was #SPSATL and if you have a chance, I highly recommend you go back and check out all the content that was related to this one.
While I was there I had a chance to check out the following sessions:
“Anatomy of an Intranet” by Michael Greene Twitter Blog
“Use SharePoint as a viable Hybrid Approach to your Enterprise” by Eric Harlan Twitter Blog
“Windows Azure as a SharePoint Farm Restore Rehearsal Space” by Tyler Bithell Twitter Blog and Pablo Montequin Twitter
“The White Hat: hacking SharePoint On-Prem from Google Reconnaissance to Metasploit” by Joseph Irvine Blog
“Business Intelligence with SharePoint 2013 and SQL 2014” by Ivan Sanders Twitter Blog
My personal favorite of the day was the session on hacking SharePoint by Joseph Irvine. It gave me chills as to some steps I should be doing with my own SharePoint farms, but also gave many examples of businesses and organizations that show they just click next, next, next and then quit maintaining their servers.
Shame on them and shame on me too! Security for the most part isn’t too difficult, it just takes extra time that most people don’t have the time for. Until they get hacked or pwned.
The folks in charge of putting on this event did a great job! I look forward to these events whenever I can go because they always line up good speakers who can give you FREE training on something you want to learn more about. If there is an event going on close to you in the future it’s worth a tank of gas and a Saturday of your time to better yourself. Now go sign up!! 🙂
To learn more about upcoming events for SharePoint Saturdays head on over to http://spsevents.org