Export to Excel from Resource Availability view (PS2007)

M

Mike Mahoney

This is not a development problem but I am hoping the developer
community might have a view. This problem has been identified in the
past and a fix was incorporated in SP1 but I am still experiencing
it. On requesting the export to excel in the resource availability
view in PWA a dialgue box opens and tries to save a file with
extension xls(1). It is in fact an xml file and Excel will not open
it. I have a number of virtual environments where this is not a
problem - in these the file is named as sheet1.xls and it is
recognised as readible by Excel. If I compare the two files, the only
difference is one line:
<ss:Worksheet ss:Name=" "> in the xls(1) file
<ss:Worksheet ss:Name="sheet1"> in the good file
Entering any text between the empty quotes makes the file good! (Excel
will open it)

The environment with the problem is PS2007 with October patch. Client
side is IE6/Office 2003 (Sp2).


Any ideas on debugging problem would be appreciated.


regards


Mike
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top