#1   Report Post  
Amanda Cooper
 
Posts: n/a
Default Tracking Changes

Hi All,

Just wondered if anyone could help me. I was going through the Track
changes exercise, which is great to produce a report of who has change what
and when etc.



However I then found out that if I was to change my username in
ToolsOptionsGeneral, in excel that track changes goes to pot and tracks
the new username, so in effect I could disguise myself as someone else and
change areas of the spreadsheet without successfully being tracked! Can
this be stopped without using network administration rights to stop people
going in and changing the username?



Many Thanks
Amanda


  #2   Report Post  
Kassie
 
Posts: n/a
Default

With your value in A2, in B2 enter =A2*.2
You can also use an anchor cell, where you keep your percentage, entered as
,2, say X1. You will then enter in B2 =A2*$x$1

If you want to add the 20%, change your formula to =A2*(1+$X$1), or =A2*1.2

"Amanda Cooper" wrote:

Hi All,

Just wondered if anyone could help me. I was going through the Track
changes exercise, which is great to produce a report of who has change what
and when etc.



However I then found out that if I was to change my username in
ToolsOptionsGeneral, in excel that track changes goes to pot and tracks
the new username, so in effect I could disguise myself as someone else and
change areas of the spreadsheet without successfully being tracked! Can
this be stopped without using network administration rights to stop people
going in and changing the username?



Many Thanks
Amanda



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Where is the Template Wizard with Data Tracking Excel 2003? liz braford Excel Discussion (Misc queries) 8 December 7th 05 06:50 PM
How do you create a vendor tracking form for accounts payable pro. FLBusybody Excel Discussion (Misc queries) 0 February 24th 05 03:13 AM
Tracking Time (Hours/Mins) sdmccabe Excel Discussion (Misc queries) 1 February 1st 05 04:39 PM
tracking changes Sherry Excel Discussion (Misc queries) 0 January 25th 05 04:49 PM
Is there a template for legislative tracking in excel? Liz Excel Discussion (Misc queries) 0 December 3rd 04 05:59 PM


All times are GMT +1. The time now is 05:03 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"