The Lemon Fool

I am still getting the prompt for the password when I close the spreadsheet. Today I opened the spreadsheet (Excel2010), removed a share from my list and closed (and saved) it. The prompt for password appeared. If I click on 'cancel' I am informed that Excel has stopped working and eventually an empty spreadsheet is displayed. If I enter the password, it is happy and the prompt is cleared.
I get the password prompt in other circumstances, but I am usually about to do something else, so I haven't reported this problem again for a while. I can update prices and it doesn't appear.

granretire wrote:I am still getting the prompt for the password when I close the spreadsheet. Today I opened the spreadsheet (Excel2010), removed a share from my list and closed (and saved) it. The prompt for password appeared. If I click on 'cancel' I am informed that Excel has stopped working and eventually an empty spreadsheet is displayed. If I enter the password, it is happy and the prompt is cleared.
I get the password prompt in other circumstances, but I am usually about to do something else, so I haven't reported this problem again for a while. I can update prices and it doesn't appear.

No idea what is causing this, it's working fine for me.
What happens if you download a fresh copy of 11.24.... does this display the same problem?

Do you use Dropbox? Google suggests it could be a cause: http://peltiertech.com/vb-password-prom ... ing-excel/

I've also seen comments that Adobe add-in may be a culprit

--kiloran

I do use dropbox for other files, but not this. I have this problem for the last few versions of the spreadsheet. In fact I raised the 'password problem' on TMF. It doesn't occur every time of using - just updating prices and yield doesn't give rise to the prompt on closing.

granretire wrote:I do use dropbox for other files, but not this. I have this problem for the last few versions of the spreadsheet. In fact I raised the 'password problem' on TMF. It doesn't occur every time of using - just updating prices and yield doesn't give rise to the prompt on closing.

I've tried all sorts and cannot reproduce this problem.
Here's one of the posts on TMF: http://boards.fool.co.uk/but-when-i-clo ... t=postdate

Can you

1. clarify what add-ins you have.
2. Starting with a fresh downloaded copy, describe a specific sequence of events which causes the problem

--kiloran

Downloaded a fresh copy of top-up. No active application add-ins.
Added a share (100 Assura), confirmed and closed, saving the spreadsheet. Password prompt appeared.
Opened spreadsheet again and obtained dividends. Closed, no password prompt.
Opened spreadsheet again, deleted Assura. Closed, password prompt appeared.
Opened spreadsheet again, obtained forecast yields, closed, no password prompt.

This was the first opening of the spreadsheet today, having 'cleaned' pc last night before switching off.

granretire wrote:Downloaded a fresh copy of top-up. No active application add-ins.
Added a share (100 Assura), confirmed and closed, saving the spreadsheet. Password prompt appeared.
Opened spreadsheet again and obtained dividends. Closed, no password prompt.
Opened spreadsheet again, deleted Assura. Closed, password prompt appeared.
Opened spreadsheet again, obtained forecast yields, closed, no password prompt.

This was the first opening of the spreadsheet today, having 'cleaned' pc last night before switching off.

Excellent feedback, granretire. Many thanks.
I don't see this problem with Windows 7 and Excel 2010, but your feedback does give me something to work on.

--kiloran