I’ve been using the Excel Online to import blueprint data to a workbook, but it crashes easily and is limited in how much data I can import at once.
Is the subscription capable of processing more through the addon than the free online version? I was considering subscribing for a month if so.
Thanks.
The desktop version (available with 365 subscription) can handle more blueprints being displayed, since there is no 5mb payload limit like excel web.
But what functions are you using? Since some functions in excel web really benefit from parameters for paging to help prevent excel web crashing if you own many items/blueprints/have a lot of transactions.
For example: Character/corporation_blueprints has a parameter for page, 500 per page.
.CHARACTER_BLUEPRINTS(character_id,1) for example will display the first 500 and so forth.
I made this little helper website so you can see what parameters are available, since excel web can’t load the little parameter helper dialog for customsfunction. You could see if any of the problematic functions can be paged in your excel web sheet. 
I’ve been using .blueprint & .blueprint_explosion.
and clicking and dragging the formula down 50 at a time, copying the group ID I want, then deleting the column F formulas and starting the next batch. Now though it’s stopped working entirely. I feel like my addon got corrupted or bugged maybe, I’m stuck with #busy until the addon crashes, after trying just one formula.
Blueprint Explosion doesn’t work great for more complicated blueprints, it returns incomplete material lists if you hadn’t noticed, althought it’s most noticable for marauders and capitals, alongside it being a very heavy call in terms of fetching a lot of things, I have a bug fix in progress to fix that material list but the heavy recursion is process heavy and hard to optimize more.
But until that’s pushed I’d advise against using it for blueprints containing components other than raw materials.
That’s at least what I potentially think is impacting the performance.
For the addon being corrupted I’d suggest trying to open a new fresh sheet and copy pasting things over, since the way addins are injected can impact it, and should help resetting the state of the addin to a better behaving version. It’s very hard to debug excel web related things in terms of scaling up, knowing when web has hit some internal limits that aren’t documented, so sadly I don’t many pointers for that.
Understood thank you for the help.