View Single Post
  #4   Report Post  
bala_vb bala_vb is offline
Senior Member
 
Location: Hyderabad
Posts: 237
Thumbs up

Quote:
Originally Posted by Kevryl View Post
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
__________________
Thanks
Bala