ISeries data to pivot tables in Excel

I'm trying to access ISeries data through Excel pivot tables.

Two weird issues, one is preventing what I'm trying to do.

1. After I set library list and saw my list of files, I didn't see ALL the files in the library, just some of them.
Where are my missing files?

2. I found the file I needed and selected it. The file has 15 fields. When I got my field list in my pivot table, there were only 13 fields, and one field I need is missing. I noticed the missing fields are my packed numeric fields.

Is that a limitation of Excel, that it can't pull in packed numeric fields, or is there some way to get those fields without changing the file field definitions on the iSeries?


Thanks,
Charlie