# All Assets or filtering off to show all other assets

**URL:** <https://forums.eveonline.com/t/all-assets-or-filtering-off-to-show-all-other-assets/440699>\
**Category:** EVE x Microsoft Excel Add-in\
**Created:** [February 24, 2024, 10:23am UTC](https://forums.eveonline.com/t/all-assets-or-filtering-off-to-show-all-other-assets/440699 "2024-02-24T10:23:03Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Tobias\_Destroious](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/tobias_destroious/32/412181_2.png) [@Tobias\_Destroious](https://forums.eveonline.com/u/Tobias_Destroious)\
**Post date:** [February 24, 2024, 10:23am UTC](https://forums.eveonline.com/t/all-assets-or-filtering-off-to-show-all-other-assets/440699/1 "2024-02-24T10:23:03Z")

</div>

The Excel Add in limits the character assets to 200 lines per page.

When blueprints are included individually I you cannot actually see what materials are available, by filtering the blueprints off, the first 200 lines now only shows the balance of the lines not the next items.

Is there a way to filter the first two hundered non blueprint lines or show all pages.

I am currently using this forumula =FILTER(EVEONLINE.CHARACTER\_ASSETS(Character\_ID,Location\_ID).type.name,NOT(ISNUMBER(SEARCH(“Blueprint”,EVEONLINE.CHARACTER\_ASSETS(Character\_ID,Location\_ID).type.name))),“”)

my character\_ID and location ID would be my actual ID’s in my excel

---

<div class="post-metadata">

**Author:** ![Hundasuupa](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/hundasuupa/32/412082_2.png) [@Hundasuupa](https://forums.eveonline.com/u/Hundasuupa)\
**Post date:** [March 14, 2024, 9:31am UTC](https://forums.eveonline.com/t/all-assets-or-filtering-off-to-show-all-other-assets/440699/2 "2024-03-14T09:31:12Z")

</div>

You can use character\_blueprints instead to get your blueprints, that also contains the ME/TE values.  
The 200 limit is the page = 1 default behaviour for excel web, since if the payload/size is beyond 5mb it crashes excel web.

Since the parameter is being added by default you could also just duplicate that function and add page = 2 etc to view the rest, but it might run into one of the pages being too large for excel web. Dynamic page sizing is being worked on that would fix that issue, so I’d try the character\_blueprints function for now.

> **[Eve x Excel Functions](https://eve-excel-functions.vercel.app/)**
>
> Exposing the parameters for the Eve Online addin for Excel

 ![image](https://global.discourse-cdn.com/eveonline/original/4X/7/d/6/7d6179dd274827b3c586055ab660ac12b445568e.png)