#ProjectServer 2010 views export to #Excel AutoSum #PS2010 #MSProject

April 20, 2012 at 4:18 pm | Posted in Administration, Functionality, Information | Leave a comment
Tags: Office 2010, Project 2010, Project Server 2010, PS2010

While on client site recently a query was raised regarding using the AutoSum function in Excel for the exported Resource Availability view, this didn’t work due to the hours containing an h. For the AutoSum functionality to work only numeric characters can be in the range. There is a very quick and simple method to remove the h.

Export to Excel:

As you can see the hours contain the digits as well as h, to remove h just use find and replace, typing h in the find what field and leave the replace with field empty. Firstly select the dataset / range as below:

Now press Ctrl + H and enter h in the find what field and leave the replace with field empty:

Click Replace All and the h will be removed:

Any calculations will now work including AutoSum:

Advertisements