Problem Exporting to Spreadsheet

D

dietmarhannam

Within the project workspace i have the Issues list linked to PWA. I
would like to export the list to an Excel spreadsheet but cannot seem
to do so.

The operation completes and 'data' is input into the spreadsheet, the
only problem is the only data is the ID and nothing else. I would like
all information contained in the list to be imported to Excel but this
doesn't happen.

I get an error message saying:

"This list has hidden columns or read-only columns that require data
but for which no default value has been specified. Existing rows in
this list may therefore be edited, but new rows cannot be inserted."

I am running Excel 2003 and have tried a repair of the Office
installation.
I have tried an 'Export to Spreadsheet' on a custom list and it works
fine. Any ideas why it won't work for my Issues list?
 
D

dietmarhannam

In addition to what's mentioned above:

- I have tried exporting from both the Project Workspace in SharePoint
and from PWA.
- The Issues list has some custom columns (would this make a
difference?)

Thanks,

Dietmar
 
Top