I have 12 sheets, which holds monthly information.

Data exists in Column A through K, row 1 down to row 500.

I have a formula in cell AZ1 (done to ensure no one can find it and
subsequently delete it).

When I depress CTRL+END it takes me to AZ500 (as expected).

The question I have is that as all my data is going to be in Columns A
through K and rows 1 to 500, if I reset the Last Cell to say K500 would it
achieve faster saves to a LAN?. Please note that the value from AZ1 is used
in column G1 – G500.

All views greatly appreciated.