Submitted by d bartlett on 2010/04/19 12:08
Hi,
I have encountered a situation where it would appear that InfoQube is either somehow clogging-up Windows memory and/or is in conflict with MS Excel 2003.  With IQ open in the background and then cutting and pasting data internally within MS Excel 2003 I consistantly get a Win error message saying insufficient memory to handle the request, would I like to abort, I respond yes, and then Excel crashes.  Happening with IQ Pre-Rel-23 as well as previous releases.  I in fact must reboot Windows after the Excel crash because performance of all programs is slow and clunky.  I do work with MS Word all the time too, copying and pasting internally, have never had the problem working in Word.  Right now the only way I can work with Excel 2003 is to close IQ.  I am NOT a techie computer guy and don't have the time/inclination to try to investigate further and/or debug, but am reporting the issue so it's known by others higher up the skills/gifts totem pole.
thanks
Doug Bartlett

Comments

I use MS Excel 2003 too and I haven't been able to reproduce what you describe.
 
Are Excel and IQ the 2 only opened desktop applications when that happens ?

d bartlett

2010/04/19 22:07

Permalink

Hi Armando, 
Interesting.  Typcially I'm working with IQ, Outlook 2003, Win Explorer and Acrobat 9 Pro (mulitple docs) all open, together with a mix of multiple Word 2003 docs, Win Internet Explorer and sometimes Visual Cadd 5 and sometimes Excel 2003 and sometimes Bridge & Photoshop 4.  If I don't do any internal copy and paste in Excel then I can keep IQ open, any significant data-loaded copy and paste - and especially undo/redo after copy/paste - and Excel crashes, close IQ, no Excel crashes.  I realize it could be Excel too, or my 3 yr old HP Compaq nw8440 laptop c/w Windows Service Pak 3 as well as umpteen dozen other Win Security Updates.
thanks,
Doug Bartlett

Armando

2010/04/19 23:10

Permalink

Hi Doug,
You could try just copying and pasting in Excel with just IQ and excel running, see what happens and report back. Yes, it could be a GDI resource problem or some other memory problem :  you keep many heavy apps open at the same time (I do the same)...
Good Luck !

d bartlett

2010/04/20 08:24

Permalink

Hi Armando, thanks for your thoughts.  I have been thru the exercise of running only IQ and Excel concurrently and experienced the same conflict and subsequent crash even in that scenario.  For what it's worth, and remember I'm not a gifted/skilled computer techie, Excel would seem to have to be at least equally responsible because with all the programs I'm typically running I'll absolutely load up Windows memory and clipboard with reckless abandon - with IQ open and functioning, typically with 6 grids open - and have never once experienced the same conflict.  Thanks.  Doug Bartlett

Armando

2010/04/20 12:40

Permalink

Hi Doug,
Are there any special add-ons or pluggins you're using in excel ?
If yes, you could try deactivating all of those, see if it works, and then reactivate them one at a time.
Good luck !

Pierre_Admin

2010/04/19 23:20

Permalink

Sorry folks if I'm not here often, busy with other work.
 
Currently, IQ uses quite of bit of GDI resources. If using lots of concurrent applications, try keeping max 2-3 grids open at any one time. The task manager also report GDI usage, you can report what these are when crashes occur
 

Armando

2010/04/19 23:34

Permalink

Yes, that's quite right.
 
Note that it's possible to allow more resources to GDI objects though. I did it successfully a while ago... :)
Involves one or two registry tweaks, and it's not complicated at all. However, like all registry manipulations, one needs to be careful.
 
A few articles explain how to do it :