Tracking Changes Question

Hi,

We are trying to find a way to track all of the changes to our 
spreadshets and, I was hoping, to our modules.

This is related to the Sarbanes Oxley Act.  The powers that be want to 
freeze our spreadsheets at a point in time and then track any changes 
that we make.

Is anybody familiar with this?

Thanks,
Anita

0
graylatt (1)
6/20/2004 7:25:05 PM
excel.misc 78881 articles. 5 followers. Follow

1 Replies
681 Views

Similar Articles

[PageSpeed] 38

Yes, you need to make the workbook a shared worbook (Tools>Shar
Workbook) then select enable tracking (Tools>Track Changes). 'Here's
(http://tinyurl.com/3e3g3) the official line. Or you can find 
tutorial 'here
(http://www.jmu.edu/computing/workshop/handouts/xp/C135.pdf)  or bette
still search for track changes in the Ecel help file that comes wit
the program

--
Message posted from http://www.ExcelForum.com

0
6/21/2004 4:50:03 AM
Reply:

Similar Artilces:

Program Question for Dave peterson
I have a User Form that is in a workbook by itself. This User Form controls and updates 3 other workbooks. Workbooks are as folllows: User Form Spec Forms Label I had all my code in the Main User Form code window, but several of the Subs got to big to run and it got to confusing to try and find what went where. At that point I moved the code from the Main User Form code window to individual Modules. Each module has only the code for that type of Sub for each of the 3 workbooks. Then in the Main User Form code window I use the following code to call the Subs. '***...

A question involving attaching formulas
hello (I'm from belgium so my english therms might not be th�t good) don't know where to start but I'll try, my problem is: They asked me to 'attach' formulas to words example; if I typ 'Corpus' (or select it in some sort of a pop up menu) the formulas (attached to it?) have to appear automaticly some cells further. actually it's for calculating prices, so if I want to calculate a certain closet, I have to choose the different parts (like corpus or door) with the different formulas attached (because there are different doors). it's kinda hard to expla...

MSExchangeAL 8331 Error and Hotfix Questions
Ok..I get the 8331 event every minute. I noticed that newly created email accounts are not showing up in Global Address list and after reading problems associated with the 8331 error,I figured that they were related to each other. Who has installed the hotix? Does the hotfix seem to fix the error showing up in application log and also fix any related email issues? What requirements are there with the hotfix...such as does it require users to be out of email or require a server reboot? Scott, I have had some of my customer install the hotfix, from their reports to me it has resolved the probl...

Excel 2007 Send command question...
In Excel 2007. Ya click on the Office orb and you select "Send..." you are offered to send a copy of the document to other people. How can you edit or add what "Send" feature you want to use. I have the choices of send as e-mail, and XPS Document, a PDF Document or Fax. My friend only has the option of send as a fax. Are there settings somewhere to edit this list or any other way of editing your choices here? Thanks in advance for any help you can offer. -Greg Does your friend have Outlook? Has your friend installed the PDF/XPS writer from Office Online? Greg...

How-to track IMF messages
I'm relatively new to exchange. I can't seem to figure out how to track messages that are being deleted by IMF. I can see that they are being deleted in message tracking but would like to know why they are being deleted. Any help would be appreciated. Thanks in advance! Joe IMF doesn't tell you why. If you want, you can change Store action to archive messages instead of deleting - with an option to expose SCL (Spam Confidence Level) scores in headers of these messages. -- Bharat Suneja MVP - Exchange www.zenprise.com NEW blog location: www.exchangepedia.com/blog --------...

how can I change Art text colour
I know how to insert Word Art in Pub 2003 but am unable to change the font colour. I know how to do this with font in a text box but not with Word Art Please can you help? Select the WordArt, click the format WordArt (the icon with the bucket and brush), or right-click, format WordArt... -- Mary Sauer MSFT MVP http://office.microsoft.com/ http://msauer.mvps.org/ news://msnews.microsoft.com "ceibach" <ceibach@discussions.microsoft.com> wrote in message news:96D5C288-DF42-44E2-B8EE-7FFDE7FB337C@microsoft.com... >I know how to insert Word Art in Pub 2003 but am unable t...

Auditing Change of Mailbox Permissions Rights
I=B4m looking for a solution to audit the changes of Mailbox Permissions Rights. I tried to monitor the Event ID 642 in DCs but doesn=B4t appear this change. Any ideias? Regards, Guido I don't think there is a method to monitor the msExchMailboxSecurityDescriptor field in AD, this attribute is not listed as one that can be audited as with the case of other Exchange attributes. Auditing is not the best in Exchange. The closest I've ever come to auditing is by taking pre/post snapshots of previous states of rights using scripts and comparing to see what changed. It doesn't give y...

Popup window question
When I first open my Outlook 2003, a window pops up that says "Microsoft LDAP Directory" Then it says "Server Name: NULL" "Port: 3268" "Username: NULL" "Password: " How can I keep this from popping up and what does it mean? Thanks! ...

Can I change Excel default settings (two issues)
Issue #1: (Row height) I always want my row height to be 20.0, but Excel 97 at work is set by default to 12.75, and the Excel 2003 at home is at 13.5. Am I stuck with that? Do I *always* have to manually change to 20, or is there some way I can change the default height to 20? Issue #2: (Text Import Wizard) Step 3 of the Text Import Wizard defaults to "General" in regard to the "Column Data Format". I *always* want to use "Text". Must I always select the columns and switch to text, or is there some way I can instruct Excel to default to the "...

countif(Range,criteria) question
For 'Range' i would like the intersect of the row in which the function resides and the adjacent, named 6 x 6 range. I,ve tried =Countif(MyRng Row(), MyCrit) but no joy Please advise, Thanks Use offset function like this =COUNTIF(OFFSET($A$1,0,1,1,6),">0") The offset parameters are as follows Offset(Rows offset, column Offset, Number of Rows, Numbeer of columns) I put the formula into A1 and the function uses a range starting one column to the right of A1 with a size of 1 row and 6 columns. -- joel ------------------------------------------...

Tracking users who open my workbook
Sorry ... continuation of my previous e-mail. The hidden worksheet or separate workbook to be set up for example ... so username is in column A, date column B and time in column C. Fred Flintstone hu kiteb: > Sorry ... continuation of my previous e-mail. > > The hidden worksheet or separate workbook to be set up for example > ... so username is in column A, date column B and time in column C. What's to stop someone from copying the file and viewing it locally, or viewing it without making changes? It is quite easy for a given user to see the contents without forcing a sav...

Question about joining 2 domains
Right, I've got a bit of an unusual question, and I'm not sure at all if it can be done. What I want to do (in short) is combine 2 domains. This would mean that our exchange/domain would do all the internet traffic, as well as handeling the mail send to our domain. Now. Mail from the other domain, should be relayed through our server before beeing send to the internet, and should be changed to our domain. An added problem would be that the mailserver for B.com is Unix based. So in short, our domain would be A.com and the want I want to link is B.com. Now, mail send from B.com (ie. jo...

Bulk change displayname MSX2003
Is there an easy way to bulk change displayname for a large DIR You would have to do and LDAP export, edit the file, then import it back into AD. Todd "JR" <anonymous@discussions.microsoft.com> wrote in message news:d0e901c48a97$04d88510$a601280a@phx.gbl... > Is there an easy way to bulk change displayname for a > large DIR IS there a tool/utility for this >-----Original Message----- >You would have to do and LDAP export, edit the file, then import it back >into AD. > >Todd > > >"JR" <anonymous@discussions.microsoft.com&...

changing "numbers formatted as labels" into numbers
i have an excel spreadsheet that contains about 2000 rows of data. on of the columns is a 17 digit number that acts like a label, (I canno format the number. I think the data was converted from a database fil into excel. when I received the spreadsheet, the numbers were formate as labels. how can I get Excel to see this column as numbers and no labels? thank you for your help -- Message posted from http://www.ExcelForum.com You can't if they are 17 digits, or rather excel will truncate everything after 15 digits. You would need to use text representation of numbers like that -- ...

changing the information on a pub. flyer from a cd
Hello, I was wondering if anyone knows when I save a flyer I have created on pub. onto a cd, if I give the cd to someone else, can they maniplate the content as needed for them? nicnacdc <nicnacdc@discussions.microsoft.com> was very recently heard to utter: > Hello, I was wondering if anyone knows when I save a flyer I have > created on pub. onto a cd, if I give the cd to someone else, can they > maniplate the content as needed for them? Yes, provided: a) You use the Pack and Go wizard to make sure that all linked files are included b) The recipient works with the file on h...

Queries Links Change
I have a general question on Access 2003. I have several applications that run in the following manner: Step 1: Make Table queries runs and creates some large tables (extracting data out of ORACLE, etc.). Step 2: several other queries run for summing totals, etc. using tables from step 1 Step 3: Import process deletes tables from step 1 to clean up space in the database. The problem I seem to run into is that if someone goes into the queries from step 2 in design view when the tables are NOT existing in the database, the links and tables are not there and queries get saved with no link...

Changing the font of tree ( folders)
Hi, I changed the menu font using Desktop properties->Appearance. And changed the font in the messages pane ( mail rows) using organize thi folder. Now the left hand tree ( which displays the folder, contacts, task ect) alone is in Tahoma font, that I want to change to arial. Is i possible to do? If so kindly let me know how to do the same? Rgds, Ramesh ----------------------------------------------- ~~ Message posted from http://www.ExcelTip.com ~~View and post usenet messages directly from http://www.ExcelForum.com ...

Free /busy attribute set to none by EWS when user changes permissions on calendar
We've discovered that when an EWS users changes the permission of his/her Exchange calendar that the permission level is displayed as Custom in Outlook 2007 when look there. This is because the free/busy attribute is set to None by EWS. This turns off free/busy to all other Exchange users. As an example, Bill is a EWS user who adds a entry on his calendar for Sally with a permission level of Reviewer. Other users when scheduling a meeting will Bill cannot see the his free/busy. When Bill accesses his Exchange account with Outlook 2007 he sees the permission level for Sally s...

a simple question #2
yes, i thought that would work...but it doesnt, is it possible that have disabled an option somewhere, and if so...where? thank -- cm70 ----------------------------------------------------------------------- cm700's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1505 View this thread: http://www.excelforum.com/showthread.php?threadid=26676 Cannot be done without using VBA. Chip Pearson wrote some code for this. Adds a couple of "unselect" commands to the Cells right-click menu. Read both of Chip's posts to get all the code. First post is a co...

CTreeCtrl : change item rect #2
Hi, Anyone knows how to change the items rect in a CTreeCtrl object? Thanks in advance, Jorge Loureiro ...

Change hyperlink default?
Version: v.X Operating System: Mac OS X 10.3 (Panther) Processor: Power PC Is there any way to change the default from automatic creation of a hyperlink to a menu command? No. The only alternative I am aware of is to use Paul Berkowitz's "Make Hyperlinks X" script, if you wish. You can get it for free here: http://www.scriptbuilders.net/search.php?search_str=Make+Hyperlinks On 7/3/08 1:53 PM, in article 59b532d2.-1@webcrossing.caR9absDaxw, "av@officeformac.com" <av@officeformac.com> wrote: > Version: v.X > Operating System: Mac OS X 10.3 (Panther) >...

how do i change text sizes for incoming messages when email is ope
when i open an email coming in the text size for some reason has suddenly reduced to about 6 - 8 pt from the original 2 days ago of 10 pt. using text size button has no effect - it seems to be non operational Formatting columns or rows only changes the font size for the view pane On reply or forwarding of email the font size if the original message changes back to 10 point Did you zoom? Hold ctrl as you scroll the mouse wheel or click the zoom button in Outlook. -- Diane Poremsky [MVP - Outlook] Outlook Tips: http://www.outlook-tips.net/ Outlook & Exchange Solutions ...

Macro Questions:
Hi there Hopefully these questions wont sound too primitive: a) I've recorded a very simple macro that copies a row of date (C10 to O10) and pastes (paste special - values only) into a master work book. The entry point in the master work book is the current active cell; each new row of data goes into a new row (B4, B5, B6 etc...) slowly building a table. My question is how do I make the macro end with the active cell in the next row in B column - so I can run the same macro again on the next spreadsheet? b) How wise is it to use the 'save' command in a macro? c) How do I ke...

Simple Printing Question
Excel 2000. I have a large but simple database with only 5 or 6 fields. If I want to print the last several records of the database how do I get the field titles to print at the top of each column, not only the 1st page but on subsequent pages in the printout also? -- Thanks in advance... Bob Bob, File - Page Setup - Sheet. "Rows to print at top." -- Earl Kiosterud mvpearl omitthisword at verizon period net ------------------------------------------- "Bob Newman" <bobnewman@worldnet.att.net> wrote in message news:kDsrb.223794$0v4.16735255@bgtnsc04-news.ops...

Subject Tree in Cases question
Hi all, I'd like to build a subject tree so that I can easily search in cases that have been closed. My question is: Imagine that one node of my subject tree is: Products - >ProductA->NetworkIsssues->VPN ->ProductB->NetworkIssues->VPN So the root node is Products and sub nodes are ProductA and ProductB Now I create a case for ProductA related to VPN issue, I will scroll Products->ProductA->NetworkIssues->VPN (only VPN will be then put in the subject of the case) three months later I have a similar case regarding also ProductA and ...