Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
HOW TO COMPACT AN EXCEL FILE
DEAR ALL
Like in ACESS, is there a way to compact the excel file?? My file has become 1.3mb. Pls adv. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
HOW TO COMPACT AN EXCEL FILE
No, there is no such tool in Excel.
Dave -- A hinte to posters: Specific, detailed questions are more likely to be answered than questions that provide no detail about your problem. "CAPTGNVR" wrote: DEAR ALL Like in ACESS, is there a way to compact the excel file?? My file has become 1.3mb. Pls adv. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
HOW TO COMPACT AN EXCEL FILE
Not really,
but if there are cells with formulas which only needed to be calculated once changing them to values will reduce the size. Additionally, if you have a column of similar formulas, leave the top one as a formula and paste value the rest. when you need an update just copy the formula at the top down and recopy and paste values before you save "CAPTGNVR" wrote: DEAR ALL Like in ACESS, is there a way to compact the excel file?? My file has become 1.3mb. Pls adv. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
HOW TO COMPACT AN EXCEL FILE
DEAR BJ
Thnks ur time. My file has gone too big with so many formulas and calculations to each time copy and paste etc. Hvr, tks for the sugestion and noted the trick to reduce the memory space if needed. On Feb 1, 10:04 pm, bj wrote: Not really, but if there are cells with formulas which only needed to be calculated once changing them to values will reduce the size. Additionally, if you have a column of similar formulas, leave the top one as a formula and paste value the rest. when you need an update just copy the formula at the top down and recopy and paste values before you save "CAPTGNVR" wrote: DEAR ALL Like in ACESS, is there a way to compact the excel file?? My file has become 1.3mb. Pls adv. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Stop excel from dropping the 0 in the beginning of a number? | Setting up and Configuration of Excel | |||
Retaining formats | Excel Discussion (Misc queries) | |||
How to read Pocket Excel file in Compact framework | Excel Discussion (Misc queries) | |||
how do I save an excel file to a rewritable compact disc? | Excel Discussion (Misc queries) | |||
How do I unlock FILE access? | Excel Discussion (Misc queries) |