[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Shared Workbook when using 03 and 07 bloating, incompatibility?

Posted on 2009-04-16
2
Medium Priority
?
357 Views
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?
0
Comment
Question by:Franklinleon
1 Comment
 
LVL 93

Accepted Solution

by:
Patrick Matthews earned 500 total points
ID: 24164030
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.

Regards,

Patrick
0

Featured Post

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Outlook for dependable use in a very small business   This article is about using the Outlook application (part of Microsoft Office) in a very small business, or for homeowners where dependability and reliability are critical requirements. This …
I came across an unsolved Outlook issue and here is my solution.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

872 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