Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I'm in the middle of a SOX audit and one of the issues that came up was Excel
reports used for journal entries in our ERP. We were told that we will need to validate Excel in order to use our spreadsheets and also be in compliance with SOX. I can think of a few things to do, but any help would be greatly appreciated. Can Excel be validated? My thoughts: 1. lock the formulas 2. Restrict Access to cells 3. Password protect 4. Turn tracking on - will this track any changes that is done with formulas & macros? Anything anyone can contribute to this would be appreciated. Dan |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
how do I validate the value and not the formula in excel? | Excel Worksheet Functions | |||
Restrict-Filter-Limit-Validate user input in Excel | Excel Discussion (Misc queries) | |||
Can you use the validate function in a data form in Excel? | Excel Worksheet Functions | |||
HOW DO I GET EXCEL TO VALIDATE TWO CELLS AT ONCE | Excel Discussion (Misc queries) | |||
how to validate excel spreadsheets | Excel Discussion (Misc queries) |