home recent topics recent posts search faq
Home » Password Control - Password Control - Bugs » Error when exporting to EXCEL Messages in this topic - RSS
|
1/16/2009 7:47:32 AM
dethro69
dethro69
Posts 2 		I am trying to get the "memberOf" attribute from AD. If I have a larger selection of users I get the following errors:

1) Do you want to save changes you made to book1 - then Excel closes
2) Error exporting Excel:Exception from HRESULT: 0x800A30EC Please check that Microsoft Excel is intalled.

When I pull other information from the same selection everything works fine. It seem to happen only with memberOf
1/16/2009 11:11:08 AM
admin
admin
Posts 331 		dethro69 wrote:
I am trying to get the "memberOf" attribute from AD. If I have a larger selection of users I get the following errors:

1) Do you want to save changes you made to book1 - then Excel closes
2) Error exporting Excel:Exception from HRESULT: 0x800A30EC Please check that Microsoft Excel is intalled.

When I pull other information from the same selection everything works fine. It seem to happen only with memberOf


I'll need to investigate further, but my initial thoughts are that this is down to the maximum number of characters that can be stored in an Excel cell - I think this is 32,767 (Excel 2003/2007). If this is the case, there probably won't be a fix as such - I would like the application to display a better error message though. Another option is to export the data to CSV, but you'll still have problems opening using MS Excel to view the file.

Thanks,

David
1/16/2009 11:33:05 AM
dethro69
dethro69
Posts 2 		Yup - that's what I thought.

I eneded up running it and saving it to TAB delimited. It opened up in Excel, no problem.
pages: 1
|
Home » Password Control - Password Control - Bugs » Error when exporting to EXCEL