Save a large file

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there anyway to compress a file so it is smaller? I have a spreadsheet
that is 21,452 KB and is taking forever to save and open.
 
If it is mostly a data file, You might think about using access instead of
excel

if you have formulas which are no longer needed, copy and paste special
values.

split the workbook and reference the cells in the other owrkbooks.
 
Most of the cells already reference back to cells in previous sheets in the
same workbook. There are numerous fomulas that must be kept in the sheet
itself.
 
it should be the workbook which is the size.
Depending on the formulas, You can reference closed workbooks.
could you spearate this sheet from the rest of the workbook,
 

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

Advantages and disadvantages of individual file based compression and inter-file compression 1
PowerPoint High Resolution Images from PowerPoint 0
Anyone Else Facing Public Folder Migration Errors in Exchange? 0
how do I open a file without having it run virus scan 2
Very slow to save file 2
Compress file to a smaller size without using 3rd party applicatio 2
File too large 8
PowerPoint Printing PPT to PDF without losing quality 1

Back
Top