Shared Workbook when using 03 and 07 bloating, incompatibility?
Posted on 2009-04-16
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?