Skip to Content
0

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

Dec 13, 2017 at 03:09 PM

141

avatar image
Former Member

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,

Regards,

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
0

Hello Jose - I updated your tag to Analysis Office.

First, please consider upgrading to Analysis Office 2.6, released just this month. See https://blogs.sap.com/2017/11/20/asug-webcast-whats-new-in-analysis-office-2.6-recap/ and review the What's New documentation https://help.sap.com/viewer/7dc219dcd5ac483682a57e1cf9f2369c/2.6.0.0/en-US/c5983dd62dd44a98a0be3f2b24dd89cd.html

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
Former Member

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,

0

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

0
Former Member

Hi Tammy,

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

Many thanks,

Regards,

0