This website is not affiliated with, sponsored by, or approved by SAP AG.

General Waffle with embedded Excel query

Discussion about non-SAP related issues: Inquiries, Personal & Commercial advertisements, etc. ( For registered users only)

Moderators: rtella, Snowy, thx4allthefish, The Prince Of Darkness

Post Reply
Squarebear
Posts: 230
Joined: Thu Apr 17, 2003 8:24 am
Location: UK

General Waffle with embedded Excel query

Post by Squarebear » Tue Feb 17, 2015 6:18 am

I'm quiet, me. I tiptoe about in my B&B so as not to disturb anyone, but I have realised this is counterproductive as it leads other residents to suppose the dividing walls are like granite when in fact they are like paper.

So my consideration is rewarded by various gits having loud phone calls at 2am while sitting on the bog, peeing at all hours of the night without pointing at the porcelain, blowing their noses in the bathroom with that trumpet sound.

Yes, I forgot my ear plugs this week.

Here's the random excel query.

I've prepared a number of Excel worksheets that use VLOOKUP. If I change any formatting then my Excel recalculates the formulas. That's ok. It takes ages, but it's ok.

But the real problem is that this stops Excel working until the recalculation has finished. If I try and open a new instance of Excel it simply hangs until the recalculation is done. All other worksheets currently open also hang. I am, in short, knackered.

My PC is 4GB RAM. The spreadsheets are wide (100 cols) rather than long (2000 rows). Is there some way I can multitask in Excel? This is just like that Chinese bloke's favourite footballer. It's Artur Boracs.
Possibly the most modest person in the world.

Gothmog
Posts: 1946
Joined: Wed Sep 12, 2007 4:46 am
Location: Probably not home

Re: General Waffle with embedded Excel query

Post by Gothmog » Tue Feb 17, 2015 8:04 am

Sure, you can multitask using Excel - just use several PCs.
As for noisy neighbour problems, I recommand a porn audio track at high volume, this should keep them quiet for a while.

Disclaimer: this post may contains traces of bad solutions to annoying problems. Use at your own risk.
68 74 74 70 3a 2f 2f 74 69 6e 79 75 72 6c 2e 63 6f 6d 2f 62 64 6f 37 6d 77 67

Squarebear
Posts: 230
Joined: Thu Apr 17, 2003 8:24 am
Location: UK

Re: General Waffle with embedded Excel query

Post by Squarebear » Tue Feb 17, 2015 8:59 am

You're a good man.

I have ordered eight PC's, some decent speakers, and Ron Jeremy's greatest hits.

Plus these ear plug:

http://www.international.boots.com/en/B ... irs_39424/
Possibly the most modest person in the world.

Gothmog
Posts: 1946
Joined: Wed Sep 12, 2007 4:46 am
Location: Probably not home

Re: General Waffle with embedded Excel query

Post by Gothmog » Tue Feb 17, 2015 9:08 am

Great!
Now plug your ears, and run these greatest hits on the 8 PCs through the speakers - with a slight time lag on each PC for a better effect
68 74 74 70 3a 2f 2f 74 69 6e 79 75 72 6c 2e 63 6f 6d 2f 62 64 6f 37 6d 77 67

Rich
Posts: 7116
Joined: Thu Oct 31, 2002 4:47 pm
Location: Liverpool
Contact:

Re: General Waffle with embedded Excel query

Post by Rich » Tue Feb 17, 2015 12:38 pm

You forgot the 1000 watt amp to go between the pc and the speakers.

Oh - and any elephants in the rooms above you ? I think there are some in my hotel....
Regards

Rich

Image
Abap KC:http://www.richard-harper.me.uk/Kb
SFMDR:http://www.se37.com

Snowy
Posts: 28789
Joined: Mon Oct 21, 2002 2:33 pm
Location: 3.1415926535

Re: General Waffle with embedded Excel query

Post by Snowy » Tue Feb 17, 2015 1:37 pm

deactivate recalc:
http://www.howtogeek.com/162219/how-to- ... xcel-2013/


for noise, hit the wall or ceiling when people make too much noise.
SapFans Moderator

Search: http://www.sapfans.com/forums/search.php
Notes: http://service.sap.com/notes
Help: http://help.sap.com
Rules: http://www.sapfans.com/forums/viewtopic.php?t=344127

Post Reply