Sharing Excel Workbook compatibilty Excel 2007 and Excel 2010

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
Who is Participating?
jppintoConnect With a Mentor Commented:
On the user that has Excel 2010, go to File-Options and Trust Center. Check the settings and see if on Trusted Documents the "Allow documents on a network to be trusted" is checked.
claude1Author Commented:
Thanks - that seems like the solution
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.