Skip to Content

Analysis for Microsoft Office (Excel) Not Responding when closing – UsageDataCommands

Dec 13, 2017 at 03:09 PM


avatar image

Hi All,

We are working with Analysis for Microsoft Office (AFO Excel), and we have noticed that there is generated in the background a cache file named UsageDataCommands.txt, which causes the following performance issues, every time it gets 10 megabytes of size:

  1. AFO works slowly,
  2. AFO takes about one minute to close by showing a "not Responding" message on the Excel header

If we delete that file manually (UsageDataCommands.txt) , AFO works properly again.

We wonder to know if there is any way to clean/refresh/delete/maintain that file automatically, in order to prevent performance issues in future.

Many thanks in advance for your help,


10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Tammy Powlas
Dec 13, 2017 at 04:43 PM

Hello Jose - I updated your tag to Analysis Office.

First, please consider upgrading to Analysis Office 2.6, released just this month. See and review the What's New documentation

There are more settings for you to manage

If that doesn't help, please share version/SP of Analysis Office that you are using.

Show 3 Share
10 |10000 characters needed characters left characters exceeded

Hi Tammy,

Many thanks for your reply; I've checked both links, and unfortunatelly our issue has not yet been solved by them.

I attach our version below.

Best regards,

Jose Carlos Palomino Bedoya

Jose - it appears you are using the base version of the product / release; please update to the latest patch or upgrade to 2.6


Hi Tammy,

We will do so on January, I will keep you updated.

Many thanks,