Short notes

If you need to create pivot tables based on a dynamic named range that will expand as you add additional rows of data you. If just selecting complete columns blank values will show up in the pivot filters. Basically an easy formula can be used therefore: =OFFSET(Sheet1!$A$1;0;0;COUNTA(Sheet1!$A:$A);4) Further information for the offset formula can be found on the blog. # 16. November, 2015
There are several discussions going on about the latest updates of the apple products. iPad pro seems to be a handy and well designed product. Even the price seem to be ok, comparing it to its direct rivals like the Surface it is competitive. The iPhone changes are only slight and with the apple tv, apple is trying to get into the gaming and tv market. Currently missing is the real innovative character of these updates. Beside some smaller features in the products themselves no real new innovations are presented. Therefore we can expect the e-payment or the car sector:) # 10. September, 2015
When installing the preview version of windows 10 using an USB 3.0 flash drive note that the Windows 7 usb dvd image creation tool will not work. The result is that when trying to boot the PC from the USB drive the screen will flicker once but will return to the boot device screen of bios. (more…) # 8. July, 2015
There is a very good post on multilingual contents in Office 365 by Vesa Juvonen. The described approach uses CSOM, and shows how to have mulitlingual Site titles, description, content type nams, column titles ...: # 27. April, 2015

Thomas Tropper

IT- and Social Media Business Analyst, Project Manager, SharePoint Consultant and Development.After finishing my Public Management studies in 2006 beginning to work as IT consultant in the field of public sector consultancy. Back then project in the role of project supervisor - also responsible for the implementation of SharePoint based collaboration and social media projects.