View Single Post
  #4  
Old May 31st, 2010, 08:23 AM posted to microsoft.public.excel.misc
bala_vb[_34_]
external usenet poster
 
Posts: 1
Default Final attempt save as binary question


Kevryl;957179 Wrote:
This is about my fifth attempt since March, so far without eliciting a
single
reply (last attempt seems to have disappeared into the ether):

Re Excel 2007 "Save as binary". Its supposed to save space and be
quicker.
So why isn't it the default method? Is there a downside? For example,
will
macros no longer work? Are there reduced functions in a file saved as
binary?
I need to know before I save a large and majorly important (to me) file
with
heaps of worksheets and macros and find down the track that I've lost
something significant!

There HAS to be some reason why files are not saved by default as
binary,
but so far no-one seems to know, and I can find nothing to explain this
in
"help".


In General binary excel are quicker to access, less chance of
corruption, very easy to repair becase they store data in xml format.
it is recommended to save huge data files are binary format.

all the best




--
bala_vb