BW Excel file password problem

[Former Member]

Hi All

We have a unique problem in BW. We are on version 3.1C. When we open downloaded excel files containing hierarchies, the system asks for a password. However system does not accept any password and it results in a userid lock.

Any idea how we can resolve this?

Rgds

Shobhana.

[Former Member]

Hello Praveen

The problem is during file open itself. I am not worried on saving the file.

Pl see these steps:

1. I download a report to excel from BW on my local PC

2. I try to open the file in excel

3. System keeps on prompting for userid/password a number of times (Although I give a correct id and password, it keeps on asking the same).

4. The userid gets locked.

5. Since the file does not open successfully, there is no question of saving the same.

This typically happens for files containing hierarchies.

Rgds

Shobhana.

[Former Member]

Hi,

Step-1)Open the workbook.

Step-2)On the File menu, click Save As.

Step-3)On the Tools menu, click General Options.

Step-4)In the Password to open or Password to modify box (or in both boxes), Step-5)double-click the asterisks and then press the DELETE key.

Step-6)Click OK, and then click Save.

Step-7)Click Yes to replace the existing workbook.