Exporting Lists to Excel..

[Mark Byington]

This may be more Sharepoint than project but it IS part of PWA, so I'll start
here. When exporting an issues list or other custom list to Excel, the
resulting excel report is for the most part non-editable. That is, if you
want to 'Sum' a column, it's not possible due to some sharepoint
parameters(?). What needs to be done (turned off) to use normal Excel
features when a list is exported from PWA sharepoint?

Thanks...

 

[FaisalM]

1. Export the list to excel
2. click on the exported list data in excel
3. Go to Data > List > 'Convert to Range'
4. Now you can do sum of a column.

Alternately, if you want to keep exported list data & want to do sum in
another sheet then follow this:

1. Export list to excel.
2. Select the rows/columns you want to copy in excel sheet
3. Copy the data
4. Insert new worksheet
5. in new sheet select 'Paste Special' from Edit menu
6. From 'Pase Special' popup select Values & click ok

In the new worksheet you will be able to perform sum operation.

--
FaisalM
http://www.FaisalMasood.com/

My Project Blog
http://www.faisalmasood.com/blog/msproject
My Sharepoint Blog
http://www.faisalmasood.com/blog/sharepoint

 

[Mark Byington]

Works....thank you so much!!!!