Print

Please login or register.
1 Hour 1 Day 1 Week 1 Month Forever
Login with username, password and session length

[Bigron]

I need to monitor and record my blood pressure daily and use Excel to do so, but as of yesterday I am unable to enter new data in the cells: no response at all!
I tried refreshing and even making a new spreadsheet, but the son of a bachelor stubbornly refuses to co-operate. Any ideas gents?

Ron.

[Nick W]

Have you been using it to store your car's maintenance records? 

[Entwood]

have you tried rebooting the system ??

If, for some weird reason (ie microsoft just does it), the system "thinks" you already have a copy of the spreadsheet open (even if you can't see it) it will "lock" all cells/transactions to avoid corruption.

A system restart usually solves it as it shuts down all background activity and should allow you to open the document properly

[Bigron]

I have closed all versions of the spreadsheet (I have one per month), done a complete CrapClean using CCleaner and a re-start of the computer. I did nothing differently when using Excel, it just went into this major sulk!

Ron.

[aaronjb]

TB will be along in a minute to tell you that Excel is for office <somethings> and that you should be writing it on labels and sticking them to yourself instead, because that's way easier...

[Bigron]

Labels won't give me charts or work out averages for me, and with Excel I can show my GP posh results!
Anyway, I now have it working and it was embarrassingly simple - and stupid!!! 

Ron.

P.S. Anyone care to guess what the fault was? I ain't saying.....

[Entwood]

Labels won't give me charts or work out averages for me, and with Excel I can show my GP posh results!
Anyway, I now have it working and it was embarrassingly simple - and stupid!!! 

Ron.

P.S. Anyone care to guess what the fault was? I ain't saying.....

Inadvertently protected the workbook ?? 

[aaronjb]

P.S. Anyone care to guess what the fault was? I ain't saying.....

I'm guessing the fault is called "Ron"? 

[Bigron]

Yep. but why?

Ron.

[Doctor Gollum]

Yep. but why?

Ron.

Because you're called Ron and it's all your fault... 

[biggriffin]

I'll just leave this suggestion here.
 A cheap diary and pen. Works for me, and can't crash or go wrong.

[Field Marshal Dr. Opti]

I need to monitor and record my blood pressure daily and use Excel to do so, but as of yesterday I am unable to enter new data in the cells: no response at all!
I tried refreshing and even making a new spreadsheet, but the son of a bachelor stubbornly refuses to co-operate. Any ideas gents?

Ron.

This is enough to give you high blood pressure.

[TheBoy]

TB will be along in a minute to tell you that Excel is for office <somethings> and that you should be writing it on labels and sticking them to yourself instead, because that's way easier...

It is indeed an Office Wnakers tool that serves no purpose for 99.9% of the population.  Including Office knobjockey morons I work with, because Project, Word and Notepad are too difficult for the carrot crunchers who think the world ends at the banks of the River Orwell.

[Bigron]

{n my case, TB, it's nothing to do with any office but to collate essential diagnostic data for my GP - which HE values even if you don't!

Ron.

[TheBoy]

He's clearly an office tosser as well then