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

General Waffle with embedded Excel query

Postby 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.
Squarebear
 
Posts: 230
Joined: Thu Apr 17, 2003 8:24 am
Location: UK

Re: General Waffle with embedded Excel query

Postby 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
Gothmog
 
Posts: 1941
Joined: Wed Sep 12, 2007 4:46 am
Location: Probably not home

Re: General Waffle with embedded Excel query

Postby 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.
Squarebear
 
Posts: 230
Joined: Thu Apr 17, 2003 8:24 am
Location: UK

Re: General Waffle with embedded Excel query

Postby 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
Gothmog
 
Posts: 1941
Joined: Wed Sep 12, 2007 4:46 am
Location: Probably not home

Re: General Waffle with embedded Excel query

Postby 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
Rich
 
Posts: 7112
Joined: Thu Oct 31, 2002 4:47 pm
Location: Liverpool

Re: General Waffle with embedded Excel query

Postby 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
Snowy
 
Posts: 28767
Joined: Mon Oct 21, 2002 2:33 pm
Location: 3.1415926535


Return to General Talks

Who is online

Users browsing this forum: No registered users and 4 guests





loading...


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