Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Save a large file
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Save a large file
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Save a large file
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, "Kassandra" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do i save a large amount of data in a worksheet excel 4 | Excel Worksheet Functions | |||
how to save large data sets in excel | Excel Discussion (Misc queries) | |||
when i save xls file, debug script is running and canno't save fil | Excel Discussion (Misc queries) | |||
exporting excel to csv large fields save as "####" | Excel Discussion (Misc queries) | |||
Excell2003 (SP-1) File > Save and File > Save As.. grayed out | Excel Discussion (Misc queries) |