Excel 2007 shared workbook freezes on saving

When we copy the data from Excel 2003 to Excel 2007, workbook freezes (for excel 2007)
This specifically happens when your Excel 2007 workbook is shared. However if the Excel 2007 workbook is not shared then everything works perfectly. Any clue?

0 Comments   [ + ] Show comments

Answers (1)

Posted by: lemmonsj 12 years ago
Yellow Belt
Unfortunately Excel workbooks don't share well. If you want it to work well, you can use an Excel frontend to a shared database (if you don't have Acess, just use Jet which is on everyone's machine for free).

If you can't do this for some reason, then my advice would be to keep the shared workbook as small and simple as possible, and to take very frequent backups to minimize the recovery problems.
Rating comments in this legacy AppDeploy message board thread won't reorder them,
so that the conversation will remain readable.

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login


This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ