Category Archives: Uncategorized

InfoPath, “Save A Snapshot”, and PDF print truncation

I ran into an interesting issue today with printing an InfoPath form. A customer reported a problem where her PDF printout was getting truncated off the right side of the page. She was using the File > Info option, and then using the Save As Snapshot to generate the PDF file. The resulting PDF file ran off the side of the page, and there was no InfoPath or Adobe PDF setting that I could find to fix the issue. Strangely, when I had her print directly to an Adobe PDF print driver, it worked fine…


After some brainstorming with the help desk, we discovered the underlying issue. In Windows 7, I’m running my text size at 125% instead of 100%. I was having the same issue as the customer. When I switched back to 100%, the printout was perfect.

So… if you end up with the same issue, I hope this saves you some time searching around InfoPath or Adobe. Just check the text size setting in your operating system.

Fixing the AllowDeletion flag on a SharePoint list or library

Today is the second time I ran into this issue, and I figure I better post it out there before I once again forget how to solve it…

I got a call from one of my customers saying that they didn’t have the option to delete a document library from Library Settings. Odd, as they had full control permissions for the site. When I looked (and I’m basically God when it comes to permissions), I didn’t have it either.

After some digging around, I found that there’s a setting called AllowDeletion that you can manipulate to keep someone from deleting a list or library. I’m still not entirely sure *how* that got get set to false in this case, but it was.

Following is a short PowerShell script you can use to fix that. The actual deletion of the library is commented out here, because I’d prefer just to set the flag and then delete it myself… less chance of something going wrong that way. 🙂

#This allows you to delete a list or library where the AllowDeletion flag has been turned off...
#Load SharePoint PowerShell Snapin
if ((Get-PSSnapin "Microsoft.SharePoint.PowerShell" -ErrorAction SilentlyContinue) -eq $null) {
    Add-PSSnapin "Microsoft.SharePoint.PowerShell"
$Web = Get-SPWeb ""
$List = $Web.Lists["LibraryName"] 
$List.AllowDeletion = $TRUE 

Reverting to a SharePoint 2010 default list form once it’s been customized…

20160122Image01.pngSo today’s adventure involved fixing someone’s custom list form that had “broken”. They said that it used to look one way, and then something happened and now it looks different and things at the top of the form are gone. Not a lot to go on, but that’s my job… figure things out based on people explaining issues in terms they understand.

After some thought and observation, I figured out that someone had gone into Customize Form on the list’s Ribbon Bar and saved/published a new version of the form. It’s close to the same look as the default form, but things like the Attach File icon and the buttons at the bottom of the form disappear. I also confirmed that the displayifs.aspx, newifs.aspx, and editifs.aspx versions of the forms (customized versions) were showing up as present in SharePoint Designer.

Now… how do I revert back to the default form?

It was easier than I thought… If you go into List Tools > List > Library Settings, you’ll see an option titled Form Setting under General Settings. When you open that option, select the Use The Default SharePoint Form option, and your customized forms will no longer be the default.


I tried to solve this earlier in the week for someone, and I ended up having to recreate the list from scratch and copy over the data. Obviously, this approach is MUCH easier…

Slides from SharePoint Saturday Redmond – Leading Your SharePoint Customers To Water… *and* Teaching Them How To Drink

Here are my slides from SharePoint Saturday Portlandia on November 14th, 2015. We had a good turnout, and I made it through the session even though I was nursing a cold.

I think the most enjoyable part of this is the discussions afterwards. I love how this content sparks ideas and the “I could do that” statements.


Slides from SharePoint Saturday Redmond – Leading Your SharePoint Customers To Water… *and* Teaching Them How To Drink

Here are my slides from SharePoint Saturday Redmond on October 24th, 2015. Thanks to everyone who attended, as well as all the great questions and comments afterwards. I really do like presenting this information. 🙂


Slides from Portland SPUG – Leading Your SharePoint Customers To Water… *and* Teaching Them How To Drink

Here are the slides from my presentation at the Portland SharePoint User Group meeting on 2015/10/21. Thanks to everyone who was there, and thanks for the positive comments and questions.


Copying from Word into a Content Editor web part? Please… just don’t.

This is a bit of a “drive-by” blog post, in that it’s not overly techie in nature. It’s just a plea to those who figure that pasting content into a Content Editor web part directly from Word is a great idea…

Please don’t. For both your sake and the sake of your SharePoint support person.

When you put content into a Content Editor web part, SharePoint generates all the HTML code behind the scenes so that things render pretty much like you see it on the screen… also known as WYSIWYG (pronounced whizzy-wig, and stands for “What You See Is What You Get”)

When you copy content from a Word document, it’s actually pasting the Word HTML into the web part, so now you have both the Word HTML *and* SharePoint’s HTML. Sometimes they play well together, and sometimes… they don’t.

If someone calls me and asks for help making a bulleted list look right because the third and fourth bullet have different spacing and they can’t seem to fix it, it’s usually because they copied the original list from Word, and then they tried to edit the list in SharePoint. Different HTML, different spacing…

If you’re hardcore and up to the task, you can open the Edit HTML option and wade through all the HTML, removing extra Word styling and tags. It’s not fun.

Or, you can take the content, copy it to something basic like Notepad, erase all the existing stuff in the web part, and then paste the non-formatted text back in. Format it within SharePoint, and things will be consistent.

I want your page to look good just like you do. But I really don’t want to take dozens of lines of HTML and clean things up for you. Just don’t copy directly from Word if you want to update the page in SharePoint later on.

Creating a repeating (looping) workflow in SharePoint 2010

Creating a repeating (looping) workflow in SharePoint 2010.

The workbook cannot be opened as it does not contain any visible named items

I got a report from a customer who was having problems opening an Excel spreadsheet in Office Web Apps. They were getting the following error:


When I tried to download it and open it on my desktop in Excel, I got this error:


After that, I’d just sit there with the Excel client open but everything was greyed out. I was thinking that there might not be any way to recover the file, as it was last updated too far back. But fortunately, I poked around the Ribbon bar and found the following option:


When I clicked that, everything showed up!  Whoo-hoo!

This link actually talks about the underlying reason as to why it happened, but I was more interested in mitigating the damage (which Unhide did just fine).