Shared Workbook when using 03 and 07 bloating, incompatibility?

Posted on 2009-04-16
Last Modified: 2012-05-06
When using Excel 03 and Excel 07 with a shared workbook becomes bloated.
Environment; 6 user Excel03 windows xp, service pack SP3S. One user windows xp Excel 07. User not currently using always close excel. No VBA/macros. Just simple formula. Not linked cells.  If excel07 user does not share then there is no bloating. If the excel07 does share the then bloating happens. The size went from .860m to 86m. Setting: Share WorkBook settings, Allow changes by more then on user at the same time. Checked = true, Advanced Track changes is Off, Update changes Automatically every 5 minutes, Conflicting changes between users Ask me which changes win.
I see no ghosts user in the listing of shared workbook drop down.

Fixes I have tried. Copy spreadsheet to new excel document. This Works! 2) Delete redundant rows/columns. This did not work. 3) Saved as CSV format and looked for rows with just comma with notepad. No extra commas. 4) Saved as in earlier version (95) file returned to .860m. This works!
After these fixes the problem comes back when sharing with excel03 and excel07. Is there an incompatibility between Excel 03 and Excel 07 that cause this problem or a setting I don't know about?
Question by:Franklinleon
    1 Comment
    LVL 92

    Accepted Solution

    Hello Franklinleon,

    The consensus opinion of Experts here is that using 'share workbook' should be assiduously
    avoided.  This is a poorly implemented feature in Excel that leaves workbooks highly
    vulnerable to corruption.  If true multi-user capability truly is needed, then the best practice
    is to use a database platform such as Access, SQL Server, MySQL, etc.



    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to improve team productivity

    Quip adds documents, spreadsheets, and tasklists to your Slack experience
    - Elevate ideas to Quip docs
    - Share Quip docs in Slack
    - Get notified of changes to your docs
    - Available on iOS/Android/Desktop/Web
    - Online/Offline

    This tutorial explains how to create a series of drop-down lists that are dependent upon prior selections to guide (“force”) the user to make the correct selection and reduce data errors within Microsoft Excel. Excel 2010 was used for this tutorial;…
    PaperPort has a feature called the "Send To Bar". It provides a convenient, drag-and-drop interface for using other installed software, such as Microsoft Office. However, this article shows that the latest Office 2016 apps (installed with an Office …
    Learn how to create and modify your own paragraph styles in Microsoft Word. This can be helpful when wanting to make consistently referenced styles throughout a document or template.
    This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    11 Experts available now in Live!

    Get 1:1 Help Now