Clear Metadata Cache

[Former Member]

I had an error that I have listed below and had to clear the metadata cache to fix it.  I do not have the metadata cache activated under user option so I am not sure why I had to clear the cache to get things working.  Can someone explain why I had to do this and where the metadata cache is located?

Error:

Index was out of range. Must be non-negative and less than the size of

the collection.

Parameter name: startindex

[former_member186498]

Hi Kevin,

it's a very hidden worksheet present in your workbook, alt+F11 to open VBA, click on your workbook and select EVDRE_DATACACHE put it visible and delete it, BPC will recreate this new.

Kind regards

     Roberto