Tracking Excel?

By ademers ·
Is there a way to track or display the steps that a spreadsheet is taking during calculation routines and vlookups?

I am supporting a user who complains that his Excel locks up on him whenever he is in a particular spreadsheet. This spreadsheet pulls data from various locations including Bloomberg.

After a while, Excel will being responding again but we would like to try and figure out where the bottleneck is occuring and fix it.

Anyone have experience with an issue similar to this?

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Collapse -

It sounds obvious

by IC-IT In reply to Tracking Excel?

The delay ("lockup") occurs while it is pulling the data that it needs "from other locations".

Collapse -

Excel Tracking

by ademers In reply to It sounds obvious

I'm not going to dispute that the lockup is occuring when Excel is trying to pull data for calculations.

The real question here is which data locations are causing the lockup and how can that be tracked?

I would need to see some sort of progress log to idenfity the exact issue.

Related Discussions

Related Forums