Users show up the same in shares excel workbook

[stephenh2]

I created a workbook on my Mac at home using Excel 2004. I then
enabled protection, then enabled sharing. I then copied it to a
network location on my file server at home. It is a MacPro running
Server 10.4. My domain resides on a Windows 2003 SBS Server. I have
several terminal servers in a farm, all running Windows 2003
Enterprise. My staff uses RDP to access their AD accounts. They are
all able to open and edit the shared workbook on the Mac file server.
However, when several users have the workbook open, if I view to see
who is using the workbook, all the open users are listed as me. So,
tracking changes is useless. All the changes appear as if I made them.
I opened the workbook under a test AD account and made a change. Under
my domain account, I was able to view the change, however it was
logged by excel under my AD account, not the test user.

Any ideas about why this behavior is happening? This does not inhibit
workflows, but prevents me from tracking changes.

 

[Bob Greenblatt]

I created a workbook on my Mac at home using Excel 2004. I then
enabled protection, then enabled sharing. I then copied it to a
network location on my file server at home. It is a MacPro running
Server 10.4. My domain resides on a Windows 2003 SBS Server. I have
several terminal servers in a farm, all running Windows 2003
Enterprise. My staff uses RDP to access their AD accounts. They are
all able to open and edit the shared workbook on the Mac file server.
However, when several users have the workbook open, if I view to see
who is using the workbook, all the open users are listed as me. So,
tracking changes is useless. All the changes appear as if I made them.
I opened the workbook under a test AD account and made a change. Under
my domain account, I was able to view the change, however it was
logged by excel under my AD account, not the test user.

Any ideas about why this behavior is happening? This does not inhibit
workflows, but prevents me from tracking changes.

Check the Excel preferences to make sure that each user is using their own
correct name. (General Tab - User Name). I would then restart Excel on each
of the machines, make sure the user name is correct, and then test to see if
the changes are logged correctly.

 

[Mac User]

05.10.2008

Tracking Changes does not work properly if an Excel Shared file is used in compatibility mode (.xls). After saving the document changes are no longer trackable!

Excel even crashes when trying to save such a sheet in the new format (.xlsx).

Excel Version 12.1.2
Mac OS X.5.5

 

[Pat McMillan]

Would it be possible to send a crash log from Microsoft Error Reporting the
next time you encounter this crash?

Thanks,

Pat McMillan
(e-mail address removed)