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

April 20, 2012 at 4:18 pm | Posted in Administration, Functionality, Information | Comments Off on #ProjectServer 2010 views export to #Excel AutoSum #PS2010 #MSProject
Tags: , , ,

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:

image

image

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:

image

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

image

Click Replace All and the h will be removed:

image

Any calculations will now work including AutoSum:

image

Advertisements

Blog at WordPress.com.
Entries and comments feeds.

%d bloggers like this: