#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: , , ,

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

Leave a Comment »

RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Create a free website or blog at WordPress.com.
Entries and comments feeds.

%d bloggers like this: