Advanced Track Changes

[johnva]

I have a large (92Mb) budget Workbook with 100 worksheets with many internal links. My boss wants to see all changes in a final version of the workbook, preferrably by highlighting in yellow any cell that changed (either via input or via calculation).

I am precluded from using any macros, any links to external worksheets and am limited to Excel 2003.

I am familiar with the Track Changes Function, but as far as I am aware, that only works in Shared Workbook Mode (which loses functionality), only highlights changes to input cells, and only saves changes for 30 days.

I need something that highlights all changes due to input and recalculation, and I need them to be easy to view online and in printed format.

Any ideas?

[shg]

Sounds like you'd be better off archiving a copy of the workbook, and then use a compare utility when you're done.