Spreadsheet shows through desktop

B

Billy

Hi,

I would bet this is a simple one to figure out.
All of a sudden when I open my XL 2002 spreadsheets,
they all open where the windows and borders are visible/
okay, but the cells are invisible and I can see through
to my desktop. It happens on all sheets, new or existing.
Can someone please help????????

Billy
 
D

Dave Peterson

There have been a few posts about this (I've never seen it up close and
personal).

IIRC, the solutions varied between closing excel and restarting and even
rebooting the pc.

Not much of a solution, huh?
 
D

David McRitchie

Hi Billy,
These have been specifically pointed out for transparency
through to the desktop as opposed to transparency through
to other sheets (ghosting in all versions of Excel).

1. AltTab forward to next Windows application several times
2. Running in code or from the debug window
application.cutcopymode=false
3. Removal of value set in Alternate Startup location
in Tools, Options, General

all seen in this thread
http://groups.google.com/[email protected]

If those don't work then try the rest of the collection of
things to try on ghosting.
http://www.mvps.org/dmcritchie/excel/ghosting.txt

Please report back which works for you. If you have saved a small
workbook without private/personal/proprietory data that can consistently
"cause" the problem that would be of interest. The symptoms and cures
are diverse so there probably is more than one actual problem and cause.
 
N

NancyW

Hi, If you notice I just posted a thread indicating that I have the sam
problem. No clue what's going on. I also posted at allexperts.com an
no one there ever heard of this...hopefully we'll get more help here
 
C

Cheryle

I had this same problem. The tech department determined
that it is a issue with another program that doesn't
allow it to open properly. I don't know what programs you
use, but with mine this problem didn't always happen.
Watch the next time you use it and pay attention to what
other programs you are running. We didn't find a fix for
it, but if you do control-alt-delete and go into task
list, then to processes, look for something that is using
an excessive amount of mem usage, and if you feel
comfortable with it, end the process. The worse thing
that can happen is you will need to reboot your computer
if you stop the wrong process. This doesn't delete
anything from your computer just stops it from running at
the moment.
Now if you don't feel comfortable with that, I am sorry I
don't have a fix, but I have a work-around. With mine, if
I attempted to open a document using its name, that is
when I had this problem. So if I clicked on Transparent
spreadsheet from my desktop, (which is where I keep all
my important files) it would open in the way you
described. I found that if I clicked on the big E
or "Excel the program" so that I saw a grey background
and then go to file-open and found the doc. that way, it
would show it. Try that.
Another tip, if you just need to print and you can't see
the doc, go to print preview and even though you couldn't
see it before, you should be able to see it in print
preview. Weird huh?
 
D

Dan Preston

The quickest solution that I have found for this is to go to Full
Screen view then immediately back to the regular view. Of course, like
the other ideas I have seen posted, this only is a work-around, not a
permanent solution. **sigh**

Dan
 
Top