Prev: How to clear up useless content within worksheet?
Next: Input box to find date
From: Kevryl on 31 May 2010 00:03
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".
From: Ed Ferrero on 31 May 2010 01:30
Hi Kevryl,

I assume you have seen this?
http://blogs.msdn.com/b/excel/archive/2006/07/20/671995.aspx

Ed Ferrero
www.edferrero.com
From: Sheeloo on 31 May 2010 02:47
Just so that you don't feel left out...

Here is the reason from the link given by Ed

"When your scenarios will require the improved open/save performance of the
binary file format, use XLSB; otherwise the benefits of the XML format often
outweigh the (usually unnoticeable) performance benefit of this format."

Unless you have issues with time taken to Open and Save... default formats
are good enough.

Also as my company's dress code policy says "in case you are wondering
whether I shoudl wear this or not then probably you should not" :-)

You should use this format only after you understand the benefits or after
experimentation with few spreadsheets... do keeps a xlsx copy.

"Ed Ferrero" wrote:

> Hi Kevryl,
>
> I assume you have seen this?
> http://blogs.msdn.com/b/excel/archive/2006/07/20/671995.aspx
>
> Ed Ferrero
> www.edferrero.com
> .
>
From: bala_vb on 31 May 2010 03:23

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
From: Kevryl on 1 Jun 2010 02:05
Thanks, Bala, thats useful but I'm still wondering why Excel 2007 doesn't
simply save all files as binary.

"bala_vb" wrote:

>
> 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
> .
>
 |  Next  |  Last
Pages: 1 2
Prev: How to clear up useless content within worksheet?
Next: Input box to find date