Go Back   { mindfrost82.com } > Gadget Corner > Tech Newsgroups > Microsoft > MS Office > Excel

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 07-23-2008, 11:29 PM
=?Utf-8?B?VGltbXlNdXI=?=
 
Posts: n/a
Troubleshooting issues with Excel

I couldn't find Excel Troubleshooting section thus decided to post my
question in Excel section. Currently couple of my power users who use Office
2007 Enterprise Edition w/SP1 applied and all the patches started experience
problems with Excel. Both will work with Excel in normal fashion and than,
after few hours of work all of the sudden program has a screen redraw style
issue. Menu options disappear and so on. So the excel window remain open
but where the tool bar options are there is just blue space. When you close
excel the menu that opens to ask you to save your program also does not
display properly. You can work out where the button is roughly and press the
save button. Than user presented with prompt that file couldn't be saved as
there are no resources available. And these are new Intel Core 2 PCs from
Dell with 2GB of RAM. I did my research and found that I'm not alone -

http://www.pcreview.co.uk/forums/thread-3313471.php
http://www.decisionmodels.com/memlimitsc.htm
http://www.experts-exchange.com/Soft... 2+2007+excel

these just few of the links I found where folks referring to basically same
problem I have. And worse part is - no one yet to figure out why this is
happening. Anyone here might have an answer?
Reply With Quote
  #2 (permalink)  
Old 07-24-2008, 12:21 AM
Ron Rosenfeld
 
Posts: n/a
Re: Troubleshooting issues with Excel

On Wed, 23 Jul 2008 16:29:02 -0700, TimmyMur
<TimmyMur@discussions.microsoft.com> wrote:

>I couldn't find Excel Troubleshooting section thus decided to post my
>question in Excel section. Currently couple of my power users who use Office
>2007 Enterprise Edition w/SP1 applied and all the patches started experience
>problems with Excel. Both will work with Excel in normal fashion and than,
>after few hours of work all of the sudden program has a screen redraw style
>issue. Menu options disappear and so on. So the excel window remain open
>but where the tool bar options are there is just blue space. When you close
>excel the menu that opens to ask you to save your program also does not
>display properly. You can work out where the button is roughly and press the
>save button. Than user presented with prompt that file couldn't be saved as
>there are no resources available. And these are new Intel Core 2 PCs from
>Dell with 2GB of RAM. I did my research and found that I'm not alone -
>
>http://www.pcreview.co.uk/forums/thread-3313471.php
> http://www.decisionmodels.com/memlimitsc.htm
> http://www.experts-exchange.com/Soft... 2+2007+excel
>
>these just few of the links I found where folks referring to basically same
>problem I have. And worse part is - no one yet to figure out why this is
>happening. Anyone here might have an answer?



Please post back if you discover a solution.
--ron
Reply With Quote
  #3 (permalink)  
Old 07-24-2008, 12:39 AM
Harlan Grove
 
Posts: n/a
Re: Troubleshooting issues with Excel

TimmyMur <Timmy...@discussions.microsoft.com> wrote...
>I couldn't find Excel Troubleshooting section thus decided to post
>my question in Excel section. Currently couple of my power users
>who use Office 2007 Enterprise Edition w/SP1 applied and all the
>patches started experience problems with Excel. Both will work with
>Excel in normal fashion and than, after few hours of work all of
>the sudden program has a screen redraw style issue. *Menu options
>disappear and so on. *So the excel window remain open but where the
>tool bar options are there is just blue space. . . .


Office 2007 includes Excel 2007, which uses the bloody wonderful
ribbon. There are no menus or toolbars. Do you mean items in the
bloody wonderful ribbon disappear?

> . . .*When you close excel the menu that opens to ask you to save
>your program also does not display properly. . . .


Details?

> . . .*You can work out where the button is roughly and press the
>save button. Than user presented with prompt that file couldn't be
>saved as there are no resources available. And these are new Intel
>Core 2 PCs from Dell with 2GB of RAM. I did my research and found
>that I'm not alone -

...

What other software is running on these users' machines when these
problems occur? It's possible it's a resource issue, and there may be
some service or application with a memory bug that slowly but surely
consuming ever more memory even if it's not the foreground task. Have
these users run Task Manager just after this problem occurs and check
system resources.

Also, video may be a problem. Even though these are new machines,
check for newer video and printer drivers.
Reply With Quote
  #4 (permalink)  
Old 07-24-2008, 02:40 AM
Ron Rosenfeld
 
Posts: n/a
Re: Troubleshooting issues with Excel

On Wed, 23 Jul 2008 17:39:20 -0700 (PDT), Harlan Grove <hrlngrv@gmail.com>
wrote:

>What other software is running on these users' machines when these
>problems occur? It's possible it's a resource issue, and there may be
>some service or application with a memory bug that slowly but surely
>consuming ever more memory even if it's not the foreground task. Have
>these users run Task Manager just after this problem occurs and check
>system resources.
>
>Also, video may be a problem. Even though these are new machines,
>check for newer video and printer drivers.


I suspect you are correct about the video. Although I've got the latest
drivers, and also made some minor changes in certain settings suggested by
others, the problem persists, although it seems less frequent.

The problem will also occur when booting into a mode where msconfig has been
used to disable everything except Microsoft services. So I do not think it is
an interfering, non-office program.

It occurs after some variable period of time. On this machine, it will occur
more quickly with the program open but blank, than with a worksheet present.
Some of the characteristics are that the ribbon may be missing or "fractured",
the menu bar may or may not be present. Different components may be drawn in
different places on the screen. Occasionally there will be a message about
insufficient resource to perform the operation (and that message box will be
incompletely displayed). On the task bar, right-clicking the program icon
brings up a box filled with black (my normal is white). As I move the cursor
within that small box, the different lines (maximize, restore, close, etc)
appear in "reversed print" (i.e. white on black).

There are some who think a common denominator is dual monitors. I'm not
convinced but my machine here is a dual monitor machine. At another home, I
have Excel 2007 on a single monitor machine, but I've not used that long enough
to definitely state whether this video disruption is a problem there, too.

Both of my video cards are NVidia based. Both of my CPU's are Intel.

If the problem does not occur on my other machine, it may lend some credence to
the dual monitor being an issue. But it'll be six months or so before I'll be
able to test that hypothesis.

Machine with dual monitors:

Intel Core 2 Duo E6700 Conroe 2.66GHz
EVGA 256-P2-N554-AX GeForce 7600GT 256MB

Machine with the single monitor:

Intel Pentium D 950 Presler 3.4GHz (also a dual core)
EVGA 512-P2-N570-AX GeForce 7900GTX 512MB

Both machines have Intel Motherboards, 2GB RAM, Windows XP SP2; and both the
motherboards and video cards are at the default settings except for one bios
tweak on this dual monitor machine (increasing PCI Latency to 128) that seemed
to decrease the frequency of this corruption.

Any other thoughts, Harlan?
--ron
Reply With Quote
Reply

  { mindfrost82.com } > Gadget Corner > Tech Newsgroups > Microsoft > MS Office > Excel


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are Off
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT. The time now is 02:48 AM.


Powered by vBulletin, Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.1.0 ©2007, Crawlability, Inc.
© 1999-2008 mindfrost82.com v11.0

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109