Sharing Excel Workbook compatibilty Excel 2007 and Excel 2010
Posted on 2011-03-11
I have shared an Excel 2007 file between half a dozen users in an office on a shared network. It is an Excel 2007 macro enabled workbook, where users enter data which is loaded when they click on a VBA macro. This seems to work well for all the users who have Excel 2007, but the one user who has Excel 2010 does not appear to be able to load data. Has anyone else experienced anything like this and do they have any suggestions other than ensuring all users have the same version of Excel?
Thanks very much for your time