BExRepositorySheet in BI7 BEx Analyzer

Hi Folks,

Can anybody help me on Bex Repository sheet.

We are using BI7 and have a planning workbook which is embedded with around 26 queries. We used huge VBA code in our workbook.

Currently we are facing some problems like Size (11MB) and performance (opening the workbook and saving data) . After investigating our workbook, we came to know that BexRepositorySheet itself hold 8MB out of 11 MB.

Can anybody help me:

1. What is BExRepositorySheet?

2. What it holds in general?

3. Is it possible to reduce the size of it?

Thanks in anticipation for your valuable feedback / response.

Best regards

Venkat