Quote:
Originally Posted by Kevryl
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