Auditing in Numbers 09?

Question

Level 1

9 points

Auditing in Numbers 09?

Does Numbers 09 have any auditing tools? Excel has a way of graphically linking cells to show formulas for audit purposes, which is a very quick way of reviewing to see the correct cells are represented in formulas.

This was missing from Numbers 06 and Numbers 08, and I am hoping Apple added it to Numbers 09.

Macbook Pro 15", Mac OS X (10.5.6), Macbook Pro, Macbook Air, Powerbook, Mac Mini...

Posted on Jan 6, 2009 8:50 PM

Reply

Answer 1

Ashka

Level 4

3,891 points

Jan 7, 2009 12:05 AM in response to Charlesa8

There wasn't a Numbers app in iWork '06.
Version 1 was included with iWork'08 & Version 2 is in iWork'09.
No idea what excel does or doesn't do now, I haven't used it for over 10 years.

Numbers has Always graphically shown by colour which cells are included in each formula when you select the cell the formula is in.

Try the Free 30 day trial and see if it suits the way you work.
http://www.apple.com/iwork/download-trial/
Best

Reply

Answer 2

aras

Level 1

0 points

Jan 7, 2009 3:40 AM in response to Charlesa8

Yes, iWorks09 Numbers have a formula auditing possibility. Menu -> View -> Show Formula list or icon in toolbar with name "Formula list". After that You will see all formulas whta is in table. I hope that it will help You.

Aras

Reply

Answer 3

jaxjason

Level 5

5,063 points

Jan 7, 2009 5:06 AM in response to Charlesa8

I know the tool your talking about, its the "Formula auditing toolbar" in excel and has tools to graphically overlay arrows show cell dependants and precedents. Sadly this is not there yet. (that I have seen) But just like all of the stuff that you see added to numbers '09, submit feedback using the feedback option under the numbers Menu, it may make it in '10.

Jason

Reply