Expand Splicer(s)

[Jill.Pleau]

We have a splicer that appears to be attached to a table with 7500 records. The splicer begins in 2015. user does not know how to change years or add the next year to the splicer. We seem to be out of room.

 

[AliGW]

Firstly, it's called a slicer. Secondly, the slicer will change to reflect the contents of the table on which it is based. Make sure that rows added to the table are indeed a part of the table.

Finally, we can't troubleshoot a picture. Better to attach a sample workbook (desensitised|) that illustrates the problem.

 

[Jill.Pleau]

Sorry - slip of the finger. I cannot attach the spreadsheet as it is too large. thanks

 

[AliGW]

Then cut it down and attach a copy that illustrates the problem. To do this, you will need to delete some of the data and desensitise the rest.

I cannot divine the problem from a screenshot any more than I could using a crystal ball.