Asset Excel causes Excel to stop working
Anyone else use Asset Excel and get this message when they try and search for HW assets:
It's almost certainly because of the number of HW assets we have and none of the filters seem to help.
I can use other aspects of it (Software Assets,Cost Centers, Vendors etc.)
I just wondered if other companies were using this to manage HW assets. If so, how many HW assets do you have? We have around 59k which needs chopping down.
Answers
Also, the update button appears to be there but doesn't seem to do anything.
I think this has to do with the actual shape of one or more HW assets. Excel loads most of them, but crashes on a malformed one.
Try changing the Type Projection you're using to something less complex (i.e. less relationships).