Microsoft has just announced they have released a tool that allow admins to automatically crawl users computers and import PST files into Exchange Online or Exchange 2010.
Download http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=28767
Thanks to the following blog for the info:
http://www.grouppolicy.biz/2012/01/out-now-official-pst-to-exchange-import-tool/
Obviously this isn’t something that you would do a lot, but in case you need to know how, here’s how you can reset all user passwords in a Microsoft Office 365 environment:
Help on accessing Office 365 powershell:
http://onlinehelp.microsoft.com/en-us/Office365-enterprises/hh124998.aspx
Once your connected run the following commands:
Import-Module msonline
Connect-MsolService -cred $cred
Get-Command -Module msonline
Get-msoluser |set-msoluserpassword -newpassword “password” -forcechangepassword $false
That’s it! 
I needed to round up a number in Excel to the nearest whole number. I found this helpful article that discusses rounding numbers:
http://www.ozgrid.com/Excel/excel-rounding.htm
But I also needed to round up the number, which was generated by a formula. So here’s the formula that worked:
=ROUNDUP(SUM(Input!D65:F65)/100,0)
This formula will round up the result of the SUM calculation.
The ,0 following the SUM calculation is part of the ROUNDUP formula.
Opening multiple Visio files and switching between them is a pain. I figured there had to be a way to make Visio to always open files in seperate windows, so you can see the visio drawings seperately (eg: dual monitors).
The below “method B” worked for me for Visio 2010.
Visio has a Multiple Document Interface so open files all go into the same
instance of Visio. There’s really not an easy way around it, but here are
some options:
A) Launch a separate instance of Visio each time you want a separate window
in the Taskbar. A great “how-to” for doing this, can be found at:
http://blogs.msdn.com/b/visio/archive/2009/12/18/visio-2010-better-with-windows-7.aspx
Method A works okay, but I would like Visio to open in seperate Windows everytime, automatically. Method B below does that.
B) Check the Visio option in Tools/Options/Advacned > Put all settings in
Windows registry, exit Visio and change the registry setting
SingleInstanceFileOpen to 0 found in the following location:
Visio 2003
HKEY_CURRENT_USERSoftwareMicrosoftOffice11.0VisioApplication
Visio 2007:
HKEY_CURRENT_USERSoftwareMicrosoftOffice12.0VisioApplication
Visio 2010:
HKEY_CURRENT_USERSoftwareMicrosoftOffice14.0VisioApplication
If the above doesn’t make sense, here’s a helpful “How-to” showing how to do the above:
http://www.mydigitallife.info/how-to-open-visio-diagrams-in-multiple-program-windows/
That’s it!
I don’t know why this was “new” for me, but it did take a google search to figure it out. Here’s a great link that explains how to make only 1 page within Microsoft Word 2010 in a landscape layout, while keeping the rest in the portrait layout.
http://superuser.com/questions/241799/how-can-i-make-just-one-page-of-a-word-document-horizontal
Copied below for reference:
Go to the last page you want to keep vertical (Portrait) then select Page Layout | Breaks | Next Page.
Now click anywhere in the page where you want to have the horizontal page (Landscape) and go toPage Layout | Orientation and select Landscape
Do the same steps for the following page, the one after the landscaped one, but this time choosePortrait. Only do this if you want to restore the Portrait orientation back to normal.
Office 2010 Service Pack 1 (SP1) has been released for download. Here’s a great blog post on Technet that has all of the download links on a single page, for your reference:
If you are using Hyper-V and running the new(er) Westmere processors please read this.
http://support.microsoft.com/kb/2517329
Thank you to those who came to our Lewan Tech Review, I hope you found it informative and hopefully I didn’t talk to fast…tough after needing lots of coffee to wake up in the AM! Please vote for our next Tech Review and be sure to signup for the AppSense training we are doing on April 13th and May 4th!
Here is the presentation from today…click the link below:
Lewan Tech Review April 7, 2011
Figuring out why a pc or server is slow at logging on can be a long and difficult task. Userenvlog logging existing in Windows XP and 2003 and there is a new process for turning this on in Windows Vista, 7, 2008. This is a good step in the troubleshooting process to see if group policy could be slowing down the logon process. http://blogs.technet.com/b/mempson/archive/2010/01/10/userenvlog-for-windows-vista-2008-win7.aspx