Question about DPC voting analysis (excel)

02/15/2007 09:35:22 PM · #1

I am using the excel spreadsheet that I think Konador did up. Is there a way to change info in the cells? I made a mistake typing in the vote and now I can't change it, it asks me for a password. Anyone know?

02/15/2007 09:41:55 PM · #2

Originally posted by KarenNfld:

Hi Karen,

I think if you just click on the cell and hit "Delete" you should be OK. Otherwise, try right clicking and "Clear Contents" and see if that works.

02/15/2007 09:46:33 PM · #3

No I tried everything I could think of....it says "the cell you are trying to change is protected and therefore read-only. To modify...blah...blah...remove protection....blah...blah....you may be prompted for a password".

02/15/2007 09:49:02 PM · #4

It won't let you simply type over the contents of the cell, either?

Nikon AF-S NIKKOR 24-70mm f/2.8G ED

02/15/2007 09:50:56 PM · #5

Nope, it always pops up that error when I try.

alfresco

Nikon D700

02/15/2007 09:52:00 PM · #6

It may be [url=//www.meadinkent.co.uk/xlprotn.htm]protected[url]

Go to Tools -> Protection and poke aboot

RainMotorsports

Nikon D60

Nikon AF-S DX Zoom-Nikkor 18-55mm f/3.5-5.6G VR

02/15/2007 09:52:58 PM · #7

Yeah well heres the deal their protected... i dont remember how cells are protected in excel worksheets but the ONLY thing u can do is the exact oposite of how they were protected. search around try right clicking look throught he menus and whatnot.

ANy other attempts are futile!

I know i didnt help at all

nicklevy

Canon EOS-350D Rebel XT

Tamron SP AF 28-75mm f/2.8 XR Di for Canon

02/15/2007 09:54:06 PM · #8

It's possible that certains cells are protected. to remove this:

tools/protection/remove protection

then you should be able to change all the data in all the cells you want unless the guy that made the sheets did put a password wich will be asked to you when you click on remove protection.

Nikon AF-S NIKKOR 24-70mm f/2.8G ED

02/15/2007 09:54:46 PM · #9

Originally posted by nicklevy:

Tried that, it asks for a password.

alfresco

Nikon D700

02/15/2007 09:55:30 PM · #10

I think it's time to rough up Ben ...

02/15/2007 09:56:28 PM · #11

Hmm, the only other thing I can think of is to download it again, and copy/paste the stuff before the entry that was inadvertently entered incorrectly.

The next version of that spreadsheet won't have password protection; I understand it's caused a few people some trouble.

If I could remember what it was, I'd just tell you. Sorry! :)

02/15/2007 09:57:10 PM · #12

Originally posted by alfresco:

I think it's time to rough up Ben ...

Yeah, let's all gang up on Ben! Except, it's not his fault, it's mine. :(