Tuesday, August 18, 2009

OneNote 2007 Taskbar Icon in Windows 7

After loading Windows 7 RTM a small issue I encountered was that the OneNote 2007 taskbar icon stopped appearing. Right now my temporary workaround:
  • In OneNote go to: Tools - Options - Other and uncheck the Place OneNote icon in the taskbar and then recheck the Place OneNote icon in the taskbar.

    OneNote Other Options
  • The icon will reappear in the taskbar after you reselect the checkbox

  • Unfortunately this isn't a permanent answer because it is gone again after you reboot.
I need to research this issue some more to see if I can find a permanent fix. There are some good notes about this in this OneNote blog about SP2. There was also a little more about it on Microsoft's blog.

Monday, August 3, 2009

Unleash the Power of OneNote and SharePoint

The notes for our Unleash the Power of OneNote and SharePoint presentation have been posted to the Captaré Training site and the video has been posted to the I Heart OneNote site.

Download the OneNote 2007 Package containing all of the notes here and view the video presentation from the I Heart OneNote community.

Thursday, June 4, 2009

InfoPath Column/Properties Promotion Limit

During our Captaré SharePoint InfoPath Training class today we got what I thought was a simple question:

  • What is the limit on the number of columns/properties you can promote to a SharePoint 2007 InfoPath Form Library from InfoPath 2007?

My gut response to this question was that it was the same column limit as a document library would have or maybe a SharePoint list. Quick research showed:

  • You can have:
    • 2,000 columns in a document library
    • 4,096 columns in a list

  • These are not hard limits, but you might experience library and list view performance degradation as the number of columns in a document library or list increases.

  • There are two good articles which detail the limitations of SharePoint. One in TechNet and a simpler one on this SharePoint blog.

After a little further research, I found that my gut response was wrong. The two relevant posts I found stated that the Form Libraries had the same limitations as the old SharePoint 2003 list limitations.

  • 64 Single line of text and Choice (drop-down menu or radio buttons)
  • 31 Multiple lines of text and Choice (check boxes (allow multiple sections))
  • 32 Number and currency
  • 32 Hyperlink
  • 16 Date and time
  • 16 Lookup
  • 16 Yes/No
  • 8 Calculated

The two references I pulled from were these posts:

I was not able to find definitive Microsoft articles or support backing these claims up. What did make me a little suspicious though is these are the same limitations stated in TechNet as WSS 2.0 and SPS 2003 had with lists and libraries. Why was this fixed with 2007 libraries and lists, but not Form Libraries?

If anyone has definitive Microsoft References for these limitations, please let me know.

The interesting corollary to researching this issue is I think it is part of another question we were asked today about a complex form timing out when they were trying to publish it. The issue as stated in the first post is the form probably has too many columns of a certain type in it.


Once you start trying to publish and use 25+ columns from InfoPath to SharePoint, you should start rethinking how you are using your data. A better long term approach is to:

  • Use InfoPath to publish the data to a SQL Server Database
  • You then have multiple view/reporting options:
    • Use data view Web Parts to view the data
    • Use SQL Server Reporting Services to create complex reports within SharePoint
    • Use third-party Web parts to view the data

Hope this helps everyone in our class and anyone else who may need it.

Sunday, January 4, 2009

Finding the Last Value in a Table Column Range in Excel 2007

I was trying to accomplish something I thought would be pretty simple in Excel, finding the last value in a row within a range in Excel.

I was using a balance column and just wanted the last value (the balance) to show up in my totals row at the bottom, thereby when I filtered the list the value would still be the outstanding balance for the whole list.

There were a couple of options I found through Googling, but I didn't like any of them as they didn't work well with blank rows.

My resolution was to format the range of cells as a Table with the "Format as Table" option in Excel 2007.

By doing this it creates ranges for each column. My table looks like this:

To get the last value in (C7) for this table I used this formula:

=INDEX([Balance], ROWS([Balance]),1)

By using the Rows function here it gives me the last row within the range I am looking for and then the index provides the value.

Sunday, April 13, 2008

Tracking Time with WorkTime

One of the toughest challenges we have in consulting is not doing the things we enjoy like developing and creating solutions it is tracking the time it takes to do those tasks.
In my everlasting quest to find an application that tracks everything I do by reading my brain I found something pretty close. An application called WorkTime is a very innocuos little application that tracks what you are working on and the documents you are working along with a time stamp and a ton of reports.

The application can be found on a company called NeterSoft's web site:

I combine that will a nice little application that easily exports my Windwos Mobile phone log called CallHistory export which is located here:
I have a custom spreadsheet that I used to tweak the CallHistory download and provide an easier to read report and I plan on adding graphs to it. I can upload it if requested.

Lastly, I utilize my Exchange Calendar to track my external meetings and voila, you have about 90 percent of my workday covered and I can usually track the rest from memory.

I tried Microsoft's Journal and it does not do a good job of providing easy to use reports or track non-Microsoft applications, and I really liked this new application called RescueTime, but it does not do a good job of telling me what I worked on during a certain period of time.

I'm a big fan of WorkTime and hope to post some more tips and tricks in how to use it.

Monday, February 11, 2008

OneNote Blog Test

One of the issues I wanted to figure out was how easy it is to publish from OneNote any blogs I create.

  • OneNote converts its information to Word (using 2007) and
  • Then you publish it from Word's BlogPost tab.

QuickBooks Issues

I have had some substantial QuickBooks issues which have prompted me to create a blog to allow other people to learn from some of the adventure I have had in getting QuickBooks to work correctly. I will add to this blog soon as I learn to get around it better.