View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
bj bj is offline
external usenet poster
 
Posts: 1,397
Default 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.