MS Excel Data Quality Checking

I am working with a very large spreadsheet that is updated monthly. The spreadsheet consists of multiple tabs with many formulas summarizing project data in several different ways.  Each month the report is updated with the new raw data and new columns wiht formulas need to be added for the new month.  Each month there can occasionally be errors in not updating some of the several formulas and I am looking for an efficient and reliable way of data checking the spreadsheet. Also several people use this spreadsheet throughout the company to also add information into the document. any ideas?
rexley11Asked:
Who is Participating?
 
DaveConnect With a Mentor Commented:
Take a look at my free mapping utility, Mappit! at http://www.experts-exchange.com/A_2613.html

It is designed to pick up inconsistencies in spreadsheets, ie
  • changes in formulae accross rows/columns
  • hard coded numbers amongst formulae
  • linked cells etc
Cheers
Dave
0
 
Patrick MatthewsCommented:
rexley,

With seeing a sample of what you are trying to do, it is very difficult to say.  In any event, a complete solution for this will likely far exceed the scope of a typical EE question, but perhaps we could narrow in on a particular aspect of your problem.

Patrick
0
 
rexley11Author Commented:
The answer to the question was as helpful as it could be with the information I had given.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.