Prev: How to clear up useless content within worksheet?
Next: Input box to find date
From: Kevryl on 1 Jun 2010 02:14
Hi Ed, no I haven't (have now tho) - didnt know it existed: Thanks.

The article alludes to the benefits of the XML format over binary,. but
doen't give any hint as to what they are. However, it doesn't appear that
I'll lose anything so I'll start experimenting.

"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: Kevryl on 1 Jun 2010 02:17
Hi Sheeloo,

Thanks! Don't feel left out any more, LOL.

As I said to Ed, thyge article doesn't actually say what the benefits of the
XML formats are, but it doesn'ty appear that I'll lose anything, and since
opening and closing do take quite a while I'll try experimenting.

Thankls for taking the time with me.


"Sheeloo" wrote:

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