Tracking changes

Excel Facts

Repeat Last Command
Pressing F4 adds dollar signs when editing a formula. When not editing, F4 repeats last command.

Peter1973

Well-known Member
Joined
May 13, 2006
Messages
934
Im completely stuck with this , basically I have a workbook at work which I am resposible for maintaining however as this workbook is readilly accessable for all on the network I have been noticing some strange alterations (which I suspect are purposely done) whoever the only way I can think of is to share the workbook and track changes however as they workbook is used in a live situation if I share it and changes are made then it is leaving room for error in the way that someone could complete their task before other changes have been updated. I am racking my brain to see if i can track changes without sharing the workbook. If that is not possible one other alternative is to password protect the workbook and all changes must be done by myself (creating more work for an under paid employee). However when I protect the workbook it always seems that certain changes by others are not permitted ie hiding /unhiding cells.

Someone help.................................................................................
 

Watch MrExcel Video

Forum statistics

Threads
1,129,811
Messages
5,638,488
Members
417,027
Latest member
wlknspc7

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top