File Size has Doubled but I only Moved some of my Tables to a New Tab?

It's like I've moved the 20 BSM engine tables from the main tab to another tab but maybe Numbers still thinks they're still there like a cache issue? (Although in the main tab there is now a blank space where the BSM tables once were).

I used File (Option) / "Save As" as I have been doing with this project but couldn't understand why doing something that should help processing speed (moving lots of large tables from the main page) made it slower.

What would be the best option normally, Duplicate or Save As?

Cheers.

The doubling of file size has just happened again on another version of this project, from 32mb to 70mb but with the exact same conditions.

I move the tables by copying and pasting them into a new tab and then delete the original tables.

It's like the 20 tables have been deleted and now I have two lots of them (based on file size), the old ones now being invisible but obviously still there in some kind of cache form.

Thanks, a partial success! I say partial because the original file I experimented with is 29mb and using cut and paste didn't double it like copy and paste has done in the past, but has added 10 mb to now make the file 39mb when closed.

I am wondering why the extra 10mb, if all I have done is move tables to a new tab?

Regards,

Bard

Interestingly I just did another cut and paste on a later version of the file (only had a few modifications to the one I mentioned above) and the file size -- using cut and paste -- has remained exactly the same and it didn't add any mb, I am not sure why? Maybe the clipboard got saved on the version I first mentioned at the top of this question, when I used copy and paste version, although I don't recall seeing a "save the clipboard" message before quitting. I didn't get a save clipboard prompt for the file that became 10mb heavier. Odd.

Cheers.

I am unsure how else anyone would continue to make changes to a document without changing the name? None of the other 100 plus name changes have resulted in a doubling of file size?

Is there a reason why this has happened and a solution? Thanks.