File size

[Sigh]

I have a spreadsheet of 24,000 kb, I suspect it's this large due to the number of formulae stored in it, is there a way of determining the size of each tab within the file? I could then look at deleting parts of the largest tabs where possible to reduce it to a more manageable size.
Thanks.

 

[Ruddles]

I've tried this already but it never managed to do it because it takes such a long time to paste...

Don't copy-and-paste: right-click the worksheet tab and select Move or Copy..., then select a new workbook to move it to.

 

[Sigh]

Don't copy-and-paste: right-click the worksheet tab and select Move or Copy..., then select a new workbook to move it to.

I tried this, it took 29 minutes but I was able to save it separately and then determine the file size, thanks.