How To Flatten Formulas In Numbers

The file size can be reduced (if you have pictures and other media) by using the Numbers menu item "File > Reduce File Size…"

You got me curious how much a formula affects file size. It was a little hard to nail it down.

Brand new document. File size = 124,173 bytes

One formula of "=A1" = 124,566 bytes

After deleting that formula = 124,239 bytes

Typing it back in = 124,402 bytes

Deleting it again = 124,255 bytes

Now with a short LOOKUP formula and something to look up = 124,948 bytes

Not all that scientific but I'd say a formula is maybe 250-1500 bytes, or around 0.001 MB.

What do you mean by "flatten formulas"?

And is the size of a Numbers document a problem? On my machine they tend to be smaller than many other files.

SG