Saving as binary - PLEASE??

[Kevryl]

I posted this question in General Questions on 29th March, and in New Users
on 20th May - no reply from either as yet. It usrely is a basic question for
some of the MVP boffins in here: Surely ... someone MUST know the answer??

Here we go:

If binary is more efficient speed and space-wise, why isn't it the default
format (or read "the best way to save a file)?

I'm trying to find out what the downside is before I save a majorly
important, large file with heaps of macros in binary and start moving on
with it to find a little way down the track I've made a terrible mistake! If
it isn't the
default there must be a reason - a down side - but I can't find anything in
Help to tell me.

Anyone know?

 

[Peter Foldes]

Kevryl

And you will not get an answer here since your question does not belong to the
Office newsgroup as is this one and secondly the reason you did not get answers
there is because you question does not make any sense

--
Peter

Please Reply to Newsgroup for the benefit of others
Requests for assistance by email can not and will not be acknowledged.
http://www.microsoft.com/protect

 

[Kevryl]

Kevryl

And you will not get an answer here since your question does not belong to the
Office newsgroup as is this one

Peter, this is specifically an Excel 2007 problem, hence my successful
posting on the first two occasions to "Excel General Questions" (the 29th
March and 20th May posts went into microsoft.public.excel.misc (copied and
pasted from the message headers))

This post you have answered Peter went to microsoft.public.office.misc. It
wouldn't be the first time one of my posts has disappeared "into the ether"
to pop up unpredictably where I didn't send it! LOL. However, I'll accept
that as my error although I thought I was posting to "Excel General
Questions" again.

Your confusion has resulted from THIS PARTICULAR post not going to the
"Excel General Questions" thread, and I accept you may be unfamiliar with
Excel 2007. Otherwise, my posts would have been perfectly clear ;-).
[Actually, for users familiar with Excel 2007 (and there would be many in the
"Office" threads, after all Excel IS Office) they still would have been!].

and secondly the reason you did not get answers
there is because you question does not make any sense

Excel 2007 offers "Save as Binary"as an option (with a .xlsb extension),
saying its space and time efficient, but nothing more. I'm simply asking what
the downside is, which there must be ?? if it isn't the default option.

I see in looking over my 3 posts on this that I do not specifically mention
Excel. Thats understandable because they were posted to an Excel thread.

Thanks Peter for your reply which has caused my to look further at why it
all went awry. I shall repost with better explanation!

Cheers,
Kevryl.