Huge increase in file size

  • Thread starter Thread starter Gray
  • Start date Start date
G

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
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Discard Picture Resizing Information 0
change font size on screen, but prints in old size 2
File size 2
embedding or linking & sizing 1
VLOOKUP Help 1
File size for an excel sheet on the web 1
Huge Empty Spreadsheet 9
Font size in validation list 6

Back
Top