Can anyone tell me a fast way to check the accuracy of multiple formulas
accross multiple worksheets? I have a workbook with about 50 to 60
worksheets in it and I need to check all the formulas for accuracy.
Thanks in advance! Rick


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

I have no idea how you would check a formula for accuracy.
Can you provide further insight what you mean. What you
are looking for, and how you would do this manually.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"ricw >" <<(E-Mail Removed)> wrote in message news:(E-Mail Removed)...
> Can anyone tell me a fast way to check the accuracy of multiple formulas
> accross multiple worksheets? I have a workbook with about 50 to 60
> worksheets in it and I need to check all the formulas for accuracy.
> Thanks in advance! Rick
>
>
> ---
> Message posted from http://www.ExcelForum.com/
>

The best I can think of is to copy and paste the formulas.
Also, if the sheets are all set up the same exact way...A1 has the same
information on all Sheets...then group the sheets and then do the copy and
paste...or better use AutoFill.

Dave French
MS Office XP Master Certified


"ricw >" <<(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Can anyone tell me a fast way to check the accuracy of multiple formulas
> accross multiple worksheets? I have a workbook with about 50 to 60
> worksheets in it and I need to check all the formulas for accuracy.
> Thanks in advance! Rick
>
>
> ---
> Message posted from http://www.ExcelForum.com/
>