I know in Excel we can input a user name into the field, so that if UserA has a spreadsheet opened the others can see who is in it. I know how to set that too. My question is, how reliable is it?
We have an excel spreadsheet which almost everyone will need to edit. I am sure majority of people has insert their name correctly in that user field, but still majority of time Excel failed to display the correct name as it only shows the spreadsheet is opened by "."!! Will the different edition/version of excel affect this function? I mean, we have a mixture of Excel 2007 and 2010 and the spreadsheet was originally created using Excel 2000. The spreadsheet is stored in a network drive where everyone can access.
Is there anything I can do in Excel to ensure it displays user name correctly? If not in excel, any third party product?
Thx in advance for any suggestion. We are operating in a Win 2003 network but I don't think this matters?