Search results

Porcupine Tree knew

I don't think that's the case but will check when he's back from his holiday.

Yeah that's why I'm unsure if it's an excel specific problem. But I can be in the workbook in read only after I've selected 'Notify' (because it's told me that my colleague has it open for editing), and then sure enough about half an hour to an hour later I get a message saying that it's...

Not really no. The only people who use these workbooks in write mode are the two of us (not at the same time of course)

Another random problem that one of my co-workers is having is that he regularly will be working on a workbook in write mode and approx. half an hour later I'll hear him swearing and then showing me that his file has gone from write mode to read only. I've never seen this before and thankfully...

Hi Doc, yes we are all using the same versions and I also have my workbooks open with a choice between write and read-only so staff will only go into one in write mode by accident, which is no problem as we can tell who it is. We are using 365 yes. I guess what I need to do now is work out how...

That's ok I wasn't exactly sure either but what you have described is pretty much the behavior I'm seeing. What I find strange though is that there is no locking file present at all when this happens.

The workbook is pretty much 'stand-alone' and not linked with anything. I think I've pretty much narrowed it down to people who are using the file in read-only mode while I've had it in write mode. So when I close the workbook the locking file gets deleted, but for some reason there is a...

As Gasman states, your range is wrong to being with, but the syntax looks weird also. You really should end up with something like this Range("B5:C16").Sort Key1:=Range("C5"), Order1:=xlDescending, Header:=xlYes

Thanks for that Doc_Man, will look into the link and whether or not I'm even allowed to use it at work. As for the OPENFILES /Query - I got a 'ERROR: Access is denied.' which I guess means that I would have to run as an Administrator, but then I have no authorisation for that either.

Maybe not an Excel question per se but this is where the problems are occurring so I'll post it here. I constantly have issues where I go to open one of my workbooks (on a network) and it comes up with the msgbox stating that "file is locked for editing by 'another user' " or by an actual user...

Probably for the same reason as me when people tell me that my imaginary friend isn't real.

That was..... strange

Yeah they're amazing alright - one of the best drummers I've ever heard and fantastic songwriting. Check out their album Fear of A Blank Planet if you want to hear some concept album greatness!!

Now we're talking - I've seen Joe live 3 times now in NZ and he never fails to deliver an amazing show. I'm pretty much half way down the rabbit hole of discovering a band called Porcupine Tree - Unbelievably good prog band from the UK who most people have never even heard of. I certainly...

Mind you, a lot of people also like the Red Hot Chilli Peppers and I'd rather have red hot needles poked into my eyeballs than listen to them :ROFLMAO: And now my wife has come out saying that she really doesn't like Pink Floyd...!!! So I could be single soon...

Personally I don't find that surprising at all - Although I was not around when they were big, I find their music almost un-listenable.

Any Floyd / Prog rock fans here...? A bit of shameless promotion for a young up-and-coming band in NZ (that my step-brother has also just joined and now plays bass for :cool:) All self produced, recorded, mastered and everything else by the band. Opening track on their 2nd album Syd...

Yeah I know - I listened to it and all I could picture was muppets sorry :D