someone please help me.

In excel 2013, I have pulling PI data using PIDataLink. 1st day of every month i update the current month date. I have over 25 array's and I have to resize all of them by right click and select recalculate (resize) function. It takes about 1 to update the whole file. I was wondering if I can set that to automate and have it done on 1st of the month. Anyone who i can set that up.

Thank you