at random interval when trying to use the army spreadsheet i get an error message, basically it comes up saying that it is not protected but i must input the password. any ideas? is there some protection on the spreadsheet that i need to remove?
Tends to happen once the file has been open for a while? Go to "Tools" and select "Protech Sheet" which is towards the bottom of the drop down list. Open it and dd the password and OK that. That should fix things.
Wayne
Wayne
yes, it happens after it has been open a while, normally not quite long enough to produce an army list. I've opened the Protect Document in Tools - the window say unprotect sheet, has a blank box with Password (Optional) above it and three buttons to press - help, OK and cancel. no matter what put into the password box and even if i type nothing clicking on OK or cancel tells me that the password is invalid.
i'm stumped, i need to use the calculator to generate an army and it doesn't work - clearly i'm doinf asomething wrong. i downloaded Office libre as suggested but it just keeps locking itself
I had it happen a few times, but then I seem to have managed to avoid it. Maybe I have just been lucky; but saving the sheet early, and re-saving often, seemed to do the trick.
Is it because something is trying to make changes to a protected area? Which could well be possible if you are doing some copying and pasting across a range of cells.