My company mostly uses Excel 2003. As people have their computers upgrades the new ones have Excel 2010.
We have a shared network drive where we save spreadsheets. Many different people open and update in them. Also these spreadsheets have Macros in them.
If someone with 2010 opens the file, it updates to their version. If they save it, of course, the 2003 people can't use it anymore. If they do a Save As and under "Save as Type" they select 2003.xls, then the 2003 people can open it, but it is "read only", and the macros don't work.
Does Microsoft have some kind of work around for multiple users with different versions?
We have a shared network drive where we save spreadsheets. Many different people open and update in them. Also these spreadsheets have Macros in them.
If someone with 2010 opens the file, it updates to their version. If they save it, of course, the 2003 people can't use it anymore. If they do a Save As and under "Save as Type" they select 2003.xls, then the 2003 people can open it, but it is "read only", and the macros don't work.
Does Microsoft have some kind of work around for multiple users with different versions?
