Excel 2007 Track Changes Bug Report

  • Thread starter Thread starter Auntie
  • Start date Start date
A

Auntie

To replicate:
Create and populate an Excel file in Excel 2007
Share the file (Review/Share Wookbook/click "Allow changes...", click OK)
Click on Review/Track Changes/Highlight Changes/Unclick "When"
Click OK

Make some changes to some of the cells on the worksheet.
Highlight one column
Click Data/AZ or Data ZA (not the "sort" button)
Click the "undo" button
The "track changes" are now corrupted, identifying the wrong cells as having
been changed.

Alternately:
After you have made changes to some of the cells:
Highlight 2 or more columns
Click Data/AZ or Data/ZA (not the "sort" button)
The "track changes" are now corrupted, identifying the wrong cells as having
been changed.

Does anyone know if this bug has been identified before?

Thanks.
Auntie



----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...0164000&dg=microsoft.public.excel.crashesgpfs
 
Hi Jan, I don't have a lot of choice. I have 16,000 records in my 200 or so
files, and I desperately have to proofread them. Without track changes, it
becomes a nightmare.

Fortunately, earlier versions of Excel don't seem to have that problem, but
as more and more of my users switch over to Excel 2007, it's gonna get worse
and worse.

What are the chances that MS will fix this in my lifetime?
 
Hi Jan,

Thanks for your suggestions. Unfortunately neither will work. I am a half
time employee for a very large volunteer organization that only has 1 other
employee. The Excel files are club membership lists that I prepare once a
year and the volunteer club membership secretaries email them back to me
monthly with their updated membership lists. I'm just happy that most of them
have Excel. Some of them are still handwriting and snail mailing their lists,
so getting them all to upgrade just isn't gonna happen. If we were going to
force them to upgrade, it would be to Access, not Excel. I import the data
into Access for easier manipulation.

As far as hiring someone to create a new system, it just isn't gonna happen.
We don't have the $$.

Do you know if there is any way to file a formal bug report with Microsoft?
I sure couldn't find one. Or is this forum the best chance we have to get
their attention?

Auntie
 
Back
Top