Tracking changes

[tthomas]

I have an excel file that is password protected and will
be shared by 5 people. I know that shared workbook and
tracking changes doesn't work on a password protected
file. Is there any other way of tracking changes made by
5 different people?

 

[Debra Dalgleish]

You can't change the sheet protection in a shared workbook, but AFAIK
you can share an Excel file that is password protected.

Did you try it, and encounter some problems?

 

[tthomas]

What does AFAIK stand for?

My steps were:
I opened up the excel file
Save as
tools
general options
created a password
In the worksheet I sepcified track changes while editing
When I save and close out the changes aren't there anymore.

 

[Dave Peterson]

As Far As I Know

http://www.hiddenlab.com/acronym/

If you see others that look funny.

 

[Debra Dalgleish]

You may have to highlight the changes again when you open the workbook,
but they should still be available.

Choose Tools>Track Changes>Highlight Changes
Select the options you want, and click OK

 

[Debra Dalgleish]

Hey! Who says I look funny? <g>

As Far As I Know

http://www.hiddenlab.com/acronym/

If you see others that look funny.

 

[Dave Peterson]

Well, I answered the difficult question--only because I didn't see that there
was a real question, too.

Don't get old. (That's my excuse and I'm sticking to it!)

 

[tthomas]

Thank you!

-----Original Message-----
You may have to highlight the changes again when you open the workbook,
but they should still be available.

Choose Tools>Track Changes>Highlight Changes
Select the options you want, and click OK




--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

.

 

[tthomas]

Thank you!

-----Original Message-----
As Far As I Know

http://www.hiddenlab.com/acronym/

If you see others that look funny.