Link to home
Start Free TrialLog in
Avatar of Franklinleon
Franklinleon

asked on

Shared Workbook when using 03 and 07 bloating, incompatibility?

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?
ASKER CERTIFIED SOLUTION
Avatar of Patrick Matthews
Patrick Matthews
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial