Huge increase in file size

[Gray]

Hi,

I've got a spreadsheet that's about 500K in total.

I've got another spreadsheet that is far smaller, but uses links fro
the larger one.

The smaller spreadsheet is almost 11MB in size. I imagine this much b
something to do with the links. Is there anything I can do t
drastically reduce the file size?

Is there a simple way to kind of make the spreadsheet "forget" th
links and literally use the data that's in the cells?

Thanks,

Graem

 

[Guest]

Hi
You can copy the range in situ and then Paste Special/Values to clear the
formulas and links and leave just the values.

Andy.