Software

Ask something
Question Locked

Tracking Excel?

0 helpful
3 replies

by ademers

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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?

3 replies

by ic-it

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

by ademers

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.

This discussion is closed to new replies.