A little maths should sort you out. The attached creates a unique id for each feature, then using the floor function puts every feature into a group of 500 features. You then use that attribute group id as part of your sheet name so that you can fanout sheets by groups of 500.
We use 3 different kinds of cookies. You can choose which cookies you want to accept. We need basic cookies to make this site work, therefore these are the minimum you can select. Learn more about our cookies.