ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Regular Workbooks vs. Binary Workbooks (https://www.excelbanter.com/excel-discussion-misc-queries/262568-regular-workbooks-vs-binary-workbooks.html)

Jerry

Regular Workbooks vs. Binary Workbooks
 
Can you tell me the difference between a regular Excel workbook and a binary
workbook?

We use a shared workbook as a tracking system for our department, and we
often have conflicts, crashes, or other miscellaneous catastrophes. My
manager was wondering if saving it as a binary workbook might reduce the
number of problems that we experience.

Thank you for your help.

bala_vb

Quote:

Originally Posted by Jerry (Post 949362)
Can you tell me the difference between a regular Excel workbook and a binary
workbook?

We use a shared workbook as a tracking system for our department, and we
often have conflicts, crashes, or other miscellaneous catastrophes. My
manager was wondering if saving it as a binary workbook might reduce the
number of problems that we experience.

Thank you for your help.

Yes, it might reduces technically because As Excel Macro-enabled Workbook, but storing information in binary form rather than XML documents for opening and saving documents more quickly and efficiently. Intended especially for very large documents with tens of thousands of rows, and/or several hundreds of columns.

whereas Regular workbook just saves in XML format.

All the best.
Bala


All times are GMT +1. The time now is 09:34 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com