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


Please log in to comment

Rating comments in this legacy AppDeploy message board thread won't reorder them,
so that the conversation will remain readable.


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.
Answered 06/09/2011 by: lemmonsj
Yellow Belt

Please log in to comment
Answer this question or Comment on this question for clarity