LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default excel calculations

Is there a way to have a window which acts like VB
debugger, but shows each step that excel is performing.
As in the case of circular reference calculations, one
could watch in the order at which excel computes each
cell. So if you have Cells A1, A2, A3, A4, A5, and A1 is
used to compute A2-5, and A2 is used to calculate A1, A3-
5, and so forth through A5 used to calculate A1-4. I have
tried to repeat the calculation long hand 10 different
ways and can not come up with the same information. It
would be beneficial to see how excel starts each and
completes each computation and which order. It could be
used to write more indepth macro's and such.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Help with calculations in Excel Joel Excel Discussion (Misc queries) 14 December 14th 09 01:57 AM
DEG MIN SEC CALCULATIONS IN EXCEL. Gary''s Student Excel Worksheet Functions 0 March 8th 07 06:54 PM
calculations in excel carmen Excel Discussion (Misc queries) 1 July 24th 06 02:53 AM
Excel and calculations s page Excel Discussion (Misc queries) 1 January 16th 06 10:23 AM
excel calculations lloyd8156 Excel Worksheet Functions 1 May 26th 05 07:11 PM


All times are GMT +1. The time now is 08:16 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"