markbyinton
Tue Apr 11 13:51:02 CDT 2006
Posted this same query on Project Server (wasn't sure where would be best to
ask). Thought you might profit from the response:..it works well..thanks to
FaisalM.
Subject: RE: Exporting Lists to Excel.. 4/11/2006 11:33 AM PST
By: FaisalM In: microsoft.public.project.server
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
--
Mark Byington, PMP
"Engelbert" wrote:
> You don't need all your users to have Office Professional - just the few (?)
> who are creating these Excel spreadsheets.
>
> (Probably obvious but just in case you were thinking on the wrong lines
> based on your Office Pr / Std knowledge)
>
> Engelbert
>
> "Mark Byington" <markbyinton@mstechnethelp.com> wrote in message
> news:56BFB476-2504-43A3-85FA-3A7E34EDF029@microsoft.com...
> > Datasheet view only available in Office Professional. Most of our folks
> > have
> > Office Standard.
> >
> > Other suggestions?
> > --
> > Mark Byington, PMP
> >
> >
> > "Engelbert" wrote:
> >
> >> Don't export it.
> >>
> >> Access the list in Datasheet View. The you can Ctrl-C all the rows and
> >> columns and then transfer them with Ctrl-V into an empty Excel
> >> spreadsheet.
> >>
> >> Works with restrictions as to the kinds of fields and possibly the type
> >> of
> >> List.
> >>
> >> Engelbert
> >>
> >> "Mark Byington" <markbyinton@mstechnethelp.com> wrote in message
> >> news:EB25F0DA-87F6-4DA7-B4F0-9E2D8A8CD68A@microsoft.com...
> >> > When using the WSS portion of Project WEB Access (PWA), AND 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, or add a column, a message appears that says
> >> > it's
> >> > still linked to WSS. This prevents using and manipulating the Excel
> >> > spreadsheet as one might desire. What needs to be done (turned off,
> >> > 'unlinked', etc.) to use normal Excel spreadsheet features when a list
> >> > is
> >> > exported from PWA sharepoint?
> >> >
> >> > Thanks...
> >> >
> >> > --
> >> > Mark Byington, PMP
> >>
> >>
> >>
>
>
>