Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Auditing Excel Spreadsheets 1

Status
Not open for further replies.

muddha3

MIS
Apr 29, 2004
3
US
I'm looking for ways to secure and audit Excel spreadsheets. Does anyone have any websites, checklists or hints that would help to ensure formulas, data and all other items in the spreadsheet are correct?
 
Nice little resource

"The Toolkit provides dozens of customizable tools for creating, formatting, and auditing Excel spreadsheets, cutting processing time by up to 75%. For example: The AutoColor feature automatically color codes cell entries as you type, or all at once for an entire sheet, making it easy to identify the drivers of the analysis. Format Toggles allow you to hold down a single hot key to toggle through user-defined cell formats. And enhanced Formula Auditing Tools show formula precedents and dependents across multiple worksheets. Macros, formats, and hot keys are customizable." ... Take note, the only reviewer of this tool seems to more than likely be someone who has something to gain, either the author or worker drone.


sil
 
Looks good. Here's a star. I've been looking for something similar. Thanks.

Glen A. Johnson
If you're from Northern Illinois/Southern Wisconsin feel free to join the Tek-Tips in Chicago, Illinois Forum.

TTinChicago
Johnson Computers
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top