A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Final attempt save as binary question



 
 
Thread Tools Display Modes
  #1  
Old May 31st, 2010, 05:03 AM posted to microsoft.public.excel.misc
Kevryl
external usenet poster
 
Posts: 119
Default Final attempt save as binary question

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".
  #2  
Old May 31st, 2010, 06:30 AM posted to microsoft.public.excel.misc
Ed Ferrero[_3_]
external usenet poster
 
Posts: 102
Default Final attempt save as binary question

Hi Kevryl,

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

Ed Ferrero
www.edferrero.com
  #3  
Old May 31st, 2010, 07:47 AM posted to microsoft.public.excel.misc
Sheeloo
external usenet poster
 
Posts: 797
Default Final attempt save as binary question

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/archiv...20/671995.aspx

Ed Ferrero
www.edferrero.com
.

  #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
  #5  
Old June 1st, 2010, 07:05 AM posted to microsoft.public.excel.misc
Kevryl
external usenet poster
 
Posts: 119
Default Final attempt save as binary question

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
.

  #6  
Old June 1st, 2010, 07:14 AM posted to microsoft.public.excel.misc
Kevryl
external usenet poster
 
Posts: 119
Default Final attempt save as binary question

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/archiv...20/671995.aspx

Ed Ferrero
www.edferrero.com
.

  #7  
Old June 1st, 2010, 07:17 AM posted to microsoft.public.excel.misc
Kevryl
external usenet poster
 
Posts: 119
Default Final attempt save as binary question

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/archiv...20/671995.aspx

Ed Ferrero
www.edferrero.com
.

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 09:07 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.