LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3
Default Excel throws -2147417851 (80010105) The server threw an exception. for no apparent reason

Hi!

I've got a .net windows service that generate rather large excel files with
mounds of data. Lately the code has begyn to generate -2147417851 (80010105)
"The server threw an exception" exceptions for no apparent reasons.

The exception occurs when I set a range's value to a two dimentional array
of the same size. I guess the arrays have become to large, they're equal or
greater than 8500x5. (Usually 80+ in column dimension)
I use an Excel interop assembly generated for Excel 2000. (not the PIA's)

I've managed to get rid of the exception by replacing some code with lesser
range value allocations, but this slows down the process even more than it
is allready.

Anyone got any good advice?

Lars-Erik


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
#NAME? error for no apparent reason... Monomeeth Excel Worksheet Functions 4 September 15th 08 08:22 AM
Excel is behaving strangely for no apparent reason. canyondude New Users to Excel 4 January 10th 06 12:07 AM
Excel throws exception if cell being edited Pixeled Excel Programming 2 September 6th 05 07:24 PM
Excel resizes images with no apparent reason Carlos Lozano Excel Programming 2 August 24th 05 10:23 PM
Error -2147417851 '"The server threw an exception" Bob Barnes[_3_] Excel Programming 5 February 6th 04 03:51 PM


All times are GMT +1. The time now is 08:50 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"