Omega Owners Forum

Please login or register.

Login with username, password and session length
Advanced search  

News:

Please play nicely.  No one wants to listen/read a keyboard warriors rants....

Pages: [1] 2 3  All   Go Down

Author Topic: Excel gone bozwonk!  (Read 662 times)

0 Members and 1 Guest are viewing this topic.

Bigron

  • Omega Baron
  • ******
  • Offline Offline
  • Gender: Male
  • Witham, Essex
  • Posts: 4564
    • Omega 2.6 V6 Auto '51 Reg
    • View Profile
Excel gone bozwonk!
« on: 31 July 2019, 10:30:13 »

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.
Logged

Nick W

  • Omega Lord
  • *******
  • Offline Offline
  • Gender: Male
  • Chatham, Kent
  • Posts: 7265
  • Rover Metro 1.8VVC
    • 3.0l Elite estate
    • View Profile
Re: Excel gone bozwonk!
« Reply #1 on: 31 July 2019, 10:47:05 »

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

Entwood

  • Omega Queen
  • ********
  • Offline Offline
  • Gender: Male
  • North Wiltshire
  • Posts: 19107
  • My Old 3.2 V6 Elite (LPG)
    • Audi A6 Allroad 3.0 DTI
    • View Profile
Re: Excel gone bozwonk!
« Reply #2 on: 31 July 2019, 11:06:10 »

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
Logged
V6 Cam locking/setting kit, Maxscan GS500 OBDII code reader/EML resetter available.  

Bigron

  • Omega Baron
  • ******
  • Offline Offline
  • Gender: Male
  • Witham, Essex
  • Posts: 4564
    • Omega 2.6 V6 Auto '51 Reg
    • View Profile
Re: Excel gone bozwonk!
« Reply #3 on: 31 July 2019, 14:30:59 »

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.
Logged

aaronjb

  • Omega Knight
  • *****
  • Offline Offline
  • Gender: Male
  • Northampton
  • Posts: 1597
    • Not an Omega
    • View Profile
Re: Excel gone bozwonk!
« Reply #4 on: 31 July 2019, 14:52:48 »

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... ;)
Logged
now: 2006 BMW 650i, 2007 Mini Cooper S, 2009 Range Rover Sport TDV8
ex: 2.5TD CD Estate, 3.2V6 Elite Estate

Bigron

  • Omega Baron
  • ******
  • Offline Offline
  • Gender: Male
  • Witham, Essex
  • Posts: 4564
    • Omega 2.6 V6 Auto '51 Reg
    • View Profile
Re: Excel gone bozwonk!
« Reply #5 on: 31 July 2019, 15:13:49 »

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.....
Logged

Entwood

  • Omega Queen
  • ********
  • Offline Offline
  • Gender: Male
  • North Wiltshire
  • Posts: 19107
  • My Old 3.2 V6 Elite (LPG)
    • Audi A6 Allroad 3.0 DTI
    • View Profile
Re: Excel gone bozwonk!
« Reply #6 on: 31 July 2019, 15:17:55 »

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 ??  :)
Logged
V6 Cam locking/setting kit, Maxscan GS500 OBDII code reader/EML resetter available.  

aaronjb

  • Omega Knight
  • *****
  • Offline Offline
  • Gender: Male
  • Northampton
  • Posts: 1597
    • Not an Omega
    • View Profile
Re: Excel gone bozwonk!
« Reply #7 on: 31 July 2019, 15:21:35 »

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

I'm guessing the fault is called "Ron"?  :P ;)
Logged
now: 2006 BMW 650i, 2007 Mini Cooper S, 2009 Range Rover Sport TDV8
ex: 2.5TD CD Estate, 3.2V6 Elite Estate

Bigron

  • Omega Baron
  • ******
  • Offline Offline
  • Gender: Male
  • Witham, Essex
  • Posts: 4564
    • Omega 2.6 V6 Auto '51 Reg
    • View Profile
Re: Excel gone bozwonk!
« Reply #8 on: 31 July 2019, 15:32:06 »

Yep. but why?

Ron.
Logged

Doctor Gollum

  • Omega Queen
  • ********
  • Offline Offline
  • Gender: Male
  • In a colds and darks puddleses
  • Posts: 13524
  • If you can't eat them, join them...
    • Feetses.
    • View Profile
Re: Excel gone bozwonk!
« Reply #9 on: 31 July 2019, 16:39:06 »

Yep. but why?

Ron.
Because you're called Ron and it's all your fault...  :D
Logged
Onanists always think outside the box.

biggriffin

  • Omega Lord
  • *******
  • Offline Offline
  • huntingdon, Hoof'land
  • Posts: 8047
    • Vectra in a posh frock.
    • View Profile
Re: Excel gone bozwonk!
« Reply #10 on: 31 July 2019, 17:09:48 »

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

Rwd-less..

Field Marshal Dr. Opti

  • Over Active Thyroid
  • *********
  • Offline Offline
  • Gender: Male
  • South Lincolnshire
  • Posts: 23027
  • Shami and TB forever.
    • View Profile
Re: Excel gone bozwonk!
« Reply #11 on: 31 July 2019, 17:53:34 »

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.
Logged

TheBoy

  • Administrator
  • *********
  • Offline Offline
  • Gender: Male
  • Brackley, Northants
  • Posts: 99341
  • Millennium Man
    • The missus mad
    • View Profile
Re: Excel gone bozwonk!
« Reply #12 on: 31 July 2019, 19:11:29 »

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.
Logged
I don't tolerate bickering, and I'm always grumpy.
And Lizzie Zoom says I'm a heartless bastid...and she's absolutely correct!

Bigron

  • Omega Baron
  • ******
  • Offline Offline
  • Gender: Male
  • Witham, Essex
  • Posts: 4564
    • Omega 2.6 V6 Auto '51 Reg
    • View Profile
Re: Excel gone bozwonk!
« Reply #13 on: 31 July 2019, 19:17:07 »

{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.
Logged

TheBoy

  • Administrator
  • *********
  • Offline Offline
  • Gender: Male
  • Brackley, Northants
  • Posts: 99341
  • Millennium Man
    • The missus mad
    • View Profile
Re: Excel gone bozwonk!
« Reply #14 on: 31 July 2019, 19:18:19 »

He's clearly an office tosser as well then ;)
Logged
I don't tolerate bickering, and I'm always grumpy.
And Lizzie Zoom says I'm a heartless bastid...and she's absolutely correct!
Pages: [1] 2 3  All   Go Up
 

Page created in 0.125 seconds with 21 queries.