View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Kassandra Kassandra is offline
external usenet poster
 
Posts: 2
Default Save a large file

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


"bj" wrote:

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.

"Kassandra" wrote:

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