Export to Excel

[karthick]

I have connected the project web access.When i want to export the project in
Excel it not converted to excel format.what can i do for export the grid to
excel.plz help.

 

[Rolly Perreaux]

I have connected the project web access.When i want to export the project in
Excel it not converted to excel format.what can i do for export the grid to
excel.plz help.

When you click on Export Grid to Excel link, Microsoft Office Excel 2003
is launched and the data is copied in XML format to a spreadsheet. Just
Save As Microsoft Office Excel Workbook (*.xls) then you're done.

Good Luck

--
Rolly Perreaux, PMP
Project Server Trainer/Consultant

IT Summit Series
Advanced Microsoft Technology Training
http://www.itsummitseries.com

 

[Mike]

I have a question:
I've seen where upon selecting 'export grid to excel' a dialog box which
states that the activex control could not be made. Any idea what causes this?

 

[gsaich]

I'm having the same problem, has anyone found a solution.

GXS

 

[Michael Cram]

Here's the solution:

You have to add the name of your local Project server to your list of
"Trusted Sites" in Internet Explorer. Once you do that the function will
work properly.

-Mike

 

[RDA]

Hey,

I have our Project Server listed in the "Trusted Sites" in IE. Also, I
have every ActiveX control selection set to "Enable" for the Custom
Level security settings. Even with these settings, I still receive
the following error messages when click on Export Grid to Excel from
the Project Center in PWA:

An error occurred while exporting the grid data to Excel.
Because of this error, you can only copy the XML data to the Clipboard.
Do you want to continue?

When I receive this message, Excel opens and populates the spreadsheet
with project data.

I can certainly live with saving the file as .xls and moving on, but
our CIO is using the Export Grid to Excel link. How do I resolve this
so the export is seamless?

HELP!?!

RDA

 

[Dee]

I believe you must have Excel 2003 to do this.

Regards,
Dee

 

[maleixo]

RDA,
You must to have everything you already do, more..

Users must to have minimun Excel XP and administrator rights in the
machine only at the first time..

sometime ago, I made a procedure for help desk, i'll try to find and
post here...

 

[RDA]

We are running Excel 2003 (11.6355.6360) SP1. Not sure about the
administrator rights on the machine.

I appreciate your help.

RDA